At a Glance
- Tasks: Transform raw data into business-ready models for reliable reporting and analytics.
- Company: Join a forward-thinking Data Enablement team in a dynamic tech environment.
- Benefits: Enjoy competitive pay, flexible work options, and opportunities for professional growth.
- Why this job: Make an impact by modernising data solutions and collaborating with diverse teams.
- Qualifications: Strong SQL skills and hands-on experience with dbt and BI tools required.
- Other info: Be part of an agile squad with excellent career advancement potential.
The predicted salary is between 36000 - 60000 £ per year.
About the Role
We’re looking for an Analytics Engineer to join our Data Enablement team. In this role, you’ll turn raw data into well-structured, business-ready models that enable reliable reporting and analytics. You’ll work with modern tools like dbt, Snowflake, and BI platforms such as Looker, Power BI, and Tableau to create a semantic layer that ensures consistent metrics and insights. This is a hands-on engineering role with a strong business focus. You’ll collaborate with Data Engineers, DevOps, and business stakeholders to modernize our data estate and deliver high-quality, trusted data solutions.
Key Responsibilities
- Design and build dimensional data models and marts using dbt and Kimball principles.
- Develop and maintain dbt pipelines for transforming raw data into gold-layer marts.
- Define and maintain a semantic layer for consistent metrics across BI tools.
- Contribute to the migration from Redshift/BigQuery to Snowflake.
- Implement data quality checks using dbt tests and Great Expectations.
- Collaborate in agile squads, participate in code reviews, and maintain documentation.
What We’re Looking For
Must-Have Skills
- Strong SQL skills (Redshift or BigQuery experience; Snowflake preferred).
- Hands-on experience with dbt (models, tests, production environments).
- Solid understanding of dimensional modelling (Kimball-style).
- Familiarity with semantic layer design and BI tools (Looker, Power BI).
- Practical Python experience for data engineering tasks.
- Agile team experience (Jira, Confluence) and Git-based workflows.
- Cloud experience (ideally AWS).
Nice-to-Have Skills
- Advanced Snowflake experience.
- Exposure to Airflow, Great Expectations, and dbt-expectations.
- Familiarity with Tableau and multi-tool BI environments.
- Knowledge of CI/CD, Infrastructure-as-Code (Terraform).
- Industry experience in media, digital audiences, or subscription businesses.
Analytics Engineer in London employer: Bauer Media Group
Contact Detail:
Bauer Media Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects, especially those involving dbt, Snowflake, and BI tools. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling skills. Be ready to discuss your experience with dimensional modelling and how you've tackled data quality checks in past roles.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Analytics Engineer in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Analytics Engineer role. Highlight your SQL skills, dbt experience, and any relevant projects that showcase your ability to turn raw data into business-ready models.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your skills align with our needs. Don’t forget to mention your experience with BI tools and cloud platforms!
Showcase Your Projects: If you've worked on any cool data projects, make sure to include them in your application. Whether it's building data models or implementing data quality checks, we want to see what you've done!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be one step closer to joining our awesome Data Enablement team!
How to prepare for a job interview at Bauer Media Group
✨Know Your Tools Inside Out
Make sure you’re well-versed in the tools mentioned in the job description, especially dbt, Snowflake, and BI platforms like Looker and Power BI. Familiarise yourself with their functionalities and be ready to discuss how you've used them in past projects.
✨Showcase Your SQL Skills
Since strong SQL skills are a must-have, prepare to demonstrate your proficiency. Brush up on writing complex queries and be ready to explain your thought process when solving data-related problems during the interview.
✨Understand Dimensional Modelling
Get a solid grasp of dimensional modelling principles, particularly Kimball-style. Be prepared to discuss how you’ve designed and built data models in the past, and think about examples that highlight your understanding of this concept.
✨Collaborate and Communicate
This role involves working closely with various teams, so be ready to talk about your experience in agile environments and how you’ve collaborated with Data Engineers and business stakeholders. Highlight any specific projects where teamwork was key to success.