Power BI Developer
The Civic
Lincoln, United Kingdom
2 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
£ 126KJob location
Lincoln, United Kingdom
Tech stack
Business Analytics Applications
Data Governance
ETL
Data Mining
Data Structures
DevOps
Microsoft Dynamics
Power BI
Microsoft Power Automate
Powerquery
Microsoft Fabric
Data Lake
Star Schema
Azure
Software Version Control
Powerapps
Job description
- The Power BI Developer will support Lincolnshire County Council in delivering high-quality data reporting solutions for Customer Service and Contact Centre operations.
- The role will focus on designing, building, and optimising Power BI dashboards using data from Dynamics 365 / Dataverse.
- The postholder will translate operational requirements into meaningful KPIs and actionable insights, enabling data-driven decision-making.
- Working within IT Enterprise Architecture, the role will ensure robust data governance, performance optimisation, and scalable reporting solutions., * Design, develop, and maintain Power BI dashboards and reports using DAX, Power Query (M), and best practice data modelling (e.g. star schema).
- Extract, transform, and load data from Dynamics 365 / Dataverse using appropriate methods (connectors, TDS, Synapse Link, Fabric).
- Develop reporting solutions for Customer Service / Contact Centre environments, including cases, queues, SLAs, and agent performance.
- Implement Row-Level Security (RLS) and ensure data governance standards are met.
- Optimise data models and report performance to ensure efficiency and scalability.
- Work closely with stakeholders to define KPIs, metrics, and reporting requirements.
- Translate business needs into clear, user-friendly dashboards and visualisations.
- Support data refresh processes and ensure data accuracy and integrity.
- Contribute to continuous improvement of reporting frameworks and analytics capability.
- Collaborate with wider IT and data teams within Enterprise Architecture.
Requirements
- Strong hands-on experience with Power BI development (DAX, Power Query (M), data modelling).
- Proven experience working with Dynamics 365 / Dataverse data structures (tables, relationships, option sets, custom tables).
- Experience delivering reporting solutions within Customer Service or Contact Centre environments.
- Strong understanding of data extraction, transformation, and refresh strategies.
- Experience implementing Row-Level Security (RLS), governance, and performance optimisation.
- Ability to define KPIs and translate operational requirements into effective dashboards.
- Good understanding of data modelling techniques, particularly star schema design.
- Strong analytical and problem-solving skills.
- Excellent stakeholder engagement and communication skills.
- Knowledge of contact centre metrics such as First Contact Resolution (FCR), Average Handling Time (AHT), backlog and ageing.
- Experience with Microsoft Power Platform (Power Apps, Power Automate).
- Familiarity with ALM/DevOps practices for Power BI (pipelines, version control, deployments).
- Experience with Microsoft Fabric, Azure Synapse, or Data Lake analytics solutions.
