Analytics Engineer

Lorien; Slough; On-site; GBP 65,000 - 90,000; Full time

Job summary

Lorien is seeking an Analytics Engineer to join a high-profile transformation programme, operating at the intersection of data engineering, analytics, and AI-enabled decision making. You will develop scalable, governed data products and a semantic layer for self-service analytics.

Responsibilities include building pipelines with dbt and Snowflake, mentoring analysts, and ensuring governance across the data stack with Airflow, AWS, and AI-driven analytics solutions.

Qualifications

• Strong SQL and dimensional modelling knowledge.
• Experience building analytics data products for self-service analytics.

Responsibilities

• Translate business requirements into well-structured data models and metrics definitions.
• Design, build and maintain data pipelines with dbt, Snowflake and Airflow.
• Create and manage semantic models and metrics layers for consistent reporting.
• Partner with stakeholders to deliver data products enabling self-service analytics.
• Develop clean, governed datasets for users and AI/LLM-powered apps.
• Migrate legacy reporting into a central, governed data layer.
• Champion analytics engineering best practices including testing and CI/CD.
• Drive data modelling standards, naming conventions and governance.
• Mentor analysts and engineers in modern analytics practices.

Skills

SQL

Dimensional Modelling

dbt

Snowflake

Airflow

Self-service analytics

Stakeholder engagement

Governance

Tools

dbt

Snowflake

Airflow

AWS

Tableau

Power BI

Git

CI/CD

Job description

12-Month Contract | Inside IR35 | 2 Days Onsite at Heathrow

We're looking for an experienced Analytics Engineer to join a high-profile transformation programme, operating at the intersection of data engineering, analytics, and AI-enabled decision making.

This is a fantastic opportunity for someone who enjoys turning complex business challenges into scalable, trusted, and reusable data products. You'll play a key role in defining and building a governed semantic layer that enables self-service analytics, reporting, applications, and AI-driven solutions.

Key Responsibilities

• Translate business requirements into well-structured data models, including conformed dimensions, facts, and metric definitions.
• Design, build, and maintain transformation pipelines using dbt and Snowflake, orchestrated through Airflow.
• Create and manage semantic models and metrics layers to ensure consistent reporting and analytics across the organisation.
• Partner closely with business stakeholders to understand decision-making requirements and deliver data products that support self-service analytics.
• Develop clean, governed datasets that can be reliably consumed by both users and AI/LLM-powered applications.
• Migrate legacy reporting and embedded business logic into a centralised, governed data layer.
• Champion analytics engineering best practices including testing, documentation, version control, and CI/CD.
• Drive standards around data modelling, naming conventions, metrics management, and governance.
• Mentor and support analysts and engineers in modern analytics engineering practices.

Technical Environment

• Snowflake
• dbt
• Airflow
• AWS
• Semantic Layers / Metrics Frameworks
• AI & LLM-enabled analytics solutions
• Advanced SQL skills with strong expertise in dimensional/Kimball modelling techniques.
• Hands-on experience building and maintaining dbt models within Snowflake environments.
• Experience orchestrating data pipelines using Airflow or similar workflow tools.
• Proven experience creating semantic layers and metric models (e.g. dbt Semantic Layer, MetricFlow, Cube, LookML, AtScale, or similar).
• Strong background delivering self-service analytics solutions.
• Experience designing data products and models for AI/LLM consumption.
• Regular use of AI-assisted development tools within engineering workflows.
• Strong understanding of testing, Git-based version control, and CI/CD practices.
• Proven ability to engage with stakeholders and translate business requirements into scalable data solutions.
• Tableau and/or Power BI.
• Experience supporting data consumption through applications and AI agents.
• Data governance, cataloguing, and lineage tooling.
• AWS cloud technologies.
• Experience within operations, engineering, transport, or aviation environment

If you're an Analytics Engineer who enjoys combining robust data modelling, modern cloud technologies, and AI-driven data solutions, we'd love to hear from you.