Data Modeller / Data Engineer

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.

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

Pulled from the full job description

• Referral programme
• Employee mentoring programme
• Employee discount
• Gym membership
• Life insurance
• Additional leave
• Private dental insurance, 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 time

Job Area: IT

Locations: Angel Court, London, Bupa Place, Kirkstall Forge, Staines - Willow House, Victory House, Brighton Private medical insurance, Financial planning services, Health & wellbeing programme, Cycle to work scheme, Free flu jabs, Company pension, Paid volunteer time, Employee mentoring programme, Private dental insurance, Gym membership, Additional leave, Referral programme

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.