Technical BI Manager

About The Role

At Compass Community, we're dedicated to transforming the lives of children, young people and families through high-quality care, education and support.

We're looking for an experienced Technical BI Managerto lead the technical development of our modern cloud data platform while managing and developing our BI team. This is a hands-on technical leadership role, combining expertise in data engineering and architecture with responsibility for building team capability, establishing development standards and delivering high-quality data solutions.

This is a hybrid position based at our Birmingham office.

Join us in transforming data into meaningful insight

Working with Microsoft Fabric, you'll play a key role in designing, building and maintaining scalable data solutions that support reporting, analytics and informed decision-making across the organisation.

You'll work with modern technologies including Microsoft Fabric, Spark, Azure DevOps, SQL, Python/PySparkand AI-enabled development tools, helping to deliver trusted data products that improve operational performance, support safeguarding outcomes and drive strategic decision-making.

Alongside your technical responsibilities, you'll provide day-to-day leadership of the BI team, supporting their professional development, sharing technical expertise and ensuring consistent, high-quality engineering practices.

What you'll be doing

• Lead the design, development and ongoing enhancement of our enterprise data platform using Microsoft Fabric.
• Design and develop reliable data ingestion, transformation and orchestration processes using both code-first and low-code approaches.
• Develop and optimise Spark-based data solutions using Python/PySparkand notebooks.
• Design scalable data models and data warehouses that support business intelligence, reporting and analytics.
• Implement effective data quality, monitoring, security and governance processes.
• Establish and maintain engineering standards, reusable development patterns, source control and CI/CD practices using Azure DevOps.
• Take technical ownership of the data platform, troubleshooting complex issues and driving improvements in performance, reliability and cost-effectiveness.
• Manage and develop the BI team, including setting objectives, providing regular feedback, managing performance and supporting individual development.
• Provide hands-on technical leadership, coaching and mentoring, sharing knowledge and building the team's technical capabilities and confidence.
• Work with stakeholders to understand requirements, prioritise activities and ensure the delivery of high-quality data solutions.
• Support Power BI developers and analysts by providing trusted, well-modelled data for reporting and analytics.
• Champion the responsible use of AI-enabled development tools and automation to improve engineering efficiency, quality and innovation.

About you

You'll be an experienced, hands-on data professional who combines strong technical expertise with the ability to lead, support and develop a team. You'll enjoy solving complex technical challenges while helping colleagues grow their skills and deliver high-quality solutions.

You'll bring:

• Strong advanced SQL skills and hands-on experience with Python/PySpark.
• Experience working with Microsoft Fabric and/or Azure Databricks.
• Expertise in Spark-based data engineering and cloud data platforms.
• Strong knowledge of ELT/ETL processes, orchestration, dimensional data modelling and Lakehouse architectures.
• Experience using Azure DevOps, Git repositories, code reviews and CI/CD practices.
• Understanding of data governance, security, GDPR and data quality best practices.
• Experience supporting analytics and reporting environments, ideally including Power BI.
• Previous experience managing and developing a technical team, including setting objectives, coaching, mentoring and performance management.
• The ability to provide hands-on technical leadership, establish development standards and promote knowledge sharing across a team.
• Excellent problem-solving, communication and stakeholder management skills.
• The ability to balance code-first and low-code development approaches to deliver effective, maintainable and cost-efficient solutions.

Desirable experience

• Microsoft Fabric, Azure or Databricks certifications.
• Experience with Fabric Data Factory pipelines, Dataflows Gen2 and Direct Lake.
• Knowledge of AI-assisted development tools such as GitHub Copilot, Microsoft Copilot or Claude.
• Experience with Fabric CLI, Model Context Protocol (MCP) integrations or development automation.
• Experience within a regulated environment such as children's services, healthcare, education or social care.
• Understanding of safeguarding and compliance requirements.

Skills

Fostering - Adopt, General Skills - HEALTHCARE, General Skills - Leadership