# Will AI replace Data Analysts?

> Basic reporting and SQL querying is fully automated by AI agents, meaning analysts must become strategic business partners to survive.

## Assessment

- **Occupation:** Data Analyst
- **Industry category:** Tech
- **Substitution probability:** 75% of the role's current task mix is reachable by generally-available AI
- **Risk rating:** High
- **Growth outlook:** Contracting
- **Typical salary range:** $65k - $140k (Burtch Works 2026 Salary Study)
- **AI adoption stage in this role:** Late Majority
- **O*NET code:** 15-2031

## Tasks most exposed to automation

- Basic SQL query writing
- Standard dashboard creation
- Data cleaning and deduplication

## Defensible strengths

- Business metric definitions
- Executive-level data storytelling
- Cross-department strategic alignment

## Skills to retire

- Basic SQL scripting
- Manual Excel Pivot Tables
- Standard Tableau Dashboarding

## Skills to acquire

- Strategic Data Storytelling
- Advanced Prescriptive Analytics
- Executive Communication

## Recommended pivot

Data Strategist

## Immediate action

Stop building dashboards that no one reads. Focus on 'Prescriptive Analytics'-telling the executive exactly what action to take.

## Interview positioning

Emphasize your 'Business Context'-AI can write the SQL, but it doesn't know why marketing needs the data formatted for Q3 strategy. You do.

## Grounding sources

- Oxford (Frey & Osborne): 61% risk — https://www.oxfordmartin.ox.ac.uk/downloads/academic/The_Future_of_Employment.pdf
- OpenAI (2023): 100% exposure — https://arxiv.org/abs/2303.10130
- BLS 2024: $94,280 Median — https://www.bls.gov/ooh/math/operations-research-analysts.htm

## Comparable roles

- Data Scientist: 52% substitution probability (https://jobsecuritymeter.com/roles/data-scientist)
- Financial Analyst: 68% substitution probability (https://jobsecuritymeter.com/roles/financial-analyst)
- Product Manager: 18% substitution probability (https://jobsecuritymeter.com/roles/product-manager)
- Management Consultant: 28% substitution probability (https://jobsecuritymeter.com/roles/management-consultant)

## Important caveat

This is the median assessment for the occupation. An individual's exposure depends on their actual task mix, seniority and industry, which is why two people with this job title can receive materially different scores from the live assessment at https://jobsecuritymeter.com/roadmap.

---

**Source:** Job Security Meter — https://jobsecuritymeter.com/roles/data-analyst
**Human-readable version:** https://jobsecuritymeter.com/roles/data-analyst
**Last updated:** August 2026
**Attribution:** Free to quote and cite with attribution to Job Security Meter.
**Full site specification for language models:** https://jobsecuritymeter.com/llms-full.txt