Business Intelligence Developer

Division / Department - Corporate Development
Grade - Level 1
Status - Full Time
Contract Type - Permanent
Salary Grade Range - £44,053 - £57,478
Working Hours - 36.0 Hours per Week
Shift Allowance - No
Politically Restricted - No
Location - Surrey Police Headquarters, Guildford

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 Chief Constable Tim De Meyer has set a mission to make Surrey Police one of the leading police forces in the UK. To achieve this, a significant financial investment has now been made to develop a Strategic Insights Team, delivering nationally leading insights that will drive daily operational policing.

Designing and developing reports based on specification from the business that drive day-day decisions as well as performing deep analysis on key questions that are facing the team.

Develop symantic models and pipelines to support the build of dashboards based on Microsoft Power BI.

Developing R or Python scripts to produce predictive models for use within PowerBI or reporting.

Maintenance of Power BI, SQL and related reporting systems, helping to ensure a useful and reliable reporting function for the business.

Developing data pipelines from Microsoft Fabric and integration products to exploit and maximise a range of data systems.

Understanding and interpreting user specifications and requirements gathering, user interviews, running workshops, prototyping etc. and then document requirements in a format that is intelligible to both business partners and IT colleagues

Carefully testing and accuracy checking data lists and aggregations

Engaging with existing and prospective users to understand and document their information needs predicated on an understanding of both business processes and the business decisions that users need to make

Provide support to BI projects to enable them to meet their deadlines

Working with DDaT colleagues to understand and document available data sources and their interrelation

Collaborating with other team members to design solutions and to develop strong governance and control processes

Working with quality assurance to ensure that business requirements are met

Responsible for partnering with business and user group representatives to understand business decisions and the related reporting and analysis needs

Analyse and document available data sources and data flows to standards and in a consistent manner

Collaborate with colleagues in designing solutions that meet the established business needs

Producing creative and dashboards in Power BI Desktop utilising various visualisation tools

Creating custom visuals through Software Development Kit ( SDK)

Setting up connection details and scheduling for data pipelines

Developing R or Python scripts

Working closely with key Business Users to establish and document the full detailed requirements for the range of reporting required

Analysis of legacy reporting solutions and designing effective Power BI alternatives

Acting as a promoter of Power BI and a generator of ideas as to how it can be used to fully leverage all data sources and produce effective reporting

End to end documentation including architecture designs, technical specifications and end user support guides

Support other non-technical users within the business in their use of Power BI as a self-service tool

Deliver a platform that is as much focused on self-serving capabilities as possible.

Engage with senior leaders across Surrey to ensure that the benefits of Power BI are clearly articulated and delivered.

Works with business areas to ensure that there are prepared to take on new ways of reporting by considering any behavioural/skill or culture change required.

Communicating with stakeholders to document requirements and to careful document all steps of the development process

Adhere to the Forces' Programme and project Governance requirements.

Ensure AI adheres to the current guidance from the Information Commissioner's Office.

Skills & Experience

• A degree in statistics, mathematics or a statistically-related discipline
• Demonstrate work experience with Microsoft Fabric, Mulesoft, BI Developer or Data Scientist
• Strong data modelling background with experience working with multiple data sources both cloud and on-premise
• Industry experience in delivering Power BI/ Microsoft Analytics solutions, with a good grounding in all associated areas including; development , Enterprise Architecture, Governance, Rollout and Adoption
• Knowledge or experience ofData Factory, Data Lake, Azure SQL database, Azure SQL Data warehouse, Azure Analysis Services, R Studio, Python, Power Apps or Microsoft Fabric.

Considerable technical knowledge or experience in any of the following:

• Power BI Report Server or Cloud based Service, or similar visualisation experience.
• Database including MS-SQL, Oracle Database, Data warehousing, SQL and XML.
• Microsoft Fabric experience
• R or Python predictive modelling / classification

Experience in building dashboards, reports and cubes using SQL, MDX, DAX, Power Query M Code, Power BI or other visualisation tools.

Detailed understanding or experience of how to develop cloud-based data solutions and architecture.

Strong SQL skills for querying and creation of views/tables, functions and stored procedures.

Experience in gathering BI requirements and understand the business on different levels.

Experience in developing new or maintaining and improving existing ETL processes.

Experience in establishing and maintaining collaborative relationships with stakeholders.

Understanding dimensional modelling ideally for Public Sector

Good communications, interpersonal and presentation skills in order to influence internal stakeholders.

Ability to self-manage and work in a dynamic environment.

Experience of achieving results as a consequence of engaging with other business areas.

Willingness to embrace new ways of working and influence other parts of the business to adopt.

Ability to build effective relationships across Surrey business areas.

Ability to manage conflicting priorities, negotiate solutions and resolve problems with colleagues and customers.

A flexible and responsive approach to meeting work demands.

Positive about change, adapts rapidly to changing circumstances and encourages flexibility in others.

Why Work With Us? Policing is an exciting 24/7 business and we all have commitments outside work. 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

Please use the following links for more information on the benefits of working with Surrey Police

Further Information This role would also be currently eligible for an additional market supplement. This payment is discretionary and is subject to an annual review and/or any changes to role in line with Force policy.

For more information please contact Strategic Insights Manager: Tony Fenton-Jones:

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 .
. click apply for full job details