Your Role
and What You'll Be Doing
About the Role
As a Senior Analytics Engineer, you will lead the design and delivery of dimensional and semantic models within our Lakehouse environment. You will translate complex business requirements into high‑performing SQL and PySpark transformation pipelines, ensuring datasets are accurate, governed and optimised for consumption in Power BI and other analytics tools.
You will also provide technical leadership within the team — setting modelling standards, reviewing designs, mentoring less experienced engineers and helping to shape architectural decisions across the Data Platform.
This is a highly influential role that combines advanced technical expertise with strategic thinking, stakeholder collaboration and a passion for delivering trusted, high‑quality data.
What You’ll Do
1. Lead the design and delivery of curated, analytics‑ready dimensional and semantic models
2. Own KPI definitions, conformed dimensions and semantic consistency across domains
3. Build and maintain complex SQL and PySpark transformation pipelines on Databricks
4. Ensure data quality, testing, observability and performance across the curated layer
5. Lead modelling design reviews and contribute to architectural decision‑making
6. Partner with Data Architects, BI developers, analysts and business stakeholders
7. Provide technical leadership, mentorship and guidance to Analytics Engineers
8. Contribute to CI/CD, testing frameworks and governance standards across the Data Platform
About You
What We’re Looking For – Essential
9. Significant experience working as an Analytics Engineer in a modern data platform environment
10. Expert‑level SQL skills and strong hands‑on experience with PySpark
11. Deep understanding of dimensional modelling, semantic layers and best practices in analytics engineering
12. Experience working with Databricks and Lakehouse architectures
13. Strong stakeholder management skills and the ability to translate complex concepts clearly
14. A collaborative, proactive mindset with a passion for delivering high‑quality, trusted data
15. Experience mentoring or leading other engineers in a technical capacity
Desirable
16. Experience with dbt or similar transformation frameworks
17. Understanding of data governance and metadata management
18. Exposure to Power BI or other BI visualisation environments
19. Familiarity with CI/CD pipelines and automated testing frameworks
20. Knowledge of Delta Lake and modern data storage patterns
Our Benefits - What We Can Offer You
21. 25 days holidays as standard plus bank holidays - You can ‘buy’ up to 35hrs of extra holiday too.
22. Generous and flexible pension schemes.
23. Volunteering days – Two days of volunteering every year for a cause of your choice (fully paid)
24. Westfield Health membership, offering refunds on medical services alongside our Aviva Digital GP services.
We also offer a wide range of well-being initiatives to encourage positive mental health both in and out of the workplace and to make sure you’re fully supported. This includes our Flexible by Choice programme which gives our colleagues more choice over a hybrid way of working subject to role, team and client requirements.
We have been ranked in the Best Workplaces for Wellbeing for Large Organisations for 2024!
Our responsible business programmes are fundamental to who we are and our purpose. We’re committed to being a diverse and inclusive workplace where our colleagues can flourish, and we have established a number of inclusion network groups across our business to support this aim.
Our commitment to Social Responsibility, community investment activity and tackling climate change is a fundamental part of who we are. It’s made up of four strands: Our People, Our Community, Our Environment and Our Pro Bono.