BI Developer – AR

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

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.

• 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.

• 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.

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

• 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.

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

• 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.

• 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.

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

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

• 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.

• 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.