Analytics Engineer

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

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

Desirable

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)

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.

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. We'll value you for who you are and what you bring. We support each other and push boundaries to achieve incredible things and make a real difference to our clients and communities. We're always looking to support our colleagues to work in a way that works best for them and everyone else, including our clients, the business and the regulators. Please speak to a member of our Recruitment and Onboarding team for more information. 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., 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.