Business Intelligence Developer

LINCOLNSHIRE POLICE JOB DESCRIPTION
JOB TITLE: Business Intelligence Developer POST NO:
GRADE:	SG1
DEPARTMENT:	IT
ACCOUNTABLE TO:	Data Architect (Data Team)
STAFF MANAGED:	0
LOCATION/WORK BASE:	Hybrid – Home/HQ

 

JOB PURPOSE AND SCOPE

The Power BI Developer will support the development, maintenance, and optimisation of the Force’s Microsoft Power BI estate. This includes designing and maintaining Power BI semantic models, datasets, dashboards, and dataflows to meet organisational reporting needs.

The post holder will work closely with stakeholders to gather and translate business requirements into effective BI solutions. They will collaborate with data engineers to produce technical design documentation and ensure that all developments align with Force standards, governance, and security requirements.

It is essential for the post holder to create and maintain positive communications to ensure effective working relationships with individuals, teams, and colleagues. All staff must demonstrate Force values and operate in accordance with the Code of Ethics.

 

CORE WORK AREAS

Power BI Development

• Design, develop, and maintain Power BI reports, dashboards, and paginated reports.
• Build and optimise Power BI semantic models, including star schemas, relationships, measures, and row-level security.
• Create and maintain dataflows and shared datasets to support enterprise reporting.

Data Modelling & Architecture

• Apply dimensional modelling principles to support analytical workloads.
• Work with data engineers to design and document technical solutions.
• Ensure interoperability with the wider data platform.

Operational Support & Estate Management

• Maintain the day-to-day running of the Force’s Power BI estate, including workspace management, dataset refresh monitoring, gateway oversight, and performance optimisation.
• Ensure all developments adhere to Force processes, security standards, and testing requirements.

Stakeholder Engagement & Requirements Gathering

• Engage with business stakeholders to gather, document, and validate business requirements.
• Produce Business Requirements Documents (BRDs).
• Support the Force Performance Management Team in data visualisation and insight delivery.

DevOps & Delivery Processes

• Create, update, and manage DevOps work items (user stories, tasks, bugs).
• Contribute to version control, deployment pipelines, and release processes.

 

 

 

Research & Continuous Improvement

• Keep abreast of technological advances in Power BI, Microsoft Fabric, and related BI technologies.
• Evaluate and recommend tools, standards, and practices to support BI capability development.

Documentation

• Produce and maintain business requirement documents, technical design documents, implementation notes, and user guides.

Other Duties

The post holder may be required to undertake other duties within the general scope of the role. These duties should not substantially change the nature of the post.

EQUALITY, DIVERSITY, HEALTH & SAFETY, AND SAFEGUARDING

The post holder must:

• Support the Force Diversity Strategy.
• Take reasonable care of themselves and others.
• Comply with safeguarding policies relating to children and vulnerable adults.

 

 

 

 

Post Title: Business Intelligence Developer	Post Number:
Section: Information Technology	Grade: SG1

 

This form sets the standard for the person needed for this job, and also will be the basis for shortlisting and for the questions to be asked at interview. The requirements are job-related and described using appropriate words and marked E (Essential) or D (Desirable) as appropriate. There will not necessarily be an entry in every box.

 

 

	Requirements	Essential (E) or Desirable (D)	Measurement (see below)
Qualifications/ Training	Degree or equivalent qualification from a technology discipline	D	A
Experience	Demonstrate ability and experience of developing user requirements into successful BI visualisations (ideally using Power BI) to support organisational performance improvement	E	I
	Experience of Data Warehouse Design	D	A/I
	Experience of using and configuring Azure DevOps (ADO).	D	A/I
Skills	Proven analytical and problem-solving skills and demonstrable experience in providing technical and user support at an enhanced level	E	A/I
Knowledge	Understanding of data modelling techniques for relational and dimensional databases (e.g. dimensional modelling theory)	E	A/I
	Knowledge or experience of ORACLE or Microsoft SQL Server databases including the creation of database objects and stored procedures	E	A/I
	Business analysis knowledge	D	A/I
	Working knowledge of ITIL	D	A/I
	Working knowledge of XML, ASP.NET, HTML, Javascript, CSS and SQL Server	D	A/I
Social Skills	Ability to communicate effectively and professionally	E	A/I
Others	Full UK Driving Licence	E	A
	Achieve suitable security clearance	E	O

 

 

Measurement	A. From application form	T. By test after shortlisting	I. Probing at interview	P. Presentation
	R. References		O. Other (please specify)