Spelthorne, England, United Kingdom
Onsite
Job Description:
Data Modeller / Data Engineer
Salary: From £52,000 plus benefits
Contract type: Permanent
Shift pattern: Full-time – 37.5 hours per week
Location : Hybrid / Any Bupa office – 1-2 days in local office per week
We make health happen
At Bupa, we’re passionate about technology. With colleagues, customers, patients and residents in mind you’ll have the opportunity to work on innovative projects and make a real impact on their lives.
Right from the start you’ll become part of our digital strategy, joining us on our journey and developing yourself along the way.
Role Overview
The Data Modeller / Data Engineer role will Build and develop expertise in designing and delivering modern data pipelines and data models within the Snowflake Data Platform. Contribute to the evolution of the Snowflake Data Platform adopting Data Vault 2.0 and Circular Data Architecture principles.
How you’ll help us make health happen:
Build and maintain end-to-end ELT pipelines using scalable, metadata-driven frameworks and patterns.
Develop high-quality Data Vault 2.0 models (Hubs, Links, Satellites), demonstrating strong understanding of modelling principles and standards.
Design and implement dimensional models (star schemas, marts) to support efficient analytics and reporting use cases.
Investigate and resolve SQL performance issues.
Support Circular Data Architecture product feature roadmap.
Build and enhance the Circular Data Architecture product features.
Create data marts and data products for analytics consumption.
Resolve data issues through to source for internal customers.
Maintain documentation and metadata using tools such as Ellie.ai.
Contribute to quality assurance, testing and reviews.
Proactively identify and manage risks and issues.
Key Skills / Qualifications Needed For This Role
At least 3/4 years experience in enterprise data modelling and data platform development.
Conceptual data modelling.
Proven hands-on experience with Data Vault 2.0, including:
Designing Hubs, Links, and Satellites
Applying business keys and hashing approaches
Understanding of loading patterns and historisation
Strong experience in dimensional modelling, including:
Star schema design
Fact and dimension modelling
Performance and usability optimisation for analytics
Experience applying the right modelling technique for the right use case (e.g., Data Vault vs dimensional vs 3NF).
Experience working with Snowflake or similar cloud data platforms.
Experience building ELT pipelines using SQL and modern data engineering practices.
Familiarity with metadata-driven development and modelling tools (e.g., Ellie.ai).
Experience working with version control and CI/CD tooling (ADO Git).
Strong analytical and problem-solving skills.
Ability to communicate modelling approaches clearly to both technical and non-technical stakeholders.
Experience of full development lifecycle and modern delivery approaches.
Ability to manage workload effectively in a dynamic environment.
Experience in working in a team responsible for both build and run of data products.
Experience in contributing to product roadmap and defining product features and backlog items.
Benefits
Our benefits are designed to make health happen for our people. Viva is our global wellbeing programme and includes all aspects of our health – from mental and physical, to financial, social and environmental wellbeing. We support flexible working and have a range of family friendly benefits.
Joining Bupa in this role you will receive the following benefits and more:
25 days holiday, increasing through length of service, with option to buy or sell
Bupa health insurance as a benefit in kind
An enhanced pension plan and life insurance
Onsite gyms or local discounts where no onsite gym available
Various other benefits and online discounts
Why Bupa?
We’re a health insurer and provider. With no shareholders, our customers are our focus. Our people are all driven by the same purpose – helping people live longer, healthier, happier lives and making a better world. We make health happen by being brave, caring and responsible in everything we do.
We encourage all of our people to “Be you at Bupa”, we champion diversity, and we understand the importance of our people representing the communities and customers we serve. That’s why we especially encourage applications from people with diverse backgrounds and experiences.
Bupa is a Level 2 Disability Confident Employer. This means we aim to offer an interview/assessment to every disabled applicant who meets the minimum criteria for the role. We’ll make sure you are treated fairly and offer reasonable adjustments as part of our recruitment process to anyone that needs them.
Time Type:
Full timeJob Area:
ITLocations:
Angel Court, London, Bupa Place, Kirkstall Forge, Staines - Willow House, Victory House, BrightonWant to know if this job is worth applying to?