Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and delivery of analytics models and transformation pipelines.
- Company: A national law firm with a friendly, inclusive culture.
- Benefits: 25 days holiday, flexible pension, volunteering days, and health membership.
- Why this job: Make a real impact by delivering high-quality data in a collaborative environment.
- Qualifications: Expert SQL skills, experience with PySpark, and strong stakeholder management.
- Other info: Join a diverse team committed to social responsibility and community investment.
The predicted salary is between 60000 - 80000 £ per year.
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.
Your Role and What You’ll Be Doing
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
- 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
About You
What We’re Looking For – Essential
- Significant experience working as an Analytics Engineer in a modern data platform environment
- Expert‑level SQL skills and strong hands‑on experience with PySpark
- Deep understanding of dimensional modelling, semantic layers and best practices in analytics engineering
- Experience working with Databricks and Lakehouse architectures
- Strong stakeholder management skills and the ability to translate complex concepts clearly
- A collaborative, proactive mindset with a passion for delivering high‑quality, trusted data
- Experience mentoring or leading other engineers in a technical capacity
- Experience with dbt or similar transformation frameworks
- Understanding of data governance and metadata management
- Exposure to Power BI or other BI visualisation environments
- Familiarity with CI/CD pipelines and automated testing frameworks
- Knowledge of Delta Lake and modern data storage patterns
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.
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.
Senior Analytics Engineer (6041) in Manchester employer: Irwin Mitchell LLP
Contact Detail:
Irwin Mitchell LLP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Analytics Engineer (6041) in Manchester
✨Tip Number 1
Network like a pro! Reach out to current employees at the firm through LinkedIn or other platforms. Ask them about their experiences and any tips they might have for your interview. It’s all about making connections!
✨Tip Number 2
Prepare for those tricky questions! Think about how your experience with SQL and PySpark can solve real problems for the firm. Be ready to share specific examples that showcase your skills and how you can contribute.
✨Tip Number 3
Show off your passion for data! During interviews, express your enthusiasm for analytics engineering and how it can make a difference in the legal field. Let them see that you’re not just looking for a job, but a place where you can thrive.
✨Tip Number 4
Don’t forget to follow up! After your interview, send a quick thank-you note to express your appreciation for the opportunity. It’s a simple gesture that can leave a lasting impression and keep you top of mind.
We think you need these skills to ace Senior Analytics Engineer (6041) in Manchester
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with SQL, PySpark, and analytics engineering. We want to see how your skills align with the role of Senior Analytics Engineer, so don’t hold back on showcasing your relevant projects!
Showcase Your Technical Skills: Since this role is all about data, be sure to emphasise your expertise in dimensional modelling and your experience with Databricks. We love seeing specific examples of how you've tackled complex data challenges in the past.
Highlight Collaboration Experience: We value teamwork here at StudySmarter, so share instances where you’ve worked closely with stakeholders or mentored other engineers. This will show us that you not only have the technical chops but also the collaborative mindset we’re looking for.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it gives you a chance to explore more about our culture and values.
How to prepare for a job interview at Irwin Mitchell LLP
✨Know Your SQL and PySpark Inside Out
As a Senior Analytics Engineer, you'll need to showcase your expert-level SQL skills and hands-on experience with PySpark. Brush up on your knowledge of complex queries and transformation pipelines, and be ready to discuss specific projects where you've successfully implemented these technologies.
✨Demonstrate Your Stakeholder Management Skills
This role requires strong stakeholder management abilities. Prepare examples of how you've translated complex concepts for non-technical stakeholders in the past. Think about times when your communication made a significant impact on project outcomes.
✨Showcase Your Leadership Experience
Since you'll be providing technical leadership and mentoring less experienced engineers, come prepared with stories that highlight your leadership style. Discuss how you've guided teams through challenges and contributed to architectural decisions in previous roles.
✨Familiarise Yourself with the Company Culture
Understanding the firm's commitment to inclusivity and community involvement can set you apart. Research their values and think about how your personal values align with theirs. Be ready to discuss how you can contribute to their friendly and supportive environment.