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.

Key responsibilities:

• 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 across contracts.
• Apply appropriate access controls, including row-level security, so client and personal data is only visible to those entitled to see it.

Stakeholder and business partnering:

• Act as key point of contact for an operational lead in relation to reporting of performance across a service area.
• Develop, promote and maintain strong relationships with key stakeholders, translating technical detail into language non‑technical audiences can act on.

Key Requirements:

• Advanced Power BI: semantic modelling (star schema), DAX including time intelligence and filter context manipulation, Power Query (M), workspace and app management, deployment pipelines, and row-level security.
• Advanced Excel: Power Query, pivot models, lookup and array functions.
• Sound grasp of data modelling and warehousing concepts — fact and dimension design, grain, slowly changing dimensions, incremental refresh.
• Demonstrable experience of automating a manual reporting process end to end, from source extract through to published output.

Essential — Commercial and Behavioural:

• Demonstrable experience of successfully operating in an equivalent role analysing and managing data, developing monitoring and reporting on business performance to achieve best in class performance.
• Ability to engage and influence at a senior level, both with internal and external stakeholders.
• Highly numerate and detail oriented, with excellent financial, analytical, problem solving and IT skills.
• Strong work ethic and high standards — committed to delivering on our “best in class” ambition.
• Understanding of UK GDPR and the handling of personal and special category data in a resident‑facing context.

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.