Occupation Report · Technology
Analytics Engineers build and maintain the data transformation layers, semantic models, and data products that sit between raw data infrastructure and business-facing analytics tools. Working primarily in dbt, SQL, and Python, they own the logic that powers dashboards, metrics, and self-service reporting across the organisation. The role is relatively well-insulated from automation because it requires close collaboration with both engineering and business stakeholders, and involves complex design judgment that goes beyond code generation.
Last updated: Mar 2026 · Based on O*NET, Frey-Osborne, and live labour market data
AI Exposure Score
Window to Act
AI is increasingly assisting with SQL generation and documentation, but the core design work of analytics engineering — dimensional modelling, semantic layer architecture, and metric governance — requires reasoning complexity that delays meaningful displacement.
vs All Workers
Analytics Engineers sit in the moderate-risk band. While AI code generation tools accelerate much of their technical work, the role's architecture and governance responsibilities provide a meaningful buffer against automation compared to more production-focused analyst roles.
Analytics engineering spans code-heavy transformation work and architectural design. AI accelerates the coding tasks but leaves the design judgment, governance thinking, and stakeholder collaboration largely human-dependent.
| Task | Risk Level | AI Tools Doing This | Exposure |
|---|---|---|---|
|
Automated Documentation & Data Cataloguing
Writing and maintaining dbt model documentation, descriptions, lineage annotations, and data catalogue entries for all data products in the transformation layer.
|
High | dbt Cloud AI (auto-documentation), Atlan AI, Alation AI, ChatGPT |
|
|
Data Transformation Development (dbt)
Writing, testing, and deploying SQL-based data transformation models in dbt to produce clean, business-ready datasets from raw source data.
|
Medium | dbt Cloud AI, GitHub Copilot, ChatGPT Code Interpreter, Microsoft Fabric Copilot |
|
|
Data Quality Monitoring Configuration
Implementing automated data quality tests, freshness checks, and anomaly monitoring across the transformation layer to maintain trust in downstream analytics.
|
Medium | Monte Carlo, Soda AI, Elementary, dbt Cloud tests |
|
|
Dimensional Modelling & Schema Design
Designing star schema, slowly changing dimensions, and fact-dimension relationships to optimise data warehouse query performance and analytical flexibility.
|
Medium | dbt Cloud, GitHub Copilot (schema suggestions), ChatGPT (Kimball pattern guidance) |
|
|
Semantic Layer Development
Defining business metric logic, dimension definitions, and calculation rules in semantic layers to create a single source of truth for KPIs used across BI tools.
|
Medium | dbt Semantic Layer, Looker AI, Cube AI, AtScale |
|
|
BI Platform Integration & Data Product Publishing
Connecting transformed datasets to BI tools, configuring data connections, testing calculated fields, and publishing certified data products for analyst consumption.
|
Medium | Looker AI, Tableau AI, Power BI Copilot, Sigma Computing AI |
|
|
Data Pipeline Testing & Version Control
Writing unit tests for dbt models, managing pull requests, running CI pipelines, and ensuring transformation code is versioned, reviewed, and reliably deployable.
|
Medium | GitHub Copilot, dbt Cloud CI, Elementary, Great Expectations AI |
|
|
Stakeholder Metric & Logic Consulting
Working with business analysts, product managers, and executives to understand metric requirements, agree on calculation logic, and translate business language into technical definitions.
|
Low | ChatGPT (requirements structuring), Notion AI, Confluence AI |
Analytics engineering emerged as a distinct discipline around 2019, driven by dbt's rapid adoption and the need for transformation logic to live in version-controlled code rather than BI tool expressions. AI is beginning to accelerate the coding workflows without yet replacing the design judgment.
2019–2024
dbt and the analytics engineering movement
dbt crystallised analytics engineering as a profession, enabling analysts to write production-grade SQL transformations using software engineering practices. The Kimball dimensional modelling revival and semantic layer emergence created significant new demand for engineers who understood both data modelling and business context. AI code generation (GitHub Copilot, ChatGPT) began assisting with SQL writing but was peripheral to core design work.
2025–2026
AI accelerates code generation; design remains human-led
GitHub Copilot and dbt Cloud AI substantially reduce the time spent writing boilerplate dbt models, transformation SQL, and documentation — tasks that previously consumed large portions of the analyst engineer's day. Automated data cataloguing tools like Atlan AI are completing another traditionally manual workstream. The architectural decisions — semantic layer design, metric governance, and dimensional modelling — still require human expertise and stakeholder alignment.
2027–2034
AI-generated transformation layers; governance role expands
AI agents will increasingly generate and test entire dbt model layers from natural language specifications, reducing junior analytics engineering work substantially. Senior practitioners will shift toward architectural governance, metric stewardship, and ensuring the semantic layer reflects accurate business logic as AI-generated code proliferates. The role bifurcates into AI automation governer and strategic data product owner.
Analytics Engineers sit in the moderate risk band within data and technology. They face more exposure than architects but significantly less than BI or reporting analysts who focus on production output.
More Exposed
Reporting Analyst
77/100
Reporting Analysts produce the standardised output that analytics engineers build infrastructure for — a much more directly automatable function.
This Role
Analytics Engineer
43/100
Code generation is increasingly AI-assisted, but dimensional modelling, metric governance, and semantic layer design retain significant human complexity.
Same Sector, Lower Risk
Data Architect
37/100
Data Architects operate at a system-wide strategic level with broader contextual and organisational considerations that are harder to automate.
Much Lower Risk
Machine Learning Engineer
35/100
ML Engineers design model pipelines and evaluate algorithm performance — complex research-adjacent work with low repetition and high contextual variation.
Analytics Engineers have deep SQL, modelling, and data product skills that underpin several higher-resilience technical and strategic roles in the data ecosystem.
Path 01 · Adjacent
Platform Engineer
↑ 86% skill match
Resilient move
Target role has stronger structural resilience and materially lower disruption risk — a genuine escape.
You already have: Computers and Electronics, English Language, Reading Comprehension, Active Listening
You need: Administration and Management, Science, Management of Personnel Resources, Administrative
Path 02 · Adjacent
Cloud Architect
↑ 80% skill match
Resilient move
Target role has stronger structural resilience and materially lower disruption risk — a genuine escape.
You already have: Computers and Electronics, Engineering and Technology, Telecommunications, Critical Thinking
You need: Administration and Management, Management of Personnel Resources, Law and Government, Equipment Selection
Path 03 · Cross-Domain
Business Intelligence Manager
↑ 50% skill match
Positive direction
Transitions from technical data engineering to business-focused data leadership roles.
You already have: data pipeline development, SQL/Python skills, data modeling, ETL processes, technical documentation
You need: business strategy alignment, team management, KPI development, executive reporting, data visualization tools
Your personalised plan
Take the free assessment, then get your Analytics Engineer Career Pivot Blueprint — a 15-page roadmap with skill gaps, 90-day action plan, salary data, and named employers.
Free assessment · Blueprint: £49 · Delivered within 1–2 business days
Will AI replace Analytics Engineers?
AI will augment analytics engineering significantly but is unlikely to replace the role in its entirety within the near term. Code generation tools like GitHub Copilot and dbt Cloud AI are already accelerating SQL transformation writing, but the core judgment involved in dimensional modelling, semantic layer design, and metric governance requires contextual business-technical reasoning that AI cannot self-direct. The profession will evolve rather than disappear.
Which Analytics Engineer tasks are most at risk from AI?
Documentation and data cataloguing are the most immediately automated — tools like Atlan AI and dbt Cloud AI can auto-generate descriptions and lineage annotations. Boilerplate dbt model writing and SQL transformation code are increasingly generated by GitHub Copilot and ChatGPT. Data pipeline testing is also progressively AI-assisted. Design work — dimensional modelling, semantic layer architecture, and metric governance consulting — retains the most human value.
How quickly is AI changing Analytics Engineer roles?
Faster than the profession anticipated. Code generation tools became mainstream in analytics workflows during 2023–2024, and dbt Cloud is actively integrating AI features. The core transformation development workflow will look substantially different by 2027, with AI generating first drafts of models that engineers review, refine, and govern rather than author from scratch.
What should Analytics Engineers do to stay relevant?
Deepening expertise in semantic layer architecture, data mesh patterns, and metric governance will position analytics engineers above the AI-automatable threshold. Moving toward data architecture or data product management leverages the cross-functional skills that are hardest to automate. Developing strong AI governance skills — reviewing, testing, and owning AI-generated transformation code — will be a valuable specialism as AI generation proliferates.