Business Intelligence Engineer

Business Intelligence Engineer (Birmingham / Hybrid)

About the role

You will be responsible for designing, building and improving the business intelligence capability that supports service delivery and business performance. You’ll help ensure that data is accurate, accessible and useful—whether that’s for operational teams, senior leaders, or specialist functions.

You’ll translate business requirements into durable data models and reporting solutions, and you’ll collaborate with data, IT and operational stakeholders to ensure reporting answers the questions people actually need answered.

What you’ll be doing

• Design and develop data pipelines and data transformations to ensure consistent, trusted reporting.
• Create and maintain dashboards and reporting that bring clarity to performance, quality and outcomes.
• Build and optimise data models (dimensional or equivalent approaches) to support scalable analytics.
• Ensure data quality through validation, monitoring and practical improvements to reduce errors.
• Partner with stakeholders to understand reporting needs, define measures/metrics and improve decision-making.
• Document solutions so reports and data products are understood and easy to use.
• Troubleshoot and improve reporting performance, reliability and usability.
• Support governance by adhering to data standards, permissions and safe handling practices.

About you

You’ll bring a strong blend of engineering and analytics thinking. You’re comfortable working with both technical detail and business needs and you can explain your decisions in a way that helps others confidently use the outputs.

You enjoy building repeatable solutions rather than one-off fixes, and you take pride in creating data products that stay useful over time.

We’d love to see experience in areas such as:

• Business intelligence engineering and/or data warehousing concepts
• Building datasets and pipelines (e.g., ETL/ELT) and transforming data for reporting
• Dashboarding and visualisation tools (e.g., Power BI or equivalent)
• Writing SQL and designing efficient queries for analytics workloads
• Data modelling and metric definitions (ensuring consistent “single source of truth”)
• Data quality checks, monitoring and root-cause investigation
• Collaborative working—listening carefully, iterating quickly, and delivering outcomes

If you’re not sure you meet every bullet, don’t let that hold you back. A good BI engineer learns fast, takes responsibility and improves systems in meaningful ways.

Why this role is different

Many roles work with data. This one works with people’s lives—and the services that support independence and safety. Your work will help colleagues understand what’s happening across services, where support needs strengthening, and how improvements are taking hold.

You’ll be part of a team that genuinely values the social purpose behind the numbers—and you’ll contribute to a culture where colleagues live and breathe the mission.