Data Analyst – Finance & Business Performance

About the role

We are looking for a commercially‑focused Data Analyst to join a high‑performing finance and business performance function. The role combines data analytics, commercial insight and strategic decision‑making to turn operational and financial data into actionable business intelligence.

Key responsibilities

• Collect, validate and analyse operational and financial data from multiple business functions.
• Consolidate data from various sources and transform it into meaningful reporting outputs.
• Develop and maintain reporting solutions using Excel and Power BI.
• Create board‑level reporting packs and presentations for senior stakeholders.
• Analyse business performance, profitability, utilisation and key commercial KPIs.
• Support investment performance reporting and strategic decision‑making.
• Improve reporting processes, data quality and governance.
• Work with data‑warehouse outputs while managing data validation and reconciliation.
• Partner with business stakeholders to understand reporting needs and deliver actionable insight.
• Act as a bridge between business users and technical data teams and deliver ad‑hoc analysis.

Required profile

• Proven experience as a Data Analyst, BI Analyst, Reporting Analyst or similar.
• Background in Financial Services, Consulting, Professional Services or another KPI‑driven corporate environment.
• Advanced Excel skills including complex reporting, data manipulation, XLOOKUP, INDEX MATCH and SUMIFS.
• Strong Power BI experience covering dashboard development, data modelling, reporting and Power Query.
• Good working knowledge of DAX to create meaningful business metrics.
• Strong SQL skills for data extraction, transformation and analysis.
• Experience handling fragmented or imperfect data sets.
• Excellent stakeholder management and communication abilities.
• Ability to translate data into clear commercial insights and recommendations.
• Proactive approach to improving reporting processes and building scalable solutions.

Required skills

• Excel (advanced)
• Power BI
• DAX
• SQL
• Power Query

What we offer

• £70,000‑£75,000 base salary.
• Hybrid working model with three days per week in a Central London office.
• Exposure to senior leadership and board‑level reporting.
• Opportunity to influence reporting transformation and data‑maturity initiatives.
• Broad, commercially focused role spanning data analytics, business performance and investment reporting.
• Career progression within a growing and highly visible function.
• Collaborative environment with strong stakeholder exposure across the business.