Performance Reporting Business Partner

Pinnacle Group

Greater London

Hybride

GBP 60 000 - 80 000

Plein temps

14 jours+

Générateur de candidature

Une candidature complète en une minute — un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Avantages offerts par ce poste

Flexible Working Arrangements

Private Medical Insurance

Life Assurance

Additional Annual Leave

Résumé du poste

Pinnacle Group is seeking an experienced Data and Reporting Business Partner to own reporting across the Homes division. You will design, develop, and maintain Power BI data models and dashboards across contracts, translating KPIs into trusted reporting solutions for internal stakeholders and clients.

Hybrid role with travel to Holborn, London. You will partner with operational leaders to deliver automated data products, ensure data quality, and meet regulatory reporting requirements while

Qualifications

Advanced Power BI with semantic modelling and DAX.
Experience in automating reporting end-to-end.
Excellent stakeholder engagement at senior levels.

Responsabilités

Design, build and maintain Power BI models, reports and dashboards.
Own end-to-end production of recurring client/internal performance packs.
Deliver consistent reporting with documented definitions and version control.
Develop data transformations and dataflows in Power Query.
Analyze trends, variance and provide recommendations.

Connaissances

Power BI

Data governance

Automation

DAX

Data modelling

Stakeholder engagement

Outils

Power Query

Excel

Description du poste

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

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