Data and Visualisation Engineer

M&G plc

Data & Visualisation Engineer focusing on delivering high-quality data products and visualisations for the Life business at M&G. Collaborating with stakeholders to ensure reliable and actionable data insights.

Posted 6/19/2026full-timeEdinburgh • 🇬🇧 United KingdomMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AzureETLPythonSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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
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)

Benefits

Comp & perks

Valuable pension scheme of 18%, with 13% made up of Employer Contributions and 5% Employee Contributions
Share Save and Share Incentive Plan
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
Market leading Inspiring Families policy includes comprehensive support and paid parental leave covering maternity, adoption, surrogacy, and paternity leave
Health & Protection cover including Private Healthcare, Critical Illness cover and Life Assurance for you, with family options.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data modelingDAXSQLELTETLAPI integrationPythonAzureDatabricksLakehouse patterns

Soft Skills

communicationcollaborationproblem-solvingroot-cause analysisrequirement gatheringnegotiationdocumentationstakeholder engagementiterative improvementfeedback incorporation