Data Solution Designer

Bupa Insurance Limited; Staines-upon-Thames, Manchester; Hybrid; GBP 69,000 - 83,000; Full time

Job summary

A healthcare-focused insurance company is seeking a Data Solution Designer to support their data strategy from their Staines or Manchester locations. This role involves aligning data solutions with business needs, leading workshops, and developing re-usable data models. Ideal candidates should have robust experience in data engineering design and engagement skills across multiple teams. Benefits include 25 days holiday, health insurance, and a performance-based bonus.

Benefits

25 days holiday

Bupa health insurance

Enhanced pension plan and life insurance

Annual performance-based bonus

Onsite gyms or local discounts

Qualifications

• Experience in Data Engineering Design (ETL, ELT), and modelling approaches such as Data Vault, Inmon, and Kimball.
• Extensive experience in common conceptual data models and logical data modelling across enterprise domains.
• Technical exposure to MS Azure Data Stack - Data Factory, Data Lake Storage, Azure SQL, Azure ML, Power BI.

Responsibilities

• Align solution designs with Bupa's enterprise data strategy and future vision.
• Lead data modelling workshops to define entities and relationships.
• Develop data models in collaboration tools for business stakeholders.

Skills

Data Engineering Design (ETL, ELT)

Data Vault, Inmon, Kimball modelling

MS Azure Data Stack

Snowflake architecture

Stakeholder engagement

Communication skills

Tools

Azure SQL

Power BI

Ellie.ai

FigJam

Job description

Job Description

Data Solution Designer

Location

Staines TW18 3DZ or Manchester M50 3SP

Working Options

Flexible / Hybrid working options (i.e up to 3/4 days WFH)

Employment Type

Permanent - Full time 37.5 hours

Salary

£69,200 - £82,800 (Neg depending on experience)

Bonus Scheme

10% Management Bonus Scheme

We consider all types of flexibility, including locations, hours and working patterns.

About Bupa

We make health happen. At Bupa our vision is to become the most customer‑centric healthcare company.

We're passionate about data and recognise the positive impact it can have on the lives of our customers, patients, residents and colleagues. You will join the Chief Data & Analytics Office (CDAO) in the BGIUK Market Unit, working closely with UK Insurance, Bupa Global, Health Services, Bupa Dental Care and Care Services Business Units (BU).

A key enabler of our strategy is consolidating data from different sources to provide a single, reliable consistent source of data (i.e. reusable datasets) to business teams.

The Data Solutions Designer will work across Bupa business to understand and translate business requirements into solutions that are fully aligned with the organisational, architectural and technology strategies and support delivery to make sure they are implemented correctly. As a Data subject matter expert, you will be responsible for driving best practice, educating Technology and business colleagues on data technologies and delivery, and feeding into Bupa's data strategy.

You will be working as part of an agile multi‑disciplinary squad enabling and amplifying value generated from across Bupa. This role gives you the opportunity to engage with business teams across Bupa and develop the solution designs for creating the valuable, re‑usable domain‑specific datasets that enable democratisation of our data to a wider audience.

How you'll help us make health happen

• Align solution designs with Bupa's enterprise data strategy and future vision.
• Lead data modelling workshops to define entities and relationships.
• Build consensus across Bupa's businesses and teams.
• Develop data models in collaboration tools (e.g. Ellie.ai) for business stakeholders to review and approve.
• Turn business ideas into process outcomes and prototypes that support the data strategy.
• Engage stakeholders to assess guardrails and help create data contracts.
• Work with data stewards and architects to boost data literacy and ensure governance.
• Maintain solution design documentation.
• Present designs for design authority & governance approval.
• Guide delivery teams to maintain solution quality.
• Manage requirements and drive results using collaborative and best‑in‑class data solutions.

Key Skills / Qualifications needed for this role

Essential

• Experience in Data Engineering Design (ETL, ELT), and modelling approaches such as Data Vault, Inmon, and Kimball.
• Extensive experience in common conceptual data models and logical data modelling across enterprise domains, including presenting, reviewing and approvals.
• Technical exposure to MS Azure Data Stack - Data Factory, Data Lake Storage, Azure SQL, Azure ML, Power BI.
• Strong understanding of Snowflake architecture, including DevOps integration and CI/CD practices.
• Foundational knowledge of Azure cloud infrastructure.
• Skilled in stakeholder engagement, including facilitating workshops and translating business context into data models.
• Strong communication skills to liaise with both technical developers and non‑technical stakeholders.

Highly desirable

• Ability to align data solutions with organisational data strategy and governance frameworks. Proficiency in collaborative modelling tools such as Ellie.ai and FigJam for workshop facilitation.
• Knowledge of data governance principles including data stewardship, data quality, and compliance guardrails.
• Exposure to emerging data technologies and trends, with a passion for continuous learning.
• Self‑driven and motivated individual with a proactive approach to solution design and delivery.
• Experience of data programmes and technologies within enterprise‑scale organisations or technology teams.
• Familiarity with data governance concepts including data quality, lineage, lifecycle management, and security.

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
• Annual performance‑based bonus
• 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.

Job Details

Time Type: Full time

Job Area: IT

Locations: Bupa Place, Staines - Willow House