BI Analyst (P-2488933125)

The role

The BI Analyst is the conduit between our data, the Debt Team and the wider organisation. You will facilitate evidence-based decision-making by delivering high quality insight into the services MaPS funds, who is using them and the wider debt advice landscape. You will understand the insight and evidence needs of the Team and wider organisation, enabling the Debt Team to deliver it’s statutory function by providing timely and high quality output.

You will work with data post-ingestion to clean, model, transform and analyse, creating meaningful reports and dashboards that will enable business decision making and empower colleagues within the team to perform their roles effectively and efficiently.

The BI Analyst is also instrumental in driving data maturity in the Debt Team and across MaPS. The role is responsible for developing excellent data governance practice, helping to improve data standards, literacy and quality.

The BI Analyst is comfortable acting as both internal supplier and internal customer, working closely with teams such as operations, policy, engineering to understand requirements, manage upstream dependencies and ultimately develop high quality data products. They also work closely with the data community across MaPS and the broader Debt Advice sector to support effective data management and utilisation.

Key accountabilities

You will be responsible for meeting the insight and analytics requirements of the business area you work in, which will include:

• Developing high quality Power BI products using engaging visuals – telling the story of the data and providing recommendations to colleagues including senior management
• Cleaning, modelling, transforming and analysing data – building robust data models aligned with good governance principles
• Querying data to deliver against ad hoc or irregular insight needs
• Driving the maturity of data management practice both locally and at an enterprise level
• Understanding the objectives and operating context of the Debt Team and wider organisation and how these translate into insight needs
• Working closely with teams both upstream and downstream of analytics activity to ensure a flow of accurate, timely and comprehensive data
• Working with relevant data from within MaPS, from suppliers and from clients in areas such as operational performance, client profile, business process, quality assurance and client outcomes
• Analysing data through a variety of statistical methods and models, and identifying challenges and opportunities
• Analysing existing systems and data processes and recommending improvements as appropriate
• Reviewing data collection and reporting processes, assessing the quality of information stored, and taking action to improve as required
• Adhering to company policies and legal requirements in relation to data collection and security

Skills & experience

The individual should have a keen understanding of business processes and systems alongside expert knowledge of data analysis.

You will need analytical, statistical, and mathematical skills to fulfil your job responsibilities.

A successful candidate will have various prerequisite skills and qualifications that typically include

• Proven experience delivering exceptional analysis with minimal supervision, taking ownership of projects and shaping the direction of analysis
• Experience delivering high-quality Power BI reports and dashboards with engaging, insightful visuals
• Problem solving expertise with experience of checking and validating own output, applying judgement to generate insights and knowing when to involve others
• Strong proficiency with

DAX for building robust data models and measures in Power BI

• Ability to query and analyse data using the most appropriate tool for the task - whether that’s DAX, SQL, Python, or other relevant languages
• Sound understanding of good data management principles and experience of working to high data governance standards
• Demonstrable business acumen and ability to quickly understand contexts and agendas and how they relate to your role
• Experience working with different data sources including spreadsheets, flat files and relational databases
• Experience applying statistical and mathematical techniques (e.g. forecasting, regression, segmentation) to explore data, test hypotheses, and generate actionable insights
• Excellent stakeholder management and communication, able to translate business requirements for both technical and non-technical audiences
• The ability to tell highly coherent and compelling stories, presenting complex information in an easy-to-understand format

Desirable Skills and Experience

• Understanding of the debt advice sector in England
• Background or education in a numerical discipline beneficial
• Experience of working with both structured and unstructured data and an understanding of how to combine these
• Knowledge of improvement tools and methodologies (root cause analysis, 5why etc.)

Other

PERSONAL ATTRIBUTES

• Passionate about making a difference and continuous development
• Excellent written, presentation and oral communication skills
• Organised and methodical with an attention to detail
• Ability to build effective and collaborative relationships
• Self-starter – able to operate independently, but knows when to seek input / approval
• Ability to work within a team and a matrix working environment
• Able to think outside of the box, identifying opportunities for improvement
• Empathy of our work and identification with our mission ‘Working together, we help people manage their money today and for the future’ and alignment with our core values

Other

PERSONAL ATTRIBUTES

• Passionate about making a difference and continuous development
• Excellent written, presentation and oral communication skills
• Organised and methodical with an attention to detail
• Ability to build effective and collaborative relationships
• Self-starter – able to operate independently, but knows when to seek input / approval
• Ability to work within a team and a matrix working environment
• Able to think outside of the box, identifying opportunities for improvement
• Empathy of our work and identification with our mission ‘Working together, we help people manage their money today and for the future’ and alignment with our core values