🚀 Our mission is to create tech that makes a difference, empowers teams, delights customers, and shapes the media world of tomorrow

We’re one of the leading media advertising companies with over 33,000 advertising sites across the UK and EU.

As part of the global Bauer Media Group, we’re committed to being both a platform for brands and a platform for good. From Netflix, Disney, The National Lottery, Heineken and many more, we advertise for some of the best brands which reach millions of people every day! We don’t just sell space, we deliver impact for our clients and value for the communities we serve.

📍London - 2 days a week | 💰 Salary for this role is dependant on your experience, you’ll also receive bonus + benefits

About The Role

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

What you’ll be doing

- 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 (Commercial, Finance, Operations etc)

What you’ll bring to the team

- 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

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

Don't have it all? Bauer is a great place to learn so we still welcome your application!

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 believe in fairness and as an equal opportunities employer we work hard to foster an inclusive environment, a place where you can truly be yourself and be treated fairly. We’re interested in what you can do, not just what you’ve done. Even if you don’t meet every requirement listed, we’d still love to hear from you!

If you need this job description in another format or need any adjustments for your application/interview process, please let us know at careers@bauermediaoutdoor.com