At a Glance
- Tasks: Shape and enhance our data platform, focusing on data modelling and performance optimisation.
- Company: Join an NHS-focused organisation making a real impact on patients' lives.
- Benefits: 30 days annual leave, discounted gym membership, and funded training.
- Other info: Flexible hybrid working and excellent career growth opportunities.
- Why this job: Work with cutting-edge tools like dbt and Snowflake to solve complex data problems.
- Qualifications: Experience in managing dbt projects and strong SQL skills required.
The predicted salary is between 35000 - 45000 £ per year.
About the role
Reporting to: Senior Data Engineer
Job type: Full time, Permanent
Working Pattern & Hours: Monday-Friday, 37.5 hours per week
Location: Hybrid/Flexible (Office located: Lancashire, WN8)
Key Responsibilities
The successful Analytics Engineer will play a key role in shaping and enhancing our data platform, taking ownership of data modelling, governance, and performance optimisation. They will work collaboratively across teams to deliver reliable, well-structured data models, uphold data quality standards, and support the development of scalable and efficient analytics solutions that drive business insights. The key areas of responsibility include the following:
- Build and maintain data models in DBT Cloud and Snowflake data warehouse
- Work with Data Engineers to identify and integrate new required data sources
- Support continuous improvement of modelling standards, patterns and documentation.
Data Quality and Governance
- Implement automated validation, testing, and anomaly detection within DBT.
- Maintain robust lineage and versioning across models
- Create and maintain data dictionaries, naming conventions, and access frameworks
- Support the adoption of a visualisation platform and development of semantic layer
- Work with the Compliance and Security team and Data Engineers to uphold GDPR and healthcare data standards.
Performance and Cost Optimisation
- Monitor model performance and usage
- Apply best practices in dbt modelling (e.g., incremental updates, DRY development, appropriate uses of stages)
- Help identify inefficient queries and redundant datasets.
Platform Maintenance and Governance
- Monitor, troubleshoot, and resolve model issues
- Contribute to documentation, runbooks, and knowledge-sharing
- Follow team standards for security, governance, and data lifecycle management.
Collaboration and Delivery
- Work with the product team and business stakeholders to understand requirements
- Participate in sprint ceremonies, backlog refinement, and estimation
- Contribute to continuous improvement initiatives and automation and development practices.
About You
The successful Analytics Engineer will be a proactive and motivated professional who is eager to advance their career, particularly in tools such as dbt and Snowflake. They will enjoy solving complex data problems, asking insightful questions, and driving improvements in data quality. With strong communication skills, they will collaborate effectively with analysts, engineers, and non-technical stakeholders to deliver impactful and reliable data solutions.
Qualifications & Experience
The successful Analytics Engineer will have experience managing dbt projects within a cloud data warehouse environment and possess strong SQL skills. They will be familiar with e-commerce, marketing, and CRM datasets, along with version control and CI/CD practices. The skills and experience needed to succeed include the following:
- Experience in managing a dbt project deploying to a cloud warehouse
- Advanced SQL skills and exposure to scripting
- Familiarity with e-commerce, marketing, and CRM datasets
- Experience using version control and CI/CD.
- Exposure to healthcare or other regulated environments
- Experience with GA4 and Google Tag Manager
- Exposure to predictive analytics and Ai.
Company Benefits
Working with an NHS-focused organisation means doing work that truly matters, every day, you’ll help make a real, positive impact on the lives of patients across the UK and Ireland. And that’s just the start. We also offer:
- Discounted gym membership
- Funded training
- Enhanced Maternity & Paternity
- 30 days’ annual leave, including Christmas Day, boxing day, and New Year’s Day, with all other bank holidays flexible to take at your convenience
- Sick Pay Scheme
- Blue light card membership is available
- Free seasonal flu vaccination
We’d love to hear from you, so please apply as soon as possible. The role is open until 29th May 2026 but may close earlier if we receive a high number of applications.
Analytics Engineer in Skelmersdale employer: Chemist4U
Join a forward-thinking NHS-focused organisation that values your contributions and offers a meaningful career as an Analytics Engineer. With a hybrid working model based in Lancashire, you will enjoy a supportive work culture that prioritises employee growth through funded training and generous leave policies, all while making a positive impact on patient lives across the UK and Ireland.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer in Skelmersdale
✨Tip Number 1
Network like a pro! Reach out to current employees on LinkedIn or attend industry meetups. A friendly chat can give you insider info and maybe even a referral!
✨Tip Number 2
Prepare for the interview by brushing up on your SQL skills and dbt knowledge. We want to see you shine, so practice explaining your past projects and how they relate to the role.
✨Tip Number 3
Show off your problem-solving skills during interviews. Be ready to tackle hypothetical scenarios or case studies that demonstrate your analytical thinking and creativity.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are keen to join us directly!
We think you need these skills to ace Analytics Engineer in Skelmersdale
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Analytics Engineer role. Highlight your experience with dbt, SQL, and any relevant projects you've worked on. We want to see how you can contribute to our data platform!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your background aligns with our mission at StudySmarter. Keep it concise but impactful – we love a good story!
Show Off Your Projects:If you've got any personal or professional projects related to data modelling or analytics, don’t hesitate to mention them! We’re keen to see how you’ve applied your skills in real-world scenarios, especially with tools like Snowflake.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be one step closer to joining our awesome team at StudySmarter!
How to prepare for a job interview at Chemist4U
✨Know Your Tools Inside Out
Make sure you’re well-versed in dbt and Snowflake, as these are crucial for the role. Brush up on your SQL skills and be ready to discuss how you've used these tools in past projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of complex data problems you've solved. Think about how you approached the issue, the steps you took, and the impact your solution had on the project or team.
✨Understand Data Governance and Quality
Familiarise yourself with data governance principles and be prepared to discuss how you’ve implemented data quality standards in previous roles. Highlight any experience with automated validation and testing.
✨Communicate Effectively
Since collaboration is key, practice explaining technical concepts in simple terms. Be ready to demonstrate how you’ve worked with non-technical stakeholders to deliver data solutions that meet their needs.
