Performance Reporting Business Partner

Pinnacle Group is looking for an experienced Data and Reporting Business Partner to join our Homes division and take ownership of reporting across the business, delivering accurate, automated, and insightful data that enables informed decision-making for both internal stakeholders and clients. In this role, you will design, develop, and maintain Power BI data models and dashboards across all Homes contracts, departments, and divisions, translating key business and client KPIs into trusted reporting solutions.

Combining strong technical expertise with a business partnering approach, you will work closely with operational leaders and client contacts to create well-governed, automated data products that drive performance, support strategic objectives, and ensure regulatory and statutory reporting requirements are met accurately and on time. Our Homes Division delivers trusted housing management services across Affordable, Private Rented and Leasehold properties. We work with local authorities, registered providers and investors to support thriving communities.

The ideal candidate will be an experienced data and reporting professional with advanced Power BI expertise, a strong understanding of data governance and automation, and a proven ability to translate complex data into actionable business insights. You will be highly analytical and detail-oriented, with experience delivering performance reporting, improving data quality, and providing meaningful recommendations that support operational and strategic decision‑making.

Confident engaging with stakeholders at all levels, you will be able to communicate complex information clearly and build trusted relationships across the business. This is a hybrid role with travel required to Holborn, London.

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.

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.

• Reporting and dashboard delivery
• Design, build and maintain Power BI semantic models, reports and dashboards covering income collection, housing management, customer contact, repairs, complaints and asset management.
• Own end-to-end production of recurring client and internal performance packs, ensuring they are accurate, high quality and circulated in good time for members to review ahead of meetings.
• Deliver reporting to a consistent standard — documented definitions, version control, agreed refresh schedules and clear ownership — so outputs are repeatable and not dependent on any one individual.
• Data engineering and automation:
  Build and maintain Power Query (M) transformations and dataflows, replacing manual and spreadsheet-based processes with automated, scheduled refreshes.
• Develop DAX measures and calculation logic at the correct grain, including time intelligence, and performance‑tune models to keep report load times acceptable.
• Analysis and insight:
  Analyse underlying trends, variance and root causes, and issue findings and recommendations to key stakeholders as directed. Provide the analysis behind performance conversations — not just what the numbers are, but why they have moved and what should be done about it.
• Data quality and governance:
  Work with operational leads to improve cleanliness and integrity of the data held, including profiling, exception reporting and reconciliation between systems. Design and deliver training and guidance to operational teams to reduce incorrectly entered data at the point of capture. Maintain a documented data dictionary and KPI definition library so measures are calculated consistently…