This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
LINCOLNSHIRE POLICE JOB DESCRIPTION JOB TITLE: Business Intelligence Developer 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, Data Modelling & Architecture, Operational Support & Estate Management, Stakeholder Engagement & Requirements Gathering, DevOps & Delivery Processes, Research & Continuous Improvement, Documentation, Other Duties. EQUALITY, DIVERSITY, HEALTH & SAFETY, AND SAFEGUARDING: The post holder must support the Force Diversity Strategy, take reasonable care of themselves and others, and comply with safeguarding policies relating to children and vulnerable adults.
Job Responsibility
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
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
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
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
Create, update, and manage DevOps work items (user stories, tasks, bugs)
Contribute to version control, deployment pipelines, and release processes
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
Produce and maintain business requirement documents, technical design documents, implementation notes, and user guides
Requirements
Degree or equivalent qualification from a technology discipline
Demonstrate ability and experience of developing user requirements into successful BI visualisations (ideally using Power BI) to support organisational performance improvement
Experience of Data Warehouse Design
Experience of using and configuring Azure DevOps (ADO)
Proven analytical and problem-solving skills and demonstrable experience in providing technical and user support at an enhanced level
Understanding of data modelling techniques for relational and dimensional databases (e.g. dimensional modelling theory)
Knowledge or experience of ORACLE or Microsoft SQL Server databases including the creation of database objects and stored procedures
Business analysis knowledge
Working knowledge of ITIL
Working knowledge of XML, ASP.NET, HTML, Javascript, CSS and SQL Server
Ability to communicate effectively and professionally