Business Intelligence Developer

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

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

Setting up connection details and scheduling for data pipelines

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., 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.

• 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 of Data 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.

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.

Chief Constable Tim De Meyer & Chief Constable Jo Shiner, This role carries a market supplement of £5,000. An additional skills supplement may also be applied, subject to the successful candidate demonstrating the required skills and experience., 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, 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 noreply@policejobssurreyandsussex.as.recruitmail.com 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