At a Glance
- Tasks: Transform data into trusted models that drive business decisions and support analytics.
- Company: Bauer Media Outdoor, a leader in the advertising world with a tech-driven mission.
- Benefits: Hybrid working, 25 holidays, pension scheme, healthcare plan, and enhanced parental cover.
- Other info: Collaborative environment with opportunities for growth and learning with cutting-edge technology.
- Why this job: Join a digital revolution in advertising and make a real impact with your data skills.
- Qualifications: Deep SQL expertise, experience in data modelling, and strong communication skills.
The predicted salary is between 36000 - 60000 € per year.
About Us
Bauer Media Outdoor is a leader in the advertising world, with a strong presence across 12 markets. Our mission is simple: create tech that makes a difference, empower teams, delight customers, and shape the media world of tomorrow. Technology is central to how we operate. We value transparency, accountability, and real business impact. Our ambition is to build a technology function known for reliable, scalable, and user-focused solutions that genuinely enable the business. If you care about building trusted data foundations that drive decision making at scale, this is the place to do it.
The Role
We are hiring a Senior Analytics Engineer to take ownership of our curated, business-ready data layer. This role sits between data engineering and analytics. Your mandate is clear: transform staged data into trusted, well-modelled datasets and semantic layers that directly support decision making across the business. This is not a pipeline-heavy infrastructure role; it is about data modelling, data quality, and analytical usability. You will own the Gold or Service layer and ensure what reaches Power BI is consistent, performant, and genuinely trusted.
What You Will Be Working On
- Data Modelling and Curation
- Design, build, and maintain scalable dimensional and analytical data models
- Define and enforce data grain, keys, and relationships
- Own slowly changing dimensions, historisation strategies, and conformed dimensions
- Translate business requirements into clear, well-documented, and high-performing models
- Create and maintain a stable Gold layer suitable for Power BI and downstream analytics
- Data Quality and Profiling
- Profile staged datasets to assess completeness, accuracy, and consistency
- Define and implement validation rules and data quality checks
- Partner with upstream engineers to resolve issues at the right layer
- Act as the gatekeeper for what is considered analytics-ready data
- Semantic Layer and BI Enablement
- Build and optimise datasets specifically for Power BI consumption
- Ensure metrics are clearly defined, consistent, and reusable
- Reduce duplication and semantic drift across reports
- Work closely with analysts to ensure models are intuitive and performant
- Business Partnership
You will work closely with stakeholders across Finance, Commercial, and Operations to:
- Clarify definitions
- Validate assumptions
- Sense check outputs
- Translate business questions into structured, modelled datasets
You will be the bridge between technical teams and business users.
What We Are Looking For
- Essential
- 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
- Experience working with BI tools, ideally Power BI
- Hands-on ownership of curated data layers used by the business
- Strong understanding of data quality, profiling, and validation techniques
- Confident communicator, comfortable engaging senior stakeholders and non-technical users
- Desirable
- 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
We care far more about your ability to design and own high-quality analytical models than about specific cloud tooling.
What Success Looks Like
Within your first 6 to 12 months, you will have:
- Delivered clear and trusted Gold layer models adopted across multiple domains
- Reduced confusion and duplication of metrics in Power BI
- Improved time to insight for analysts and stakeholders
- Increased confidence in data correctness across the business
- Shifted the culture from “we have the data” to “we trust and use the data”
Interview Process
- Recruiter screening call
- Technical interview including live task
- Second stage face-to-face presentation
What’s In It For You?
Out-of-home Advertising is a well-established medium undergoing a digital revolution, and one we believe we are uniquely positioned to capture. You will be at the forefront of this journey, working with your peers to lead the way. As part of this, you will get to grow and learn by working with the latest tech, joining with innovative partners, and working with great colleagues on a day-to-day basis. The package will also include:
- Hybrid working model with regular office presence to build team culture and relationships
- 25 paid 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
Senior Analytics Engineer employer: Bauer Media Outdoor
Bauer Media Outdoor is an exceptional employer that champions innovation and collaboration in the advertising sector. With a strong focus on technology and data-driven decision making, employees are empowered to grow their skills in a supportive hybrid work environment. The company offers competitive benefits, including a generous holiday allowance, pension scheme, and enhanced family leave, making it an attractive place for professionals seeking meaningful and rewarding careers.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Analytics Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those at Bauer Media Outdoor. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Prepare for your interviews by diving deep into data modelling and analytics concepts. Brush up on SQL and Power BI, and be ready to showcase your expertise with real-world examples.
✨Tip Number 3
Don’t underestimate the power of follow-ups! After an interview, drop a quick thank-you note. It shows you’re keen and keeps you fresh in their minds.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in being part of our team.
We think you need these skills to ace Senior Analytics Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that align with the Senior Analytics Engineer role. Highlight your SQL expertise, data modelling experience, and any relevant BI tools you've worked with, especially Power BI.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about data and how you can contribute to our mission. Share specific examples of how you've transformed data into trusted insights in previous roles.
Showcase Your Communication Skills:Since you'll be bridging technical teams and business users, it's crucial to demonstrate your ability to communicate complex ideas clearly. Use your application to show how you've successfully engaged with stakeholders in the past.
Apply Through Our Website:We encourage you to apply directly through our website. This way, we can ensure your application gets the attention it deserves and you can easily keep track of your application status.
How to prepare for a job interview at Bauer Media Outdoor
✨Know Your Data Models
Make sure you brush up on your knowledge of data modelling techniques, especially the Kimball approach and star schemas. Be ready to discuss how you've designed analytical models in the past and how they’ve impacted decision-making.
✨Showcase Your SQL Skills
Prepare to demonstrate your deep SQL expertise during the technical interview. Practice complex transformations and performance tuning in a cloud environment, as these skills will be crucial for the role.
✨Communicate Clearly
Since you'll be bridging the gap between technical teams and business users, practice explaining complex concepts in simple terms. Think about examples where you've successfully engaged with senior stakeholders and non-technical users.
✨Understand Business Needs
Familiarise yourself with the business areas you'll be working with, like Finance and Operations. Be prepared to discuss how you would translate business questions into structured datasets that drive insights and decisions.
