Performance Reporting Business Partner

Pinnacle Group Limited

Greater London

Hybrid

GBP 60,000 - 90,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

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

Job summary

Pinnacle Group is seeking an experienced Data and Reporting Business Partner to own reporting across the Homes division, delivering automated, trusted data for decisions. You will design, develop and maintain Power BI models and dashboards for all Homes contracts, partnering with operational leaders and client contacts to translate KPIs into actionable insights while ensuring data quality, governance and regulatory compliance.

This is a hybrid role with travel to Holborn, London.

Qualifications

Advanced Power BI: semantic modelling, DAX, time intelligence, row-level security.

Responsibilities

Design, build and maintain Power BI dashboards and semantic models for housing management, income, customer contact, repairs and asset management.

Skills

Power BI expertise

DAX

Time intelligence

Power Query (M)

Data modelling

Excel advanced

Tools

Power BI

Power Query (M)

DAX

Excel

Data warehousing concepts

Job description

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.

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-drivenculture 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 iscommittedto earning and maintaining the confidence of our clients and communities.

Key Responsibilities

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

Essential — Technical

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.

Desirable

Microsoft certification: PL-300 (Power BI Data Analyst Associate), DP-600 (Fabric Analytics Engineer) or DP-900 (Azure Data Fundamentals).
Experience of Microsoft Fabric, Azure Data Factory, Synapse or an equivalent cloud data platform.
Experience of fuzzy or probabilistic matching for address and property-level data reconciliation.
Power Automate, Power Apps or similar for workflow and structured data capture.
Experience working with housing management systems and their underlying data structures (e.g. Qube/MRI, Northgate, Plentific, Apex).
Experience of working in the social housing sector, with working knowledge of housing legislation and regulatory compliance.
Familiarity with the regulatory reporting landscape for example: Tenant Satisfaction Measures, Statistical Data Return, the Housing Ombudsman Complaint Handling Code, and the direction of travel on Awaab’s Law and damp and mould reporting.

Our Offer

We believe that diversity makes us stronger. The more varied our workforce, the better we canunderstand, reflect and meet the needs of the communities we serve.That’s why we activelywelcome 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 aninclusiveandsupportiveculture where you’re encouraged to thrive. We’re committedto helping you reach your full potential through continuous learning, development opportunities and career progression.

Benefits