Analytics Engineer

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.

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.

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

• Refactor legacy logic into dbt driven transformations

• Work on medium term projects typically spanning 6 to 9 months to align legacy stacks with modern standards

Technical experience

• Strong SQL experience with Redshift or BigQuery and exposure to Snowflake or another modern warehouse

• Proven experience building production dbt models, tests, and environments

• Solid understanding of dimensional modelling and Kimball principles

• Experience working with semantic or metric layers

• Python experience for analytics or data engineering tasks

• Comfortable working with BI tools such as Looker and Power BI

• Experience working in agile teams using Git based workflows

• Work on a modern data stack with real influence over modelling and analytics standards

• Partner closely with product and commercial teams on high impact use cases

• Hybrid working with flexibility

• Strong investment in learning, development, and long term careers

• Supportive, collaborative data culture with a clear mission around data quality and impact

If you are an Analytics Engineer who enjoys building well modelled data, cares about how analytics is consumed, and wants to work in a business where data genuinely matters, this is well worth a conversation.