Your Role and What You'll Be Doing
At Irwin Mitchell, we are investing heavily in our data capabilities as part of our ongoing digital transformation. Data plays a critical role in how we support our clients, empower our colleagues, and deliver meaningful impact to the communities we serve.
We are now seeking an Analytics Engineer to join our growing Data Engineering & Platforms function. This role sits at the heart of our Lakehouse programme, helping shape how data is modelled, structured and served across the firm.
About the Role
As an Analytics Engineer, you will play a central part in building the curated data layer of our Lakehouse platform. Working closely with Data Engineers, BI professionals and business stakeholders, you will design and deliver high‑quality, analytics‑ready datasets that enable trusted reporting and insight.
You will help define modelling standards, embed data quality principles, and develop robust transformation pipelines that support confident, data‑driven decision making across the organisation.
This is an excellent opportunity for someone who is passionate about data modelling, transformation engineering, and contributing to the foundations of a modern data ecosystem.
About You
What You’ll Do
* Design and build curated, analytics‑ready datasets using dimensional and semantic modelling techniques
* Develop and maintain SQL and PySpark transformations within our Lakehouse environment
* Partner with Data Engineers to optimise the data serving layer
* Translate business requirements into clear, well‑structured data models
* Implement data quality, testing and reliability into transformation pipelines
* Contribute to modelling standards, documentation and architectural decisions
* Collaborate with analysts, BI developers and stakeholders to ensure data is trusted, consistent and fit for purpose
What We’re Looking For – Essential
* Proven experience as an Analytics Engineer or in a similar data‑focused role
* Strong SQL skills, with experience building complex transformations and data models
* Experience working with PySpark and modern data platform environments
* Solid understanding of dimensional modelling and analytics engineering best practice
* Ability to communicate clearly with both technical and non‑technical stakeholders
* A collaborative mindset and a passion for delivering high‑quality, reliable data
* Experience with Databricks or other Lakehouse technologies
* Familiarity with Azure data services
* Exposure to dbt or similar transformation frameworks
* Knowledge of Delta Lake or modern data storage patterns
* Experience supporting BI teams (e.g., Power BI environments)
Our Benefits - What We Can Offer You
* 25 days holidays as standard plus bank holidays - You can ‘buy’ up to 35hrs of extra holiday too.
* Generous and flexible pension schemes.
* Volunteering days – Two days of volunteering every year for a cause of your choice (fully paid)
* 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.
Additional Information
As part of the Irwin Mitchell Group’s on‑boarding process all successful applicants are required to complete the group’s employment screening process. This process helps to 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.
Irwin Mitchell LLP is an equal opportunity employer.
We’re proud of our values, and we’re looking for people who share them
Create an alert subscription based on this vacancy
#J-18808-Ljbffr