Business Intelligence Analyst

SF Recruitment Ltd; West Midlands Combined Authority; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading company in the UK is seeking a hands-on Data & Reporting Lead to enhance its data capabilities. The role involves designing and delivering actionable reports using Power BI and SQL, and engaging with stakeholders to innovate data processes. Joining this supportive business provides an opportunity for professional growth and impact on operational effectiveness.

Benefits

Healthcare

Pension

Professional growth opportunities

Inclusive workplace culture

Qualifications

• Strong experience with Power BI including DAX.
• Confident writing and optimising SQL queries.
• Experience supporting or building ETL pipelines.

Responsibilities

• Design and deliver dashboards using Power BI.
• Build and optimise SQL-based reports.
• Support and improve ETL workflows.

Skills

Power BI

SQL

ETL

OLAP/Analysis Cubes

Collaboration

Job description

Data & Reporting Lead

A long-established, privately owned business is investing in its data capabilities and looking for a hands-on Data & Reporting Lead to shape and deliver reporting across commercial and operational teams.

Key Responsibilities:

• Design and deliver dashboards using Power BI, providing clear and actionable insights.
• Build and optimise SQL-based reports and processes, including development in SSRS.
• Support and improve ETL workflows and maintain structured data feeds into the warehouse.
• Work with stakeholders who use Analysis Services Cubes - understanding how the cubes function and how best to report from them.
• Engage with teams to gather reporting requirements and support wider data initiatives.
• Contribute to improvements in data quality, consistency, and performance.

Skills & Experience:

• Strong experience with Power BI (including DAX).
• Confident writing and optimising SQL queries for reporting and transformation.
• Experience supporting or building ETL pipelines (e.g. SSIS or similar tools).
• Good understanding of how OLAP/Analysis Cubes work and how they're used in reporting.
• Comfortable collaborating with both technical and non-technical stakeholders.
• Bonus: Exposure to Dynamics Business Central or similar ERP systems.

Why Apply?

• High-impact role with visibility across commercial and operational teams.
• Supportive, friendly business with low turnover and clear growth plans.
• Chance to help modernise reporting processes and reduce manual workload.
• Backed by experienced leadership and strategic investment.

What We Offer:

We offer a competitive salary and benefits package, including healthcare, pension, and ample opportunities for professional growth and development. Our inclusive and diverse workplace culture values collaboration, innovation, and excellence. Join our team and make a meaningful impact on our business and the industry as a whole.