AI IMPACT ROLE DOSSIER · DATA ANALYST
Heavy pressure ahead for data analysts.
AI is taking over more of this work each year. The big workflow changes are settling down. What only a person can do is shrinking. By 2030, the job will look noticeably different — but it's not going away.
Data analysts had a quiet 2024-2026. Their tooling got dramatically better, the role got much more interesting, and they kept their jobs — mostly.
Automation is moderate. Standard SQL writing, routine dashboard build-out, basic ETL. The "go fetch me a number" parts of analyst work mostly happen via Cursor or natural-language-to-SQL tools now.
Augmentation is HIGH. Exploratory analysis at session speed, visualisation iteration, chart selection, statistical sanity checks. A senior analyst in 2026 is closer to "data scientist who can ship" than the 2020 spreadsheet-and-Tableau analyst.
Resilience is medium and easing. What survives: asking the right business question, stakeholder translation between data and decision, data-quality intuition, the gut-feel for "this number can't be right." What's at risk: the role at all, in many companies. AI plus a curious PM is doing 60% of analyst work in some startups. Larger orgs still need analysts as the human in the loop. The pivot path is up into data science, sideways into analytics engineering, or into a domain.
— On the instruments —
— overall reading · 2028 outlook —
HEAVY
Automation rising · augmentation high and edging down · resilience easing.
— automation pressure
how much AI is taking over
↑ rising — Medium → High
— augmentation pressure
how much AI is changing the workflow
↘ edging down — High → Med-High
— human resilience
how much stays stubbornly human
↓ easing — Med-High → Med-Low
Where the pressure lands
— Three lists, one per dial. Automating · Augmenting · Holding. —
Skills automating
- Standard SQL writing and result formatting high ↗ GitHub
- Routine dashboard build-out high
- Basic ETL and data plumbing medium
Skills augmenting
- Exploratory analysis at session speed medium
- Natural-language to query translation high ↗ Microsoft Work Trend Index
- Visualisation iteration and chart selection medium
Skills holding
- Asking the right business question high
- Stakeholder translation between data and decision high
- Data-quality intuition and gut on suspicious results medium
- Statistical rigour for high-stakes calls medium