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.

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.