Lead Analytics Engineer: Lakehouse, SQL & PySpark

Irwin Mitchell LLP; Birmingham; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

25 days holidays

Pension schemes

Volunteering days

Westfield Health

Job summary

Irwin Mitchell LLP is seeking a Senior Analytics Engineer to lead curated data modelling within our Lakehouse environment, translating business requirements into robust SQL and PySpark pipelines on Databricks. You’ll own the data serving layer, ensure datasets are performant, governed and optimised for analytics deliverables across the organisation.

You’ll mentor the team and contribute to governance and CI/CD standards while partnering with data analysts, architects and business stakeholders to

Qualifications

• Significant experience as an Analytics Engineer in a modern data platform environment.
• Expert-level SQL and strong PySpark experience.
• Deep understanding of dimensional modelling and analytics engineering best practices.
• Experience with Databricks and Lakehouse architecture.
• Strong stakeholder management to translate concepts to analysts and SMEs.
• Collaborative, proactive mindset with a passion for high-quality, trusted data.
• Experience mentoring or leading other engineers.

Responsibilities

• Lead 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 decisions.
• Partner with Data Analysts, Data Architects, Data Engineers and business stakeholders.
• Provide technical leadership, mentorship and guidance to analysts and engineers.
• Contribute to CI/CD, testing and governance standards across the Data Platform.

Skills

SQL (advanced)

PySpark

Dimensional modelling

Analytics engineering practices

Stakeholder management

Mentoring

Tools

Databricks

Job description

Irwin Mitchell LLP is seeking a Senior Analytics Engineer to lead curated data modelling within our Lakehouse environment, translating business requirements into robust SQL and PySpark pipelines on Databricks. You’ll own the data serving layer, ensure datasets are performant, governed and optimised for analytics deliverables across the organisation.

You’ll mentor the team and contribute to governance and CI/CD standards while partnering with data analysts, architects and business stakeholders to