Data and Visualisation Engineer in London

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 workplace accommodations to ensure you have what you need to effectively deliver in your role.

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.

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

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

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 Collaboration
  • Able to articulate complex issues in simple terms for non‐technical stakeholders.
  • Works effectively with cross‐functional teams and builds strong relationships at all levels.

Desirable

• Experience with CI/CD for Power BI and/or data pipelines.
• Familiarity with workflow and/or CRM systems (e.g., Salesforce, Marketo).
• Experience of working in a Financial, Operational and/or regulated setting.
• Exposure to domain‐driven design, knowledge graphs, or conceptual modelling.
• Relevant technical certifications (e.g. DP‐900, PL‐300, AZ‐900) welcomed.

The successful candidate will

• Put customers and business outcomes at the heart of what they do.
• Take personal responsibility for delivery and data quality.
• Challenge and speak up, offering an opinion and contributing to team discussions and direction.
• Build valued, respectful partnerships across technical and non‐technical teams.

Why this role matters

This enables better customer outcomes, operational efficiency and risk reduction through the delivery and creation of trusted, re‐usable data and reporting which is focussed on business outcomes and supports decision making.

In line with M&G's values, requiring someone who:

• Acts with care and integrity – handling data responsibly and communicating transparently.
• Keeps things simple – focusses on clarity and reusability in both code, metrics and visuals.
• Delivers results – prioritises outcomes, iterates quickly and improves continuously.
• Works collaboratively – collaborating openly across the direct team, wider AI team, Technology and the business.

Job Level: Experienced Colleague

Location: Flexible in UK

Closing Date: 16 March 2026

What we offer:

At M&G, we're committed to helping you thrive and supporting your wellbeing, both at work and beyond. Our benefits are designed to help you balance your professional and personal life, while planning confidently for your future. Our UK benefits include:

• As a savings and Investments firm we are proud to offer a valuable pension scheme of 18%, with 13% made up of Employer Contributions and 5% Employee Contributions.
• We also offer Share Save and our Share Incentive Plan, together with access to financial wellbeing and support services - to help give you real confidence to put your money to work.
• Enjoy 38 days annual leave including bank holidays, with the opportunity to purchase up to 5 extra days and additional flexibility through our Time Off When You Need It policy – to balance your work and personal commitments.
• Our market leading Inspiring Families policy includes comprehensive support and paid parental leave covering maternity, adoption, surrogacy, and paternity leave - as supporting families is a core aspect of our inclusive culture.
• Health & Protection cover including Private Healthcare, Critical Illness cover and Life Assurance for you, with family options - for peace of mind.

To explore more about life at M&G and our full benefits offering, Life at M&G.

We have a diverse workforce and an inclusive culture at M&G, underpinned by our policies and our employee‐led networks who provide networking opportunities, advice and support for the diverse communities our colleagues represent. Regardless of gender, ethnicity, age, sexual orientation, nationality, disability or long term condition, we are looking to attract, promote and retain exceptional people. We also welcome those who take part in military service and those returning from career breaks.

M&G is also proud to be a Disability Confident Leader, and we welcome applications from candidates with long‐term health conditions, disabilities, or neuro‐divergent conditions. If you need assistance or an alternative means of applying for a role due to a disability or additional need, please let us know by contacting us at: careers@mandg.com.