BI Developer - Outside IR35

BI Developer - Data Programme - Outside IR35 1st November Start, 6 months initially with rolling extensions expected Outside IR35: £375 - £425 per day Hybrid: Travel once every week / 2 weeks to Yorkshire

A Yorkshire trust is about to get much cleaner data. You'll turn it into Power BI dashboards that clinicians and executives actually use, and that prove the programme is working.

What you'll do

• Agree with users which decisions each dashboard needs to support
• Build Power BI dashboards end to end: data model, DAX measures, visuals and publishing
• Write and tune SQL against the trust's data warehouse and SystmOne extracts
• Track data-input compliance, with drill-down to team level
• Report on mental health data, including MHSDS submission quality and national measures
• Work with the BAs and SystmOne developer so form changes flow cleanly into reporting

What you'll deliver

• Agreed dashboard requirements and measure definitions
• A baseline data-input compliance report
• Published Power BI dashboards with row-level security and scheduled refresh
• SQL views or procedures behind each dashboard
• Handover documentation for the trust's information team

What you'll bring

• Strong Power BI: DAX, Power Query and data modelling
• SQL Server / T-SQL
• NHS or wider health and care data experience
• The ability to explain data clearly, from ward manager to executive

Nice to have

• Mental health data and MHSDS
• SystmOne data structures and extracts
• SPC charts and NHS Making Data Count
• Data quality measures such as DQMI
• Based in or near Yorkshire