
The challenge
17 years of raw DOL Excel files
4 file eras that renamed every column
Excel turning job codes into calendar dates
9 million rows of human-entered text
Column alias convergence
Every historical name gets rewritten to one canonical column before any downstream logic runs. Four file eras, one language.
17 files, none alike
Column count per fiscal year. FY2019 jumps to 260 columns because the DOL added up to 10 worksite slots per case.
What it actually answers
Ask by company, role, city or year. Get the salary ranges that were actually filed with the government, pulled from 9 million real filings.
How much does Google pay a Software Engineer?
Google LLC
Software Engineer · Mountain View, CA · 2024
Amazon.com Services
Data Scientist II · Seattle, WA · 2024
Meta Platforms
Software Engineer, ML · Menlo Park, CA · 2024
Apple Inc
Software Engineer, Systems · Cupertino, CA · 2024
Sample rows from FY2024 filings. Also plugs into any AI — ChatGPT, Claude, Cursor — through MCP, so they can pull salaries on request.
Have a similar challenge?
Let's figure out what your project needs.