BI Analyst

The Money and Pensions Service; England; On-site; GBP 35,000 - 50,000; Full time

Job summary

A government agency in England seeks a BI Analyst to enable evidence-based decision-making by delivering high-quality insights into funded services. The role involves developing Power BI dashboards, cleaning and analyzing data, and collaborating with teams to enhance data quality. The ideal candidate will possess strong analytical skills, proficiency in Power BI, and the ability to communicate insights effectively. Benefits include generous annual leave and a pension scheme.

Benefits

Generous annual leave

Pension scheme

Interest-free loan for season tickets

Cycle to work scheme

Subsidised eye tests & flu jabs

Life assurance scheme

Paid volunteering

Discounts portal

Qualifications

• Proven ability to deliver high-quality analysis independently.
• Skilled in creating engaging dashboards and visuals.
• Competent in querying and analysing data using relevant tools.

Responsibilities

• Develop high-quality Power BI products with engaging visuals.
• Clean, model, transform, and analyse data for robust models.
• Collaborate with teams to ensure the flow of accurate data.

Skills

Analytical expertise

Power BI proficiency

Data handling & tools

Data governance & management

Problem solving & judgement

Business acumen & communication

Tools

DAX

SQL

Python

Job description

Join us at the Money and Pensions Service (MaPS) as a BI Analyst. This role offers you the chance to make a significant impact by enabling evidence-based decision‑making through high‑quality insight into the services MaPS funds, who is using them, and the wider debt advice landscape. Acting as the conduit between our data, the Debt Team, and the wider organisation, you'll deliver timely, accurate, and meaningful analysis that supports MaPS in fulfilling its statutory function. You'll clean, model, and transform data post‑ingestion to produce insightful dashboards and reports, empower colleagues to work more effectively, and drive data maturity across the organisation. You'll also champion data governance, improve data standards and literacy, and collaborate with internal teams and external partners to develop high‑quality data products that support strategic and operational goals. You'll be part of a dynamic team dedicated to helping people across the UK improve their financial wellbeing. The BI Analyst will report directly to Senior Continuous Improvement Manager.

Responsibilities

• Develop high‑quality Power BI products with engaging visuals that tell the story of the data and provide actionable recommendations to colleagues, including senior leadership
• Clean, model, transform, and analyse data to build robust, well‑governed data models
• Respond to ad‑hoc insight requests by querying and interpreting relevant data
• Drive data maturity and improve data management practices both locally and across MaPS
• Understand the strategic objectives of the Debt Team and translate them into meaningful insight
• Collaborate with upstream and downstream teams to ensure the flow of accurate, timely, and comprehensive data
• Work with internal, supplier, and client data across areas such as operational performance, client profiles, business processes, quality assurance, and outcomes
• Apply statistical methods and models to identify trends, challenges, and opportunities
• Review and improve existing data systems and processes
• Assess and enhance the quality of data collection and reporting practices
• Ensure compliance with data governance policies and legal requirements around data security

Qualifications

• Analytical expertise: Proven ability to deliver high‑quality analysis independently, applying statistical techniques (e.g. forecasting, regression, segmentation) to generate actionable insights and shape project direction.
• Power BI proficiency: Skilled in creating engaging dashboards and visuals, with strong DAX capabilities for building robust data models and measures.
• Data handling & tools: Competent in querying and analysing data using DAX, SQL, Python, or other relevant tools; experienced with diverse data sources including spreadsheets, flat files, and relational databases.
• Data governance & management: Sound understanding of data management principles and adherence to high data governance standards.
• Problem solving & judgement: Strong problem‑solving skills, including validating outputs, applying judgement, and knowing when to collaborate.
• Business acumen & communication: Ability to quickly grasp business context and translate requirements into clear, compelling data stories for both technical and non‑technical audiences.

Desirable Qualifications

• Understanding of the debt advice sector in England
• Background or education in a numerical discipline
• Experience working with both structured and unstructured data
• Familiarity with improvement tools and methodologies (e.g. root‑cause analysis, 5 Whys)

About Us & Values

• Caring – we care about our colleagues and the people whose lives we are here to transform.
• Connecting – we will transform lives through our ability to make positive connections.
• Transforming – we are committed to transforming lives and making a positive societal impact.

Benefits

• Generous annual leave – 30 days plus bank holidays
• Pension scheme – contributions matched 2:1 (up to 10% of your salary)
• Interest‑free loan for season tickets for buses and trains
• Cycle to work scheme
• Subsidised eye tests & flu jabs
• Life assurance scheme
• Give‑as‑you‑earn scheme
• Employee assistance programme (EAP)
• PAM Assist and PAM Life scheme (wellbeing)
• Enhanced family and sick pay
• Paid volunteering (2 days a year)
• Recognition scheme
• Discounts portal to numerous retailers

Security

People working with government assets must complete baseline personnel security standard checks.

Nationality Requirements

• UK nationals
• Nationals of the Republic of Ireland
• Nationals of Commonwealth countries who have the right to work in the UK
• Nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre‑settled status under the European Union Settlement Scheme (EUSS)
• Nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre‑settled status under the EUSS
• Individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Working for the Civil Service

The Civil Service Code sets out the standards of behaviour expected of civil servants. We recruit by merit on the basis of fair and open competition. The Civil Service embraces diversity and promotes equal opportunities and runs a Disability Confident Scheme for candidates with disabilities who meet the minimum selection criteria. For more information see the Civil Service People Plan and the Civil Service Diversity and Inclusion Strategy.