Power BI Developer/Analyst (PO3)

Job description Post title: Power BI developer/ analyst Service area: Resources Grade: PO3 Reports to: Senior PH/Corporate analyst Your team: Data Insight Number of supervisees: None Our ambition We're determined to make Islington fairer. To create a place where everyone, whatever their background, has the opportunity to reach their potential and enjoy a good quality of life. We also have an ambitious goal to be the best council in the country with every employee clear about the part play and inspired, focused and supported to give their very best. We want to build an organisation where employees feel valued, inspired and empowered to help us achieve our goals and provide the best services possible to our residents. Our values and behaviours Be Islington is about setting a clear challenge about what it means to be an Islington employee and sets the standard for every new recruit. We ask our employees to Be Islington playing their part in working together for a fairer borough and to always be collaborative, be ambitious, be resourceful, and be empowering (CARE). Our commitment to challenging inequality We are committed to tackling inequality, racism and injustice and creating a fairer borough for all. In order to do this, we need to set the example by being a fair employer and creating a workplace environment, which is free from discrimination, racism and inequality. Our approach needs to be proactive, consistently learning to create a fairer workplace and foster a culture, which empowers all staff to challenge inequality. Fairness is at the heart of what we do. We want to celebrate and embrace our differences by: Ensuring our workforce is representative of the people we work on behalf of, our residents, Creating equitable working environments and diverse teams, Understanding our residents in order to design and deliver services that help tackle inequality and improve life chances for our residents, Getting to know people and their differences, Interpreting issues and concerns from a cultural perspective and address situations or problems from the points-of-view of multiple cultures, Supporting people with long-term health conditions and/or disabilities, Recognising the value of flexible working to support staff where possible, Key responsibilities Islington has a new strategic plan, which recognises that good data is key to delivering a more equal borough.

1. The plan states the importance of using data to measure the progress and impact of our services and the ambition to enhance our data and systems, so the workforce is equipped with the best tools and intelligence to provide high quality services to our residents. As part of this ambition the council is creating a central data insights team. A key deliverable of the council's data strategy is to roll out Power BI 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 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 Power BI dashboard development; designing and delivering impactful dashboards for a range of stakeholders, ensuring they are user friendly. Managing Power BI forums for developers and analysts. Setting best standards for developing Power BI Dashboards. Developing Quality Assurance procedures for development of Power BI dashboards and disseminating across to data analytical community. Provide technical support to new users of Power BI. Communication and Stakeholder management 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 Person specification Essential criteria Significant experience of Power BI, developing end-to-end reporting and deployment processes, preferably in a public sector organisation. Proven experience of designing and delivering Power BI dashboards. Solid data modelling capabilities including designing effective data models within Power BI. Fluent in DAX code and experienced in when and where to apply this. Ability to write and structure efficient SQL queries. Professional certification in Powerbi e.g PL300:Microsoft Power BI Data Analyst. WCAG (2.1/2.2) Accessibility Compliance Experience using Power BI and other tools available to make reports accessible for all users. Ability to build positive stakeholder relationships and influence. Ability to systematically gather stakeholder requirements for dashboards. Strong analytical skills, with the ability to analyse problems and identify creative realistic solutions. Ability to work with other analysts in Power BI 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. Is 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.