About

Analytics EngineerLondon based | Hybrid 1-2 days per week Salary up to £75,000 We are working with a large scale, consumer facing business operating across multiple European markets. Data sits at the heart of how they grow audiences, optimise commercial revenue, and improve digital experiences, and they are continuing to invest heavily in their modern analytics platform. The role As an Analytics Engineer, you will be responsible for transforming raw and curated warehouse data into well modelled, analytics ready data marts. You will work across consumer, digital, and revenue domains, enabling trusted reporting in tools such as Looker, Power BI, and Tableau. This is a hands on role with real influence over modelling standards, semantic definitions, and how data is consumed across the business. Key responsibilities Data modelling and transformation Design and build Kimball style dimensional models and gold layer marts using dbt Develop and maintain dbt pipelines that are performant, tested, and easy to use Partner with Data Engineers to shape upstream data structures and improve handoffs from ingestion to modelling Implement data quality testing using dbt tests and expectations frameworks Semantic layer and analytics enablement Help define and maintain a consistent semantic layer across multiple BI tools Translate technical schemas into clear business concepts such as customers, campaigns, sessions, and revenue Own documentation including data dictionaries, ERDs, and semantic definitions to support self service analytics Modernisation and migration Contribute to the migration of legacy warehouses into Snowflake based models