BI Analyst

Job summary

BI Analyst
£55,000 per annum
Bedford
Permanent
Hybrid Working

Are you passionate about turning data into actionable insights? As a BI Analyst at MaPS, you'll be the bridge between our data, the Debt Team, and the wider organisation. Your work will drive evidence-based decision-making, enhance the effectiveness of our services and shaping the future of debt advice.

Job description

Role Overview
The BI Analyst will report directly to Continuous Improvement Manager. In this role, you will be responsible for:

• Analysing existing systems and operational procedures
• Understanding the business needs and goals of the Debt Team and wider organisation
• Acquiring relevant data from within MaPS, from suppliers and from other external stakeholders
• Cleaning, modelling, transforming and analysing data – understanding what it’s telling us and seeking to understand why
• Reviewing data collection processes and assessing the quality of information stored
• Building, maintaining and improving dashboards and reports, utilising tools such Microsoft Power BI as part of your role
• Adhering to company policies and legal requirements in relation to data collection and security
• Analysing data through a variety of statistical methods and models, and identifying challenges and opportunities
• Presenting high quality, insight and analysis using engaging visuals – telling the story of the data and providing recommendations to colleagues including senior management
• Tracking the progress of changes that are implemented through key performance indicators

Person specification

Skills and Experience Required
To excel in this role, you will need to demonstrate:

• Background or education in Maths, statistics and English beneficial
• Minimum 2 years working in a statistics or analytical role
• Data/BI Analyst certification or equivalent experience
• PowerBI certification or equivalent experience
• SQL and database experience including working with Microsoft Azure databases (experience of Fabric beneficial)
• Experience with statistical and mathematical models
• Excellent knowledge of databases and programs such as Excel or Google spreadsheets
• Great communicator, able to translate business requirements for a technical audience and vice versa
• The ability to present complex information in an easy-to-understand format
• Exceptional data visualisation skills, with the ability to turn complex data and trends into effective visuals using tooling such as PowerBI, Tableau etc

Benefits

About Us
The Money and Pensions Service (MaPS) is based in Bedford, in a recently renovated modern office. This is a wonderful opportunity for you to become an integral part of a dynamic organisation, working to help people across the UK.

At the heart of the Money and Pensions Service are our values – caring, connecting, and transforming, which are the foundation of our success. They permeate every area of our work and define all our business relationships and the way we work with each other. We’re not only looking for the best people to come and work for us, but we need people who align themselves with our 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.

Our Inclusive Working Environment
By fostering our values, we are immensely proud of the inclusive working environment that we have created. The diversity of our people is a strength that we embrace and wish to build upon, so we are committed to attracting people of all backgrounds. We work hard to ensure that we have a progressive approach to inclusion, equity, and belonging. We really do want our colleagues to “bring their whole selves to work.”

Our colleague and ally networks encompass LGBTQ+, neurodiversity, women’s health, men’s health, ethnicity, and diversity.

What We Offer

• Generous Annual Leave – 30 days plus Bank Holidays
• Pension scheme – contributions matched 2 to 1 (employer contribution 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

Flexible Working
At MaPS, we take pride in our flexible approach to work. As standard, we work on a hybrid basis with a minimum of 2 days in the office per month. Hybrid working is a voluntary, non-contractual arrangement and our headquarters in Bedford will be your contractual place of work. The number of days that anyone will be able to work at home will be determined primarily by business needs, but personal and other relevant circumstances will also be considered. If you are successful, any opportunities for hybrid working, including whether a hybrid working arrangement is suitable for you, will be discussed with you prior to you taking up your post.

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

Recruitment Process:

1. Initial Review: Our recruiter will review your CV. If it looks like a good fit, they'll reach out to arrange a call.
2. Hiring Manager Review: If the recruiter thinks you're suitable, your CV will be passed to the hiring manager, who will decide whether to invite you for an interview.
3. Interview: If selected, you'll participate in a virtual interview. This single-stage process allows you to demonstrate your skills and experience through competency-based questions. This will also require you to deliver a short presentation.

Career Development
In MaPS, we take career development seriously. We actively encourage and support applications from our existing MaPS colleagues. However, we do follow the Civil Service Commissioner recruitment principles, which means that you will be required to participate in a full, open, and fair process.

Reserve List
If you are successful at interview, we operate a reserve list where your details will be held for up to 6 months. Should a vacancy come available in that time with the same essential criteria, reserve list candidates will be offered that position with no further assessment required.

Application Process
The law requires that selection for appointment to the Civil Service is on merit on the basis of fair and ope