Data & Product Administrator Are you highly organised with a passion for data accuracy and process improvement? Do you enjoy working with…
Our purpose is to give everyone real confidence to put their money to work. With a heritage dating back more than 175 years, we have a long history of innovation in savings and investments, combining asset management and insurance expertise to offer a wide range of solutions.
Our two distinct operating segments, Asset Management and Life, work together to provide access to balanced, long-term investment and savings solutions.
Through telling it like it is, owning it now, and moving it forward together with care and integrity; we are creating an exceptional place to work for exceptional talent.
We will consider flexible working arrangements for any of our roles and also offer work place accommodations to ensure you have what you need to effectively deliver in your role.
The Role
Working within Life Data, MI and Analytics as part of the wider Data, MI and AI team, the Data & Visualisation Engineer sits within a broader team of engineers covering the full spectrum of data engineering and visualisation engineering. This team is responsible for delivering high-quality data products, MI, reporting, and insight generation across the Life business.
Whilst the role can span both data engineering and visualisation, we are currently recruiting for positions with a stronger emphasis on data engineering capabilities to support our growing data product programme.
The Data & Visualisation Engineer is responsible for turning data into decisions; engineering reliable datasets and creating clear, business oriented visualisations that enable confident decision making. Collaborating closely with business stakeholders, you will translate their needs into well-designed data models, semantic layers, shared datasets, and repeatable data products, as well as provide insight through reporting; making complex information understandable and actionable. You will own and deliver elements of our workstack, translating complex and ambiguous requirements into clear delivery, and helping the business to use trusted, high-quality data that is delivered on time, to the right standard, and aligned to the outcomes that matter most for customers and the business.
What you'll be accountable for
Building usable Data • 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.
Bringing insight to Life • 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.
Data Quality and Reliability • 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.
Delivery excellence • 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.
Stakeholder management and requirements gathering • 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.
What success looks like
Skills, knowledge and experience
Essential
Stakeholder Engagement & Elicitation • 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.
Data Modelling, Architecture and Semantics • 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 optimisation, and calculation reuse. • Understanding of ontologies, business glossaries, and semantic layers; ability to map business concepts into consistent structures.
Data Engineering • Proficiency in SQL including window functions, set-based logic, optimisation. • Experience with modern data platforms (Azure, Databricks, Lakehouse patterns). • Knowledge of ELT/ETL pipelines, incremental processing, job orchestration and version control. • Exposure to API-based integration, JSON and other programming languages (e.g. Python) Visualisation and BI • Strong Power BI development skills: data modelling, DAX, visual design and performance tuning. • Ability to design intuitive dashboards with clear KPIs, navigation, and action-orientated insights.
Quality, Controls and Documentation • Experience profiling data, building DQ rules, validating metrics, and documenting logic. • Ability to create clear runbooks, technical specs, and business-friendly documentation.
Communication and C
Neutral 2–4 sentence summary of what working at this company is like, drawn from public reviews and press coverage. Tone, collaboration style, pace, benefits highlights.
£45,000 – £60,000 (Glassdoor, Levels.fyi, 2025)
Data & Product Administrator Are you highly organised with a passion for data accuracy and process improvement? Do you enjoy working with…
Our purpose is to give everyone real confidence to put their money to work. With a heritage dating back more than 175 years, we have a long…
About the Company This fast-growth organisation is leading the decarbonisation revolution, specialising in providing responsible solutions t…
Head of Analytical Data and Data Science Location: Bristol, Birmingham, Manchester, Norwich, York, Eastleigh, Perth or London Salary: Circa:…
Data & AI Senior Project Manager - £600 per day - Outside IR35 - Hybrid working 3 days a week on site near Manchester Airport - 6 months int…
Quantum Systems ist ein global führender Anbieter fortschrittlicher UAV-Lösungen und kombiniert modernste Flugtechnologie mit intelligenter…