Senior Data Business Analyst in Dunfermline

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.

M&G is making material investments in its digital and data capabilities, to improve customer experience, streamline processes, improve controls and embed data in the way we operate. We are ramping up a Group-wide data transformation programme to drive material improvements in complex, cross-functional processes operating across Asset Management, Life Insurance and Finance, through better access to data. The programme aims to implement high-impact, data-driven use cases in subsequent, time-boxed waves.

You will be the bridge between what the business needs and what technology delivers. This is a hybrid role – part business analyst, part data specialist – where you will need to roll up your sleeves and analyse source systems directly, not just document what stakeholders tell you. You will translate complex data requirements into actionable specifications, challenge requirements that are unfeasible or technically costly, and ensure data definitions align consistently across business groups. This role is about building permanent, in-house expertise. The initial focus will be a strategic Real Estate data product.

Key accountabilities for this role:

• Lead complex data analysis to validate business requirements – interrogating source systems directly rather than relying solely on stakeholder interviews.
• Work with business stakeholders across Asset Management, Life Insurance and Finance to elicit, identify and document and translate business requirements into functional and non-functional data requirements, ensuring definitions align across business groups.
• Understand and map ETL processes, assessing upstream and downstream data flows, dependencies and interdependencies within the enterprise data architecture.
• Write technical IT change narratives that translate business needs into specifications technology teams can build against, with full traceability. Interrogate and sense-check requirements from a sustainable data perspective, challenging and providing options to the business when requirements are unfeasible or technically costly.
• Interface closely with Data Engineering teams to ensure requirements are accurately converted into built data products.
• Lead data quality assessments and support the development of data-driven improvement strategies, supporting Data Governance & Data Management Colleagues.

Key Skills and Experience:

• Proven expertise combining business analysis with hands-on data skills – you can analyse source systems, not just facilitate workshops.
• Strong understanding of Enterprise Data Platforms, semantic models, and dimensional modelling (star schemas, fact/dimension tables).
• Experience with data architecture principles, ETL processes, and data pipeline concepts.
• Proficiency in SQL for data validation and analysis; familiarity with data visualisation tools and cloud-based data platforms.
• Track record translating complex data requirements into technical specifications in financial services.
• Ability to translate technical data concepts into business-friendly language for diverse stakeholders up to senior leadership level.

Key Behaviours:

• Analytically rigorous – you dig into the detail and validate what you are told rather than taking requirements at face value.
• Constructively challenging – you push back when requirements don’t make sense from a data perspective, while maintaining productive relationships.
• Strong communicator who bridges business and technology teams, translating in both directions.
• Pragmatic problem-solver who balances ideal data solutions with delivery constraints.
• Collaborative across boundaries – works effectively with Data Engineering, business SMEs, and senior stakeholders.

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:

• A valuable pension scheme of 18%, with 13% made up of Employer Contributions and 5% Employee Contributions.
• Share Save and our Share Incentive Plan, together with access to financial wellbeing and support services.
• 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.
• 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.

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