Power BI Developer/ Analyst

Power BI Developer/ Analyst

Reports to: Senior PH/Corporate Analyst

The council is creating a central data insights team. A key deliverable of the council's data strategy is to roll out PowerBi dashboards across the organisation.

This role will sit within the corporate insight team and be part of a wider networked analytical team.

Data Analytics and Insight to lead on the development of dashboards for specific areas including defining key metrics and developing develop calculations and measures that are accurate and performant on large datasets.

Set up processes to ingest data from a variety of data sources and perform required transformations in Power Query / editor M-code / DAX

Design and optimise navigation features in Power BI to guide users through a compelling data story.

Work with data engineers to produce documentation and SQL scripts for data transformation.

Create insightful, interactive and aesthetically pleasing reporting solutions in Power BI.

Manage dashboards, data sources, security, schedules, extracts and work spaces.

Have great communication and analytical skills

Work with data within an Azure data platform. Training and upskilling.

Support the Data Analyst community with PowerBI dashboard development; designing and delivering impactful dashboards for a range of stakeholders, ensuring they are user friendly.

Managing PowerbI forums for developers and analysts.

Setting best standards for developing Powebi Dashboards.

Developing Quality Assurance procedures for development of PowerBI dashboards and disseminating across to data analytical community.

Provide technical support to new users of PowerBI Communication and Stakeholder management Strategic Plan 2021.

Elicit analytical requirements from stakeholders as well as test and validate data before visualisation to ensure accuracy and trust in what is produced.

Have good business analysis skills such as gathering and documenting requirements from a variety of stakeholders.

Be an Evangelist and champion data visualisations within a business.

Be an Evangelist and champion for data platform, promoting data transformation and pipeline benefits with a focus on process automation and resident value.

Ability to work with a wide range of senior management Data governance.

Good understanding and experience in developing reports and dashboards that are GDPR/Data Protection compliant.

Working with colleagues in Information Governance to ensure dashboards are deployed with right access controls and aligned with council policies Compliance.

Ensure legal, regulatory and policy compliance under GDPR, Health and Safety and in area of your specialism identifying opportunities and risks and escalating where appropriate.

Work style Hybrid

Demonstrate on your application form how you meet the essential criteria.

Essential criteria

Significant experience of PowerbI, developing end-to-end reporting and deployment processes, preferably in a public sector organisation Application/Interview

Proven experience of designing and delivering PowerBI dashboards Application/Interview

Solid data modelling capabilities including designing effective data models within Power BI Application/Interview

Fluent in DAX code and experienced in when and where to apply this Application/Interview

Ability to write and structure efficient SQL queries.

Professional certification in Powerbi e.g PL300:Microsoft Power BI Data Analyst Application 7 WCAG (2.1/2.2)

Accessibility Compliance Experience using Power BI and other tools available to make reports accessible for all users

Application Skills

Ability to build positive stakeholder relationships and influence

Ability to systematically gather stakeholder requirements for dashboards Application/Interview

Strong analytical skills, with the ability to analyse problems and identify creative realistic solutions Application/Interview

Ability to work with other analysts in PowerBi dashboard design

Ability to manage resources, mitigate risks and prioritise to achieve tight deadlines

Expert knowledge of information governance and data security best practice, rules and regulations.

Ambitious and motivated, able to inspire others, work collaboratively and deliver outstanding results.

Able to demonstrate successful management of projects

Ability and interpersonal skills to work in a pressurised environment

Previous Council experience is essential