Power BI Consultant - Azure Data Warehouse Transformation

Adecco; Kidlington, Winchester; Hybrid; GBP 88,000 - 115,000; Full time

Benefits offered by this job

Competitive daily rate

Flexible hybrid working

Growth and development opportunities

Job summary

Adecco is recruiting a Power BI Consultant to support Thames Valley Police as part of the DSRP. Hybrid role with 1-2 on-site days weekly across Winchester and Kidlington, working within a team of data specialists to modernise data warehouses and raise reporting capabilities.

The ideal candidate will bring expert Power BI skills, strong DAX/M language knowledge, T-SQL experience, and a track record of training or mentoring staff. Police vetting is required; UK residence for 5+ years is noted.

Qualifications

• Proficiency in Power BI: build datasets, reports and manage the Power BI Service.
• Strong knowledge of DAX and M.
• Expertise in T-SQL, including data source connections and query folding.
• Solid experience in Data Modelling & Dataset Design.
• Proven training experience in mentoring, support or consultancy.
• Desirable: Fabric DP-600 and Microsoft Certified Trainer certification.

Responsibilities

• Provide direct technical support to performance analyst/developer SMEs, optimising their use of Power BI alongside a SQL Data Warehouse.
• Collaborate with warehouse developers to refine data warehouse design for efficient data utilisation.
• Design and deliver informal training sessions to empower groups in leveraging Power BI effectively.
• Develop commissioned Power BI semantic models from detailed requirements to fill short-term capacity gaps.
• Assist teams in translating business requirements into practical technical solutions.
• Engage with leadership to explore innovative working models, adhering to industry best practises.

Skills

Power BI

DAX

M

T-SQL

Data Modelling

Training

Job description

Adecco is recruiting a Power BI Consultant to support Thames Valley Police as part of the DSRP. Hybrid role with 1-2 on-site days weekly across Winchester and Kidlington, working within a team of data specialists to modernise data warehouses and raise reporting capabilities.

The ideal candidate will bring expert Power BI skills, strong DAX/M language knowledge, T-SQL experience, and a track record of training or mentoring staff. Police vetting is required; UK residence for 5+ years is noted.