Analytics Engineer

Overview

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.

• Lead the design and delivery of curated, analytics-ready dimensional and semantic models
• Own KPI definitions, conformed dimensions and semantic consistency across domains
• Build and maintain complex SQL and PySpark transformation pipelines on Databricks
• Ensure data quality, testing, observability and performance across the curated layer
• Lead modelling design reviews and contribute to architectural decision-making
• Partner with Data Architects, BI developers, analysts and business stakeholders
• Provide technical leadership, mentorship and guidance to Analytics Engineers
• Contribute to CI/CD, testing frameworks and governance standards across the Data Platform

• Essential:
  Significant experience working as an Analytics Engineer in a modern data platform environment
• Essential:
  Expert-level SQL skills and strong hands-on experience with Py Spark
• Essential:
  Deep understanding of dimensional modelling, semantic layers and best practices in analytics engineering
• Essential:
  Experience working with Databricks and Lakehouse architectures
• Essential:
  Strong stakeholder management skills and the ability to translate complex concepts clearly
• Essential: A collaborative, proactive mindset with a passion for delivering high-quality, trusted data
• Essential:
  Experience mentoring or leading other engineers in a technical capacity
• Desirable:
  Experience with dbt or similar transformation frameworks
• Desirable:
  Understanding of data governance and metadata management
• Desirable:
  Exposure to Power BI or other BI visualisation environments
• Desirable:
  Familiarity with CI/CD pipelines and automated testing frameworks
• Desirable:
  Knowledge of Delta Lake and modern data storage patterns

We’re a national law firm with a local reach. Our legal experts are here for you. Whether it’s personal or business, we understand that everyone’s situation is different. But we’re more than just a law firm — we’re a team of people working together to help individuals and businesses navigate life’s ups and downs. Working here you’ll feel a part of our friendly and inclusive environment.

As part of the Irwin Mitchell Group’s onboarding process, all successful applicants are required to complete the group’s employment screening process. This process helps ensure that all new employees meet our standards in relation to honesty and integrity, therefore protecting the interests of the Group, colleagues, clients, partners and other stakeholders. We carry out pre-employment screening to establish your eligibility to work in the UK, criminal record and financial checks with our trusted 3rd parties.

The employment screening process will fully comply with Data Protection and other applicable laws.

• 25 days holidays as standard plus bank holidays (option to buy up to 5 additional days)
• Generous and flexible pension schemes
• Volunteering days — Two days of volunteering every year for a cause of your choice (fully paid)
• Westfield Health membership, with access to medical services and Aviva Digital GP services
• Flexible by Choice programme for hybrid working, subject to role, team and client requirements
• Recognition as a Best Workplace for Wellbeing for Large Organisations (2024)