Power BI Consultant

• Provide technical support to performance analyst and developer SMEs, helping them optimise their use of Power BI with a SQL Data Warehouse.
• Collaborate with warehouse developers to refine data warehouse design for efficient data use.
• Design and deliver informal training sessions for small groups on effective use of Power BI.
• Develop commissioned Power BI semantic models from detailed requirements to address short-term capacity gaps.
• Help teams translate business requirements into practical technical solutions.
• Engage with leadership to explore innovative working models in line with industry best practices.

Technologies:

• Azure
• Data Warehouse
• DAX
• Fabric
• Support
• Power BI
• SQL
• Cloud, We are recruiting for a Power BI Consultant to work with our client, Thames Valley Police, as part of the Data Systems and Roadmap Project (DSRP), a three-year initiative moving core performance data workloads from Business Objects to an Azure-based Data Warehouse and Power BI. The role is based in Kidlington and is temporary, full-time (37 hours per week, Monday to Friday), with a daily rate of £550 via umbrella and an end date of April 4, 2027. Our Office of Data Analytics is shared between Thames Valley Police and Hampshire & Isle of Wight Constabulary. You will work with data engineers, a technical business analyst, an adoption lead and testing support. The role is hybrid, with one to two days a week on site in Kidlington or Winchester City Centre and occasional visits to other sites across Thames Valley and Hampshire & Isle of Wight. We are open to full-time candidates and those able to commit to at least two days a week. We offer flexible hybrid working, a competitive daily rate and opportunities for professional growth and development. We are committed to an inclusive and accessible recruitment process and can support reasonable adjustments.

• Must have resided in the UK for a minimum of 5 years and be able to pass police vetting.
• A full driving licence is required.
• Proficiency in Power BI, including building datasets and reports and managing Power BI Service.
• Strong knowledge of DAX and M.
• Expertise in T-SQL, including SQL data source connections and query folding.
• Solid experience in data modelling and dataset design.
• Proven training experience in a mentoring, support or consultancy capacity.
• Familiarity with Fabric DP-600 is desirable.
• Microsoft Certified Trainer certification is desirable.