Analytics Engineer
Role details
Job location
Tech stack
Job description
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.
Requirements
Do you have experience in Scripting?, 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., 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:
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.
Benefits & conditions
Pulled from the full job description
-
Annual leave
-
Employee discount
-
Sick pay
-
Free flu jabs
-
Discounted gym membership, Working with an NHS-focused organisation means doing work that truly matters, every day, youll help make a real, positive impact on the lives of patients across the UK and Ireland. And thats 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 Years Day, with all other bank holidays flexible to take at your convenience
-
Health & Wellbeing benefits
-
Staff discount
-
Sick Pay Scheme
-
Blue light card membership is available
-
Free seasonal flu vaccination
-
Regular social events.