Power BI Developer
Power BI/Business Intelligence Consultant
Location: UK Remote
Contract: Initial 3 Months
Day Rate: £450 per day
IR35 Status: Outside IR35
We are seeking an experienced Power BI/Business Intelligence Consultant to support the development of a modern, data-driven People Analytics function.
This is an exciting opportunity to work closely with HR and senior business stakeholders, transforming people data into meaningful insights that support better decision-making across the employee lifecycle.
You will take ownership of the reporting and analytics solution, from gathering business requirements and defining key metrics through to developing high-quality dashboards and building robust, scalable data models.
Working alongside an established Data Engineering team, you will leverage existing cloud data infrastructure and curated datasets to deliver accurate, well-governed reporting solutions.
The ideal candidate will combine strong technical Power BI expertise with excellent stakeholder engagement skills and the ability to translate complex data into clear, actionable business insights.
Key Responsibilities- Engage with HR leaders, HR Business Partners and HR systems teams to understand reporting requirements and translate business needs into meaningful KPIs and analytics solutions.
- Design, develop and maintain interactive Power BI dashboards covering key workforce metrics, including headcount, recruitment, attrition, employee engagement, absence, diversity, learning and performance.
- Build scalable, reusable semantic models using dimensional modelling, star schema principles, advanced DAX and calculation groups.
- Integrate Power BI with Databricks, utilising Databricks SQL and Unity Catalog to access curated datasets.
- Optimise data models, queries, refresh processes and storage modes to improve reporting performance and scalability.
- Implement appropriate security measures, including Row-Level Security (RLS) and Object-Level Security (OLS), ensuring sensitive employee data is protected and GDPR requirements are met.
- Establish best practices for report development, documentation, naming conventions, version control and deployment management.
- Define and maintain consistent People metrics, supporting a reliable single source of truth across the business.
- Collaborate with Data Engineers to define data requirements, validate datasets and investigate data quality issues.
- Promote self-service reporting through stakeholder training, knowledge sharing and reusable, certified datasets.
- Monitor dashboard usage and adoption, gathering feedback and identifying opportunities to improve the reporting environment.
- Present findings and recommendations to senior stakeholders, translating complex data into clear business insights.
Essential Skills & Experience
- Extensive commercial experience delivering end-to-end Power BI solutions within a business environment.
- Advanced DAX skills, including complex measure development and performance optimisation.
- Strong understanding of data modelling, dimensional modelling, star schemas and semantic layer design.
- Strong SQL skills and experience working with modern cloud data platforms.
- Experience integrating Power BI with Databricks, particularly Databricks SQL and Unity Catalog, is highly advantageous.
- Strong Power Query (M) experience, including data transformation and refresh management.
- Solid understanding of Power BI Service, gateways, deployment pipelines and workspace administration.
- Experience implementing Row-Level Security and working with sensitive or regulated datasets.
- Excellent stakeholder management and consulting skills, with the confidence to challenge requirements and make recommendations.
- Strong data visualisation skills and the ability to communicate insights effectively to non-technical audiences.
- Experience with version control, release management and structured BI development practices.
The Ideal Candidate
You will be a hands-on BI Consultant who can work independently, engage confidently with senior stakeholders and take ownership of delivering a high-quality analytics solution.
You will be equally comfortable discussing business requirements with HR leadership, working through technical challenges with Data Engineers and presenting insights that influence business decisions.
Contract Details- Duration: Initial 3-month engagement
- Rate: £450 per day
- IR35: Outside IR35
- Location: Fully remote (UK-based)