Power BI Consultant in Kidlington

Overview:
Our client, a prominent organisation in the Public Services sector, is seeking experienced Power BI Consultants to join their transformative "Data Systems and Roadmap Project" (DSRP). This three-year initiative aims to transition core performance data workloads from Business Objects to a modern Azure-based Data Warehouse and Power BI. With the project set to culminate in July 2027, the organisation is keen to maximise investments made thus far and enhance user engagement with the new tools and data access.

Role Responsibilities:
The successful candidates will play a vital role in supporting two primary user groups:

1. Data Developers/Analysts - Users who will build and maintain Power BI semantic models and reports for end users in the Power BI Service.
2. Data Analysts/Researchers - Users who will connect to shared Power BI semantic models to produce data for various audiences.

• Providing direct technical support to performance analyst and developer SMEs to enhance their use of Power BI, particularly in relation to SQL Data Warehouse and Power BI semantic models.
• Assisting in the development of requirements for warehouse developers to refine the design of the data warehouse and ensure efficient data usage.
• Designing and delivering informal training sessions to small groups, empowering users to improve their working practises.
• Actively building commissioned Power BI semantic models based on detailed requirements to fill short-term capacity gaps.
• Collaborating with teams to understand business requirements and translating these into technical solutions.
• Engaging with leadership within performance teams to explore future operational models aligned with industry best practises.

Candidate Requirements:
Ideal candidates should possess the following skills and experience:

• Essential Skills:
• Proficiency in Power BI, including dataset building, report creation, and administration of the Power BI Service.
• Expertise in DAX and M languages.
• Strong understanding of T-SQL, particularly in connecting to SQL data sources from Power BI and query folding.
• Experience in data modelling and dataset design.
• Proven training experience, with the ability to mentor and support users in a consultancy capacity.
• Public Sector experience required
• Ability to pass Security Clearance is a must

Adecco is a disability-confident employer. It is important to us that we run an inclusive and accessible recruitment process to support candidates of all backgrounds and all abilities to apply. Adecco is committed to building a supportive environment for you to explore the next steps in your career. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you.