Analytics Engineer

London – Hybrid

Up to £75,000

A growing data function is looking for an Analytics Engineer to help develop well-structured, reliable data models that power reporting, analytics, and decision-making across the organisation. You’ll work across the full transformation layer, shaping clean, trusted datasets and helping bring clarity to complex raw data. If you want to deepen your dbt and SQL expertise, work with modern cloud tooling, and contribute to a high-impact analytics environment, this role offers a strong platform for growth and progression.

Responsibilities

You will:

• Build and maintain dbt models across bronze, silver, and gold layers
• Support the development of clean, well-optimised data models following established Kimball-style principles
• Help design and improve aggregation and transformation logic for analytics use cases
• Work with Data Engineers to understand upstream sources and ensure transformations are reliable and well-structured
• Contribute to data quality checks, testing suites, and documentation of models and pipelines
• Assist in shaping the semantic layer for BI tools, ensuring definitions, metrics, and logic align with business needs
• Collaborate with Analysts, Data Engineers, and product teams to clarify requirements and translate them into model updates

Skills & Experience

You should have:

• Strong SQL skills and experience working with cloud data warehouses (BigQuery, Redshift, Snowflake, etc.)
• Solid experience building models and transformations using dbt
• Understanding of dimensional modelling and data transformation principles
• Exposure to BI tools (Looker, Power BI, or similar) and how they consume data
• Experience working with cloud environments (AWS, GCP)
• Familiarity with basic data quality testing and workflow orchestration concepts (e.g., Airflow)
• Experience working in Agile, cross-functional teams
• Python experience for automation or scripting would be advantageous