Data and Visualisation Engineer

The Role

Working with Life Data, MI and Analytics
, part of the wider Data, MI and AI team, the Data & Visualisation Engineer is responsible for creating and turning data into decisions, engineering reliable datasets and creating clear business-oriented visualisations that support confident decision-making across the Life business.

Collaborating closely with business stakeholders, you will turn their needs into well-designed data models, semantic layers, shared data sets and repeatable data products and provide insight through reporting - making complex information understandable and actionable. You will own and deliver elements of our workstack, helping to translate complex and ambiguous requirements into clear delivery, helping the business use trusted and high-quality data that is delivered on time, to the right standard, and aligned to outcomes that matter most for customers and the business.

• Design, build and maintain ELT pipelines and curated data models aligned to best practice and enterprise strategy/policy.
• Produce well‑governed data products that include documentation and relevant data quality checks.

• Build clean, performant Power BI models and reports using best‑practice DAX, data modelling, and visual storytelling.
• Design self‑service–ready BI assets with intuitive navigation, drill paths, KPIs, and filters.
• Document metric definitions, business rules, and logic in clear, reusable formats.

• Profile, validate, and reconcile source data; embed data quality rules and monitoring.
• Investigate issues using structured root‑cause analysis and partner with SMEs to resolve.
• Maintain documentation, lineage and controls as part of the delivery lifecycle.
• Ensure semantic models and datasets are versioned, documented and released in line with team and enterprise standards.

• Contribute to backlog refinement, estimation and planning.
• Deliver iteratively with quick feedback loops.
• Collaborate closely with stakeholders and SMEs across the business, technology partners, and the wider team.
• Communicate impacts, risks, and trade‑offs clearly and early.

• Partner with business teams (Operations, Propositions, Advice, Distribution, Marketing, Finance and others) to understand desired outcomes, key decisions, and constraints.
• Lead discovery sessions to map current reporting, source systems, dependencies, and pain points.
• Run structured requirement gathering workshops, interviews, and data walkthroughs.
• Translate ambiguous requests into clear requirements (metrics, dimensions, logic, refresh cycles, SLAs).
• Challenge and refine requirements, reconciling conflicting definitions and negotiating pragmatic scope.
• Support and execute testing, incorporating feedback into iterative improvements.

• Stakeholders regularly use your data products and/or reports to make timely, confident decisions.
• Semantic models and definitions are consistent across business areas and reduce rework.
• Data pipelines and visuals are reliable, performant, and easily maintainable.
• Data quality issues are identified, tracked, and resolved, with trends improving over time.
• You make complex concepts simple—your documentation enables others to self‑serve.

• Skilled at understanding business context and converting it into structured data/BI requirements.
• Ability to reconcile conflicting definitions and drive alignment around a shared version of the truth.
• Experience facilitating workshops, walkthroughs, UAT sessions, and iterative review cycles.
• Capture functional and non-functional requirements including data latency, refresh cycles, dependencies, lineage and data sensitivity.

• Hands‑on experience designing data models for the creation of data products and/or the delivery of analytics.
• Experience designing and maintaining shared datasets and semantic layers with versioning and ownership.
• Strong skills in designing Power BI models, including relationship design, DAX…