Power BI Developer

Sussex Police; United Kingdom; Remote; GBP 50,000 - 55,000; Full time

Benefits offered by this job

Flexible working

Career progression

LGPS pension

Generous annual leave

On-site gym

Job summary

Sussex Police is seeking a 4th Developer with a Data Engineering background to design and maintain Microsoft Fabric Artefacts including Power BI Semantic Models, Azure Data Factory Pipelines and Synapse tools. You will transform data from diverse sources into Fabric artefacts and help move Sussex and Surrey Police to a single cloud data platform.

You will join Corporate Development to deliver analytics that support frontline policing and senior decision makers.

Qualifications

• 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 governance.

Responsibilities

• 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
• Gathering data requirements and mapping data to support migration from Strategic Insights team and existing dataflows.
• 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.

Skills

Data modelling

Power BI

SQL

DAX

BI requirements gathering

Stakeholder management

Education

Degree in computing, statistics, mathematics, or related field

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse

Power BI service

Job description

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

Shift Allowance - No

Politically Restricted - No

Location - Sussex Police Headquarters, Lewes

The starting salary for this role will usually be at the bottom of the salary range and will be pro-rata if the working hours are less than full time.

Chief Constables' Message

We really welcome your interest in joining our Police Force. It is a privilege to lead the teams in Surrey Police and Sussex Police who continuously work selflessly and tirelessly in order to keep people in our counties safe.

We are looking for talented and inspirational people who put the needs of the public at the heart of everything that they do and who want to make a difference. If you feel you are that person then we want to hear from you.

We wish you all the very best with your application.

The Role & Key Responsibilities

Sussex Police 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 Sussex Police using Fabric.

We are looking for a 4th Developer with a Data Engineering background to join the team to help design and maintain Microsoft Fabric Artefacts including Power BI Semantic Models, 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 as well as being involved with the move to a single cloud data platform in Sussex and Surrey Police.

Key Responsibilities

• 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
• Gathering data requirements and mapping data to support migration from Strategic Insights team and existing dataflows.
• 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.

Skills & Experience

• 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, data mapping 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.

Why Work With Us?

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

For further details about this role or to request a copy of the Job Description, please contact:

We are only as good as our people. It's important that our officers and staff can be themselves in the workplace and we know that as an organisation we'll grow from the variety of thinking, approach, and the skills that diversity brings; all of which help us to deliver a better policing service. We strive to ensure how we deliver our services, provide information and how we recruit is open and accessible to all.

We have multiple staff support groups who help to improve our understanding of minority issues and ensure they are reflected in our work. We are proud members of Disability Confident, hold Race Equality Matters Trailblazer status, are a signatory of the Race at Work Charter and are aligned with the Armed Forces Covenant and the HeForShe movement.

We are committed to being an anti-racist police service. We promise to challenge injustice, ensure fairness and to uphold anti-racist principles in both our organisation and our communities. For more information, you can read our full anti-racism statement here .

We value the differences that people bring from all backgrounds and communities. Regardless of age, sex, ethnicity, sexual orientation, gender identity or gender expression, disability, social status, or religious belief, we would love to hear from you.

Following submission of your application you will receive a confirmation email with a copy of your application attached. Occasionally emails from this address can fall into spam/junk folders so please ensure this is checked regularly. You may wish to consider adding [e-mail] to your address/contact list to ensure you receive all communications.

This post is being advertised in parallel with Force redeployment processes. Any redeployees who are identified will be given preference. This may result in the post being withdrawn at any point during the recruitment process.

Please note that not all jobs are available for internal candidates across both Forces, the current agreed recruitment principles are;

• vacancies in collaborated units are available to all officers and staff across both Forces
• vacancies in non-collaborated units are only available to officers and staff within the Force with the vacancy unless it is advertised externally
• if the vacancy is advertised externally and an officer or member of staff from the other Force is successful it will result in a transfer of employment

Surrey Police and Sussex Police Special Constables, Volunteers and Agency Staff (excluding self employed workers) covered under the Agency Worker Regulations (AWR) are eligible to apply for internal advertised posts.

Location Sussex Police Headquarters, Lewes