Business Intelligence Analyst and Developer

M&G Plc; Stirling; Hybrid; GBP 45,000 - GBP 55,000; Full time

Job summary

A leading financial services firm in Stirling is looking for a Business Intelligence Analyst and Developer to enhance the effectiveness of their sales teams. This role involves creating innovative AI tools and Power BI reports while maintaining strong stakeholder relationships. The ideal candidate will have excellent analytical skills and proven experience with Salesforce and Power BI, driving efficiencies in a fast-paced environment. Flexible working arrangements are offered, along with a comprehensive benefits package.

Benefits

Pension scheme of 18%

38 days annual leave

Private Healthcare

Qualifications

• Experience with Salesforce and building flows.
• Strong Power BI skills, with ability to build models quickly from large complex data sets.
• Analytical mindset with attention to detail and strong problem-solving ability.

Responsibilities

• Creating AI agents, tools, and reports that are innovative and drive efficiencies for our sales teams.
• Designing and developing BI dashboards, reports, and data visualisations using Power BI.
• Collaborating with stakeholders to gather requirements and translate business needs into technical solutions.

Skills

Analytical mindset

Salesforce experience

Power BI skills

Problem-solving ability

Communication skills

Tools

Power BI

Salesforce

Job description

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

We have an exciting opportunity within our business for a Business Intelligence Analyst and Developer. This small team supports the Intermediaries Sales Teams, implementing automated MI and opportunity identification solutions, and creating innovative tools and AI agents that help drive efficiencies across the department. The team works hand‑in‑hand to support local and corporate‑level projects, and owns and reports on all adviser/distribution MI to sales leaders and the M&G Executive.

As a Business Intelligence Analyst and Developer, you will be a key part of the Business Intelligence Team and of the wider Intermediaries Operations team. This role is integral in delivering market‑leading insights and creating tools that drive efficiencies for the wider sales department. It is therefore important that the successful applicant has an innovative and analytical mindset alongside the ability to manage a wide and demanding to‑do list, delivering to fast timescales. This role demands a self‑starter that strives for excellence, and is able to singlehandedly take something from inception to delivery.

You will help design and implement AI Agents, design automations within SF CRMA, hard‑code in SF, and create sleek PBI reports while providing insight through MI of the Distribution channel and adviser market. It is important that you also develop and maintain strong relationships with stakeholders and provide support to Operations Managers in the wider team. You will also need to be pro‑active and spot opportunities to develop yourself and the business.

Key Responsibilities for this role

• Creating AI agents, tools, and reports that are innovative and drive efficiencies for our sales teams.
• Designing and developing AI Agents using CoPilot and CoPilot Studio.
• Designing and developing BI dashboards, reports, and data visualisations using tools such as Power BI.
• Maintaining and enhancing existing CRMA solutions.
• Working with our Salesforce Team, hard‑coding and helping to build new streamlined processes within the CRM.
• Collaborating with stakeholders to gather requirements and translate business needs into technical solutions.
• Maintaining and enhancing existing BI solutions to ensure accuracy, relevance, and performance.
• Always learning and identifying new ways to make best use of our tools, or identifying new tools and solutions that will help us deliver streamlined departmental efficiencies.
• Performing data analysis to identify trends, opportunities, and risks within sales performance and intermediary engagement.
• Being the key SME for local and corporate‑level projects, understanding the needs of Distribution, our sales colleagues, and our data.
• Supporting sales leadership with ad‑hoc analysis and insight to inform strategic decisions.
• Ensuring data governance and compliance with internal policies and external regulations (e.g., FCA).
• Providing training and support to end‑users.
• Continuously improving BI capabilities by staying up to date with industry best practices and emerging technologies.
• Presenting sales analytics back to key stakeholders and senior management at senior management team meetings.
• Helping to implement business change programmes.
• Working collaboratively with colleagues and taking personal accountability to maintain and enhance controls you are responsible for to support improvement of the overall control environment, customer outcomes and a reduction in M&G’s operational risk.

Key Knowledge, Skills & Experience

• Analytical and innovative mindset with attention to detail and strong problem‑solving ability.
• Strong understanding of financial services, particularly intermediary sales and distribution models.
• Experience with Salesforce and building flows.
• Experience building within CRMA of Salesforce.
• Experience hard‑coding within Salesforce.
• Knowledge of sales performance metrics.
• Understanding of regulatory requirements relevant to financial data (e.g., GDPR, FCA guidelines).
• Strong Power BI skills, with ability to build models quickly from large complex data sets.
• Excellent communication and stakeholder engagement skills.
• Ability to manage multiple projects and priorities in a fast‑paced environment.
• Experience of data analysis and reporting, including requirements, data modelling, data mapping and validation.
• Experience working with Agentforce (desirable).
• Experience of working within a project environment.
• Self‑starter with a passion for learning.
• Good communication and stakeholder management skills.
• Initiative to spot areas for improvement in processes.
• Excellent attention to detail, ensuring work is accurate.
• Strong analytical and organisational skills.
• Ability to prioritise and meet deadlines.

Work Level: Experienced Colleague

Reports to: Operations Manager

Department & Team: Business Intelligence Team, Intermediaries Operations – UK Distribution

Recruiter: Phoebe Ewers

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, visit Life at M&G

We have a diverse workforce & inclusive culture

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. We also welcome those who take part in military service and those returning from career breaks. 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: [e-mail]