Data Analyst
If you like finding the real story hidden in a pile of numbers, this is worth trying — but the honest day is a lot of cleaning data and writing the same reports, not constant "aha" insights. In 2026 AI can write the queries and build the dashboards, so the part that lasts is knowing which question is even worth asking.
Worth a look if you like asking sharp questions and you don’t mind the unglamorous cleaning and querying that gets you to the answer. Maybe not if you pictured constant cool insights, or you want an easy way in — the routine starter tasks are being automated.
The work
What you’d actually do all day
The picture is cool insights and storytelling; the reality is mostly cleaning messy data, writing SQL, and rebuilding the same reports each week for whoever asks. In 2026 AI can draft the queries and dashboards, so the part that stays yours is the judgment: asking the right question, checking the AI didn’t quietly get it wrong, and turning the result into a decision someone will act on.
- Data gathering & cleaning50%
- Analysis & modeling15%
- Dashboards & viz20%
- Insight comms & stakeholder5%
- Meetings & admin10%
juniors spend most of their time cleaning/prepping data and building dashboards; seniors spend far less on prep (delegated or automated) and much more on analysis and stakeholder communication.
Rough split, based on how analysts describe the work. Varies by company and tools.
A typical early-career day
- 9:30Take the request
A stakeholder asks "can you pull X." Figure out what they actually need, which is half the work.
- 10:30Pull & clean the data
Get the data and wrestle it into shape — messy, missing, and inconsistent is the normal starting point.
- 1:00Write the query
Write the SQL or analysis to actually answer the question. AI can draft this now — but you steer it.
- 3:00Check it’s really right
Sanity-check the result. A query can run fine and still be quietly, confidently wrong.
- 4:30AI drafts, you judge
AI writes queries and dashboards fast; your value is the question it can’t pick and the error it can’t catch.
A rough analyst day. The repetitive parts are real — and as AI takes them over, the job shifts toward framing questions and judging answers.
Would you actually like it?
In practice, here’s when people realize this is their thing, and when they realize it isn’t.
In practice, people realize it’s their thing when…
- they like turning a vague question into one a pile of data can actually answer
- they’re skeptical by habit — they want to check whether a number is really telling the truth
- they don’t mind the unglamorous cleaning and querying that gets to the answer
- they like being close to real decisions, translating data into something a person will act on
…and it probably isn’t their thing when
- they pictured constant cool insights — most of it is cleaning data and rebuilding routine reports
- they want an easy way in — the routine SQL-and-dashboard work that was the entry path is being automated
- they only want to run queries and build dashboards — that exact skill is what AI now does, so you have to bring the judgment
Start here
Analyze a Real Public Dataset
Pick a question you actually care about, find a real public dataset that can answer it, use AI to help analyze it, and publish a piece that argues a finding with a couple of charts. The hard part — and the whole point — is asking the right question and checking the answer is real, not running the code.
The numbers
The real money and market
A data analyst earns roughly $58–71K starting and $130–150K at the senior end — the lowest barrier to enter of the data jobs, and also the lowest ceiling. Heads up: the "$200K+ in data" numbers you hear are usually data scientists or ML engineers — a separate, higher-paid job analysts often grow into after a few years, not the analyst role itself.
No standalone BLS code; closest is Operations Research Analysts (median ~$90K, May 2024); Data Scientists (15-2051, median $112,590) for the higher tier; Glassdoor / Levels.fyi 2026.
Where it’s going
Demand for data skills is strong and growing — data work is one of the fastest-growing skill areas around. But the role is being rebuilt from the bottom by AI: tools now write SQL from plain English, build dashboards, clean data, and generate reports — automating exactly the entry-level tasks the job was built on. So the work is shifting up, from running queries to framing the question and judging whether the answer holds.
Right now
It’s a growing field, but the bottom rung is eroding: the routine SQL, dashboard, and reporting work that used to be how juniors broke in is the most-automated layer, so a pure "I can run queries" profile is weakening even as overall data demand rises. The field isn’t shrinking — but the easy way in is narrowing, and the analysts who do well use AI to skip the busywork and get fast to the judgment.
Sources: BLS OEWS (Operations Research Analysts; Data Scientists +34% 2024–34, May 2024); WEF 2026 Future of Jobs (AI + big data top skill area); BI-copilot / text-to-SQL coverage (2025–26). Dated June 2026.
The only way to know is to try it.
Pick a project and see how it feels.