Analytics Engineer
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
- Tableau / Power BI
- AI & LLM-enabled analytics solutions
Essential Skills & Experience - 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.
Desirable Experience - 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.
Please apply with your latest CV for immediate consideration.
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.