Location
London - 2 days a week

Hours
Full Time

Salary
Salary for this role is dependant on your experience, plus bonus and benefits

About the Role
As we move to consolidate all our data sources into one, this role will sit between the data and analytics teams where you'll transform staged data into trusted, well-modelled datasets and semantic layers that directly support decision making across the business. It involves data modelling, data quality, and analytical usability by owning the gold layer and ensuring what reaches the BI team is trusted.

You will design and maintain scalable dimensional models and high-performing Gold layers optimized for Power BI. Define data grains, relationships, and historization strategies to translate business requirements into documented models. Act as data gatekeeper by profiling datasets and implementing validation rules to ensure accuracy and consistency. Collaborate with engineers to resolve quality issues and maintain integrity across the data pipeline. Build optimized, reusable semantic layers to standardize metrics and eliminate duplication across reporting tools. Partner with analysts to ensure data models are intuitive, performant, and aligned with end-user needs across Commercial, Finance, Operations, and other teams.

What’s In It For You
- 25 paid holidays including bank holidays
- Company Pension Scheme paid up to 8%
- Healthcare Cash Plan
- Life Insurance and group income protection scheme
- Cycle to work scheme
- Enhanced Maternity & Paternity Cover

We are committed to fostering an inclusive environment where you can be yourself and be treated fairly. We value what you can do, not just what you have done. Even if you don’t meet every requirement, we encourage you to apply.

Experience
- Deep SQL expertise including complex transformations, window functions, and performance tuning in a cloud environment
- Proven experience designing analytical or data warehouse models
- Strong dimensional modelling knowledge such as Kimball approaches, star schemas, and aggregates
- Hands-on ownership of curated data layers used by the business
- Strong understanding of data quality, profiling, and validation techniques

About You
- Collaborative and detail-oriented with a focus on data integrity and usability
- Comfortable working across teams to align data models with business needs
- Eager to learn and grow in a fast-paced media advertising environment

Qualifications
While specific qualifications are not listed, relevant experience in data engineering, analytics engineering, or related fields is expected.

Nice to Haves
- Experience with Databricks or similar platforms
- Familiarity with Delta Lake and lakehouse patterns
- Python for analysis, profiling, or orchestration logic
- Exposure to Azure data services such as ADF or Azure SQL