Business Intelligence Analyst

Michael Page (UK); Walsall; On-site; GBP 45,000; Full time

Job summary

A recruitment firm is seeking a Business Intelligence Analyst in Walsall, focusing on delivering insightful analyses through the use of T-SQL, Power BI, and strong analytical skills. Responsibilities include creating and improving dashboards, ensuring data quality, and responding to reporting requests. The role offers a competitive salary of £45,000 per annum and the chance to contribute to impactful projects in the Not For Profit sector, all while based in Walsall with good transport links.

Benefits

Competitive salary

Comprehensive pension scheme

Opportunities for impactful projects

Qualifications

• Solid working knowledge of T-SQL for data extraction and analysis.
• Experience using Power BI, DAX and Power Query for dashboards.
• Strong analytical and problem-solving capabilities.
• Experience in building reusable datasets and metrics.

Responsibilities

• Deliver end-to-end analysis, from requirements gathering to insights.
• Design and maintain Power BI dashboards using DAX and Power Query.
• Identify and resolve data quality issues.
• Promote best practices in dashboard and report use.

Skills

T-SQL

Power BI

DAX

Power Query

Excel

PowerPoint

Analytical thinking

Problem-solving

Communication

Tools

Power Apps

Power Automate

Job description

Opportunity to join an expanding Business Intelligence team

Opportunity to work on varied Business Intelligence projects

About Our Client

This organisation operates in the Not For Profit sector and is a medium‑size enterprise based in Walsall. They are focused on delivering services that benefit the community and utilise analytics to drive their mission forward.

Job Description

Key Responsibilities

• Deliver end‑to‑end analysis, from requirements gathering through to SQL based data extraction, modelling and insight delivery.
• Design, develop and maintain Power BI dashboards and reports using DAX and Power Query, ensuring solutions are accurate, performant and aligned to agreed definitions.
• Oversee and continuously improve existing reports, streamlining where possible and ensuring data integrity.
• Develop and maintain reusable datasets, data models and metrics that support consistent reporting across teams.
• Provide timely, high‑quality responses to ad‑hoc reporting and insight requests.
• Support regulatory and external data submissions.
• Data Quality, Capability & Continuous Improvement
• Identify and resolve data quality issues, working collaboratively with system owners and colleagues.
• Promote best practice in the use of dashboards and reports, including training and enablement for colleagues.
• Contribute to improvements in reporting standards, processes and ways of working.
• Maintain awareness of emerging Business Intelligence tools and techniques, applying them pragmatically where they add value.
• Build and maintain Power Apps and Power Automate flows to support data capture, automation and reporting processes where appropriate.

The Successful Applicant

Key Skills & Experience

• Solid working knowledge of T‑SQL for data extraction and analysis. With experience of optimising queries and improving data performance.
• Experience using Power BI, DAX and Power Query to create clear, user‑focused dashboards and reports.
• Strong Excel and PowerPoint skills for analysis, validation, ad‑hoc insight and presentation.
• Practical experience with the Microsoft Power Platform, including building Power Apps and Power Automate flows to enhance reporting, automate processes or improve data quality.
• Experience working with structured data and building reusable datasets and metrics.
• Understanding of data quality, validation and governance principles.
• Strong analytical thinking and problem‑solving capability.
• Strong experience acting as a business‑facing Business Intelligence or data partner, not just a report developer.
• Strong requirements gathering skills, with the ability to manage expectations and to clarify and manage competing priorities.
• Excellent communication skills, able to clearly explain complex data and insights to non‑technical audiences.
• Ability to define, explain and maintain KPIs and performance measures.

What's on Offer

• Competitive salary of £45,000 per annum.
• Comprehensive pension scheme – 20% LGP.
• Permanent position in a reputable organisation.
• Opportunities to contribute to impactful projects in the Not For Profit sector.
• Based in Walsall, with accessible transport links.

If you are ready to take on this exciting role as a Business Intelligence Analyst in Walsall, apply today to make a meaningful difference.