Business Intelligence Developer

Join to apply for the Business Intelligence Developer role at Surrey and Sussex Police

Vacancy Information

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.

• Designing and developing reports based on specification from the business that drive day-to-day decisions as well as performing deep analysis on key questions facing the team.
• Develop semantic models and pipelines to support the build of dashboards based on Microsoft Power BI.
• Develop 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.
• Develop data pipelines from Microsoft Fabric and integration products to exploit and maximise a range of data systems.
• Understand and interpret user specifications and gather requirements through user interviews, workshops, prototyping, and document requirements for business partners and IT colleagues.
• Test and accuracy-check data lists and aggregations.
• Engage with existing and prospective users to understand and document information needs based on business processes and decisions.
• Provide support to BI projects to enable them to meet deadlines.
• Collaborate with DDaT colleagues to understand and document available data sources and their interrelations.
• Design solutions with team members and develop governance and control processes.
• Work with quality assurance to ensure that business requirements are met.
• Partner with business and user group representatives to understand reporting and analysis needs.
• Analyse and document available data sources and data flows to standards and in a consistent manner.
• Produce creative dashboards in Power BI Desktop using various visualization tools; create custom visuals through the Software Development Kit (SDK).
• Set up connection details and scheduling for data pipelines.
• Work closely with key business users to establish and document detailed reporting requirements.
• Analyse legacy reporting solutions and design effective Power BI alternatives.
• Promote Power BI and explore ways to leverage data sources for effective reporting.
• Provide end-to-end documentation including architecture designs, technical specifications and end-user support guides.
• Support non-technical users in the use of Power BI as a self-service tool.
• Deliver a platform focused on self-service capabilities where possible.
• Engage with senior leaders to articulate and deliver the benefits of Power BI.
• Collaborate with business areas to prepare for new reporting methods, considering behavioural, skill, or culture change requirements.
• Document requirements and development steps for stakeholders; adhere to Programme and project Governance requirements.
• Ensure AI adheres to current guidance from the Information Commissioners Office.

• A degree in statistics, mathematics or a statistically-related discipline.
• Demonstrate work experience with Microsoft Fabric, Mulesoft, BI Developer or Data Scientist roles.
• 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 grounding in 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.

• Power BI Report Server or Cloud based Service, or similar visualization experience.
• Databases 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 visualization tools; understanding of cloud-based data solutions and architecture; strong SQL skills for querying and creating views, tables, functions and stored procedures.

Additional experience in gathering BI requirements, stakeholder collaboration, dimensional modelling (ideally for the Public Sector), and change management is desirable.

Policing is an exciting 24/7 business and we all have commitments outside work. We support flexible working, including conversations about job shares and part-time working. We encourage agile working and the ability to manage your own diary and work location to serve the public. Benefits include career progression, contributory pension (LGPS), generous annual leave, discounts, on-site gyms, parental leave, wellbeing support, and discounted healthcare.

Further information about Surrey Police and Surrey Police benefits is available via the provided links.

Additional Information
This role may be eligible for an additional market supplement. The payment is discretionary and subject to annual review and changes to role in line with Force policy. For more information please contact Strategic Insights Manager: Tony Fenton-Jones.

Diversity Statement

We are committed to an inclusive workplace. We are a signatory of several equality initiatives and strive to be anti-racist, open and accessible to all. We encourage applications from diverse backgrounds. For more information on Equality, Diversity and Inclusion, visit Surrey Police and Sussex Police pages.

Attachments

• Business Intelligence Developer Level 1.docx