Data and Visualisation Engineer - M&G plc. - #2093951

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

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