Power BI Developer

Pinnacle Group; Liverpool; Hybrid; GBP 52,000 - 78,000; Full time

Benefits offered by this job

Flexible working arrangements

Private medical insurance

Annual leave and pension

Job summary

Pinnacle Group is seeking a Power BI Developer to design, develop and maintain dashboards, reports and data models supporting performance management and contract reporting. You will automate data feeds using Power Automate, and extend the Power Platform with Power Apps and SharePoint to streamline processes. Remote UK applicants are welcome.

The role emphasizes data quality, stakeholder engagement and continuous improvement across complex datasets from multiple systems.

Qualifications

• Strong experience delivering Power BI reports and dashboards.
• Experience transforming complex datasets into actionable insights.
• Good understanding of the Microsoft Power Platform (Power Automate, Power Apps, SharePoint).
• Ability to translate business problems into practical digital solutions; familiarity with AI possibilities.
• Excellent communication and stakeholder engagement skills.

Responsibilities

• Design, develop and maintain Power BI dashboards, reports and scorecards that provide operational and contract insights.
• Build and enhance Power BI data models, measures and calculations using DAX, Power Query and data modelling techniques.
• Transform complex datasets from multiple sources into accurate, reliable reporting solutions.
• Gather and translate business requirements into clear reporting and insight solutions for stakeholders.
• Use Power Automate to streamline data feeds, reporting processes and notifications.
• Support developing Power Apps and SharePoint solutions to improve data capture and efficiency.
• Collaborate with operations, commercial and technical teams to improve data quality and governance.
• Produce reports and recommendations to support continuous improvement and informed decisions.

Skills

Power BI

DAX

Power Query

Data modelling

Power Automate

Power Apps

SharePoint

Stakeholder engagement

Dataverse

APIs

Tools

Dataverse

APIs

Job description

Pinnacle Group are looking for a Power BI Developer to join our Pinnacle Service Families contract. Reporting to the Senior Performance Manager, you will be responsible for designing, developing and maintaining Power BI reports, dashboards and data models that support performance management, contract reporting and operational decision-making. Working with complex and varied datasets from multiple operational systems, you will transform data into clear, reliable and user-friendly solutions that enable stakeholders at all levels to better understand performance and identify opportunities for improvement. Alongside Power BI development, you will play a key role in enhancing the wider Microsoft Power Platform environment, identifying opportunities to automate data feeds, improve data capture, streamline manual processes and develop practical business solutions using Power Automate, Power Apps and SharePoint. Working closely with operational, commercial and technical teams, you will translate business requirements into scalable digital solutions that improve efficiency, strengthen data quality and support better outcomes across the contract.

Pinnacle Service Families manages 49,000 military family homes across the UK – one of the largest and most significant contracts within Pinnacle Group. Delivered on behalf of the Defence Infrastructure Organisation (DIO), part of the Ministry of Defence, our work supports service families by providing well-managed services and advocating for their needs in everything we do.

The ideal candidate will be an experienced Power BI Developer with strong skills in Power BI, DAX, Power Query and data modelling, combined with experience using Power Automate, Power Apps and SharePoint to improve processes and automate manual tasks. They will be comfortable working with complex datasets from multiple sources, turning data into meaningful insights that support business decisions. Strong stakeholder engagement skills, a solutions-focused mindset and a passion for continuous improvement are essential. A portfolio showcasing Power BI dashboards, automation workflows or business improvement projects would be highly advantageous.

This is a remote role; we welcome applications from candidates based anywhere in the UK.

Who we are

Pinnacle Group is a market-leading national provider of housing, neighbourhood and workplace services. With over thirty years of experience, we deliver expert, place-based management and maintenance solutions that enhance the everyday lives of the communities we serve.

We’re a people-first organisation with a values-driven culture that has stood the test of time –reflected in the way we care for both our employees and our customers.

Who we’re looking for

We’re looking for someone who not only meets the key criteria below but also embraces our core values – Trust, Respect, Involve, Challenge, and Deliver Excellence – and is committed to earning and maintaining the confidence of our clients and communities.

Key responsibilities include:

• Design, develop and maintain Power BI dashboards, reports and scorecards that provide meaningful operational, customer, compliance and contract performance insights.
• Build and enhance Power BI data models, measures and calculations using DAX, Power Query and best-practice data modelling techniques.
• Transform complex, incomplete and inconsistent datasets from multiple data sources into accurate, reliable and user-friendly reporting solutions.
• Gather and translate business requirements into clear reporting and insight solutions that meet stakeholder needs.
• Create reporting outputs that support operational management, KPI monitoring, trend analysis, exception reporting and senior leadership decision-making.
• Use Power Automate to streamline data feeds, reporting processes, notifications, approvals and other manual activities.
• Support the development of Power Apps and SharePoint solutions that improve data capture, process control and operational efficiency.
• Work closely with operational, commercial and technical stakeholders to improve data quality, reporting standards and performance management processes.
• Produce clear reports, presentations and recommendations that support continuous improvement and informed business decision-making.
• Ensure reporting solutions are well-governed, validated and clearly documented, while identifying opportunities to improve efficiency through automation and the wider Microsoft Power Platform.

Key Requirements

• Strong experience developing Power BI reports and dashboards, including DAX, Power Query, data modelling and report design.
• Experience working with complex, messy or incomplete datasets, transforming data into accurate, meaningful and actionable reporting outputs.
• Good understanding of the Microsoft Power Platform, particularly Power Automate, Power Apps and SharePoint, with experience automating processes and improving data capture.
• Experience building reporting solutions, improving data quality and translating business problems into practical digital solutions, with an interest in leveraging AI and emerging technologies to improve efficiency.
• Strong communication and stakeholder engagement skills, with the ability to present complex information clearly and work effectively with operational, commercial and technical teams.

Desirable

• Experience with Dataverse, APIs, data warehouse environments or structured UAT/testing of reporting outputs.
• A portfolio showcasing Power BI dashboards, Power Platform solutions, automation workflows or business improvement projects would be highly advantageous.

Our Offer

We believe that diversity makes us stronger. The more varied our workforce, the better we can understand, reflect and meet the needs of the communities we serve. That’s why we actively welcome applications from people of all backgrounds – especially those who represent the communities we work with every day.

As a colleague, you’ll be part of an inclusive and supportive culture where you’re encouraged to thrive. We’re committed to helping you reach your full potential through continuous learning, development opportunities and career progression.

In addition to statutory benefits such as sick pay, maternity/paternity leave, a pension scheme, and annual leave, we offer a wide range of additional benefits tailored to your role and business area, including:

• Maternity/paternity packages
• Flexible Working Arrangements
• Life Assurance
• Enhanced Pension Scheme
• Additional Annual Leave
• Private Medical Insurance
• Cycle to Work Scheme
• Employee Assistance Programme
• Retail Discounts
• Childcare Assistance
• Season Ticket Loans
• Sick Pay Schemes
• Personal Development Plans