BI Developer – AR

Job Details

Job Description

Business Intelligence Developer (Power BI)

Department: Information Technology
Grade: SG1
Location: Hybrid (Home / HQ)
Accountable to: Data Architect (Data Team)
Staff Managed: None

Job Purpose

The Business Intelligence Developer will be responsible for the development, maintenance, and optimisation of the organisation’s Microsoft Power BI environment. This includes designing and supporting semantic data models, datasets, dashboards, and dataflows to deliver accurate, secure, and insightful reporting solutions.

The role involves working closely with business stakeholders to understand reporting requirements and translating these into effective BI solutions. The post holder will also collaborate with data engineers to ensure robust technical design and alignment with organisational data architecture, governance, and security standards.

Key Responsibilities

Power BI Development

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

Data Modelling & Architecture

  • Apply dimensional modelling principles to support analytical and reporting requirements.
  • Work with data engineers to design and document technical solutions.
  • Ensure BI solutions align with wider data architecture and integration standards.

Platform Support & Maintenance

  • Manage day-to-day operation of the Power BI estate, including workspaces and datasets.
  • Monitor data refresh processes and gateway performance.
  • Optimise report performance and ensure system reliability.
  • Ensure compliance with organisational security and governance standards.

Stakeholder Engagement & Requirements Gathering

  • Engage with stakeholders to gather, document, and validate business requirements.
  • Produce Business Requirements Documents (BRDs).
  • Support performance and operational teams with reporting and insight delivery.

DevOps & Delivery

  • Create and manage work items in Azure DevOps (user stories, tasks, bugs).
  • Support version control, deployment pipelines, and release management processes.

Documentation & Continuous Improvement

  • Produce and maintain technical documentation, implementation notes, and user guides.
  • Research and evaluate new BI tools, technologies, and best practices (including Microsoft Fabric and Power BI enhancements).
  • Contribute to continuous improvement of BI standards and processes.

Core Skills & Knowledge

  • Strong experience with Microsoft Power BI development.
  • Understanding of data modelling techniques (relational and dimensional).
  • Proficiency in SQL and experience with Oracle or Microsoft SQL Server.
  • Ability to translate business requirements into technical BI solutions.
  • Strong analytical and problem-solving skills.
  • Understanding of data warehouse concepts.

Desirable Skills

  • Experience with Azure DevOps (ADO).
  • Knowledge of ITIL processes.
  • Understanding of XML, HTML, JavaScript, CSS, or ASP.NET.
  • Experience working within a data warehouse environment.
  • Business analysis knowledge.

Qualifications

  • Degree or equivalent qualification in a technology-related discipline (desirable).

Personal Attributes

  • Strong communication skills with the ability to engage both technical and non-technical stakeholders.
  • Ability to work independently and collaboratively in a team environment.
  • High attention to detail and commitment to data accuracy.
  • Ability to manage multiple priorities in a structured and organised manner.

Other Requirements

  • Full UK Driving Licence.
  • Ability to obtain and maintain appropriate security clearance.
  • Commitment to equality, diversity, safeguarding, and organisational policies.
  • Compliance with health and safety responsibilities.