Power BI Developer - #2196156

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.

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

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

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.

• Duration: Initial 3-month engagement
• Rate: £450 per day
• IR35: Outside IR35
• Location: Fully remote (UK-based)