Will AI Steal My Job? · Role analysis

Data Analyst

O*NET 15-2041.00 ESCO: Data analysts

Changing

Data analysts gather, clean, and analyse structured data to answer business questions — producing reports, dashboards, and visualisations that inform operational and strategic decisions. They work across functions in virtually every industry, turning raw data into actionable insights for marketing, operations, finance, and product teams.

Section 01

Task Map

Task	AI impact	Why
Write SQL queries and data extraction code	🔴 High exposure	AI tools generate SQL from natural language descriptions accurately. Tools like DuckDB with LLM integration and GitHub Copilot make SQL writing significantly faster and accessible to non-coders.
Build dashboards and reports	🟡 Changing	BI tools increasingly have AI features for auto-generating visualisations and narratives, but the analyst's judgment about what to show, how to frame it, and what to leave out remains critical.
Clean and validate data quality	🔴 High exposure	AI-powered data quality tools flag anomalies and clean standard issues automatically. The manual data cleaning that consumed junior analyst time is substantially automating.
Perform statistical analysis on business data	🟡 Changing	AI tools can run standard statistical tests and interpret outputs, but selecting the right analysis for the question, understanding its limitations, and drawing valid conclusions requires trained judgment.
Interpret findings and write analysis summaries	🟡 Changing	AI can draft analysis narratives, but the interpretation that connects data findings to business context — explaining what the numbers mean for specific decisions — requires business and domain knowledge.
Present insights to business stakeholders	🟢 Safe	A live presentation where the analyst explains findings, fields questions, and helps stakeholders understand implications is a communication performance that drives data use within an organisation.
Define and track business KPIs	🟡 Changing	Choosing the right metrics to track business performance — understanding what drives value and how to measure it — requires strategic thinking and organisational understanding that AI cannot supply.
Collaborate with business teams to understand needs	🟢 Safe	Understanding what a business team actually needs from their data — translating vague questions into clear analytical problems — requires active listening and domain understanding.

Section 02

What Stays Human

Business context and decision framing The analyst who understands the business deeply — knows what the marketing team is trying to achieve, understands the constraints the operations team faces, knows which numbers the CEO actually cares about — provides targeted insight that generic AI-generated analysis cannot match.
Critical evaluation of data quality and assumptions Knowing when to trust the data and when to question it — understanding what the collection process actually measured, where the biases are, and what the numbers can't tell you — is professional judgment that protects organisations from making decisions on bad analysis.
Influencing decisions and building data culture The analyst who gets their insights acted upon — who builds credibility, navigates politics, and creates a culture of data-informed decision-making in their organisation — is providing leadership value well beyond technical analysis skill.

Section 03

What to Do Next

Develop advanced analytical and data engineering skills: Python, dbt, Spark, or cloud data platforms. Analysts with engineering capability can build reliable data infrastructure, not just query it. This technical depth significantly differentiates you from AI-assistable basic analysis work.
Build deep domain expertise in a high-value sector. A data analyst who deeply understands financial services, healthcare operations, or supply chain optimisation is providing insights that a generalist tool cannot replicate. Domain knowledge combined with technical skill is the most resilient combination.
Move towards data strategy, analytics engineering, or analytics leadership. The analyst who can design a data strategy, mentor a team, and drive organisational data maturity is providing leadership that scales human capability rather than being replaced by automation. BI and analytics leadership roles are growing in demand and complexity.

Sources: O*NET Online (onetonline.org) · ESCO (esco.ec.europa.eu) · All task data cross-referenced against O*NET occupation profiles. This analysis uses task-level exposure, not occupation-level prediction.