Power BI Developer

Vacancy Information

• Division / Department
  - Corporate Development
• Grade - M1
• Status
  - Full Time or Happy to Talk Flexible Working
• Contract Type
  - Fixed Term Contract
• Salary Grade Range - £49,716 - £54,696
• Working Hours - 37.0 Hours per Week
• Location - the company Headquarters, Lewes
• Starting salary usually at the bottom of the range and pro‑rata if hours < 37.0

the company is using analytics to improve the way we police, both in terms of operational effectiveness and organisational efficiency. Our aim is to put the best possible information into the hands of frontline officers to save them time, help them target resources and make better informed decisions to keep the public safe.

Corporate Development Department (CDD) are delivering advanced insight into the extensive and complex data held by the company using Fabric.

We are looking for a 3rd Developer to join the team to help design and maintain Microsoft Fabric Artefacts including Power BI Dataflow, Semantic Models, Reports, Azure Data Factory Pipelines and various Synapse tools to bring data into Microsoft Fabric Lakehouse and/or Data Warehouse and seek to continuously improve the products and services delivered to Chief Officers and Frontline teams.

The successful candidate will have specific responsibility for transforming data from a variety of different sources into Microsoft Fabric Artefacts.

• Integrate, transform, and consolidate batch data at scale into analytics solutions, from raw to curated.
• Be part of a team who act as single point of contact for Microsoft Fabric and Power BI service delivery and improvement.
• Use statistical methodology to help derive strategic insights from organisational data.
• Consult upon, design, create and maintain Power BI semantic models and reports which support all aspects of operational policing and corporate assurance.
• Provide technical expertise on Microsoft Fabric, Power BI, Oracle and SQL development for the force - supporting colleagues in the delivery of their work and managing the technical requirements of development work.
• Define and maintain the architectural standards, frameworks and processes required to build and expose data with reusable semantic models in Power BI.
• Undertake other duties appropriate to the grade and character of work as may be reasonably required, including specific duties of a similar or lesser graded post.

• A degree in computing, statistics, mathematics, or a statistically related discipline or equivalent work experience.
• Strong data modelling background with experience working with multiple data sources in Fabric.
• Industry experience in delivering Power BI/Microsoft Analytics solutions, with a good grounding in all associated areas including governance.
• Experience in building dataflows and semantic models, using SQL, DAX, Power BI, or other visualization tools.
• Experience in gathering BI requirements and understanding business processes at different levels.
• Experience of establishing and maintaining collaborative relationships with stakeholders.
• Good communication, interpersonal, and presentational skills to influence internal stakeholders.
• Ability to self‑manage and work in a dynamic environment.
• Ability to manage conflicting priorities, negotiate solutions, and resolve problems with colleagues and customers.
• A flexible and responsive approach to meeting work demands.

We’re invested in supporting people to balance their life with work and we encourage flexible working. We are open to conversations about job shares and part time working. We encourage agile working, giving you the opportunity to manage your own diary and work wherever you give the best service to the public. This may include flexi‑time and home working.

We take pride in looking after our people and offer a variety of benefits:

• career progression
• contributory pension scheme (LGPS)
• generous annual leave allowance
• discounts for everyday spend
• on‑site gyms and a range of sports clubs
• generous and supportive parental leave
• financial and mental wellbeing guidance and support
• discounted contributory healthcare scheme

We are only as good as our…