Analytics Engineer

About Chemist4U
Chemist4U is one of the UK’s largest online pharmacies, making medicines, expert advice, and everyday health essentials easier to access than ever. With a fast-growing, innovative team, we deliver trusted pharmacy care straight to our customers’ doors. Join us and be part of a company that’s transforming healthcare and making a real difference every day.

Our purpose
Making medication and care faster, simpler and safer so people stay well for longer.

Our mission
Empower everyone to take control of their health by providing world class technology and pharmacy services.

Our values

• Collaboration
• Integrity
• Positivity
• Growth
• Customer centricity

We simplify processes and medication management by leveraging cutting-edge technology and empowering our team. Whether through seamless online services or expert support, we ensure reliable and hassle-free healthcare so our customers can focus on their well-being.

About the role
Reporting to: Senior Data Engineer
Job type: Full time, Permanent
Salary: Competitive
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:

Data Model Development

• 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.

Essential:

• 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.

Desirable:

• 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…