Data analyst in financial reporting

Cluttons; Greater London; Hybrid; GBP 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid working

25 days holidays

Enhanced auto enrolment pension

Life assurance

Cycle to work scheme

Employee Assistance Programme

Help@Hand Remote GP

Discounts at retailers

Family & wellbeing policy

Job summary

Cluttons is seeking a senior data & reporting architect to design and deliver a secure, scalable data and reporting environment. You will integrate multiple data sources, build a central data model, and develop Power BI dashboards to provide actionable leadership insights.

You will lead the adoption of Microsoft Fabric and the broader Microsoft data ecosystem, collaborating with Finance, commercial teams and Central Services.

Qualifications

• Proven track record delivering enterprise reporting platforms in a professional services environment.
• Power BI (data modelling, DAX, reporting)
• Microsoft Fabric and wider Microsoft data ecosystem
• Data architecture and integration design
• Use of APIs and SQL to extract and model data
• Experience delivering financial and operational reporting, including pipeline, utilisation and profitability
• Strong stakeholder engagement skills, with the ability to operate at senior leadership level
• Knowledge of property management accounting databases and practices; Experience in property, consultancy or professional services firms; Familiarity with Monday.com; Experience developing unified dashboards across multiple business systems

Responsibilities

• Define and implement the target architecture for Cluttons' data platform, ensuring it is secure, sustainable, scalable and fit for purpose.
• Ensure optimal use of the Microsoft data ecosystem, including Azure-based services where appropriate.
• Lead the design and build of a centralised data model integrating key systems and data stores.
• Establish best practice around data structure, integration and lifecycle management.
• Lead the implementation and use of Microsoft Fabric as the core data platform.
• Define and manage data ingestion, transformation, modelling and semantic layers.
• Ensure compliance with information security and regulatory requirements.
• Deliver a standardised reporting suite covering pipeline, timesheets and financial performance across all business dimensions.
• Develop and maintain Power BI dashboards and reports that are intuitive, accurate and aligned to business needs.
• Work closely with senior stakeholders across Finance, commercial teams and Central Services to define reporting requirements.
• Translate business needs into robust, scalable technical solutions.
• Drive adoption of reporting tools and promote a data-driven culture across the business

Skills

Power BI

DAX

Microsoft Fabric

APIs

SQL

Data modelling

Data architecture

Stakeholder engagement

Tools

Power BI

Microsoft Fabric

SQL

Job description

Описание:

This is a newly created role responsible for designing and delivering Cluttons' secure, scalable data and reporting environment, enabling consistent, high-quality management information across the business. The role will play a critical part in moving Cluttons towards a fully integrated data environment, combining multiple data sources into a consistent reporting layer and delivering actionable insight to leadership.

Задачи:

Define and implement the target architecture for Cluttons' data platform, ensuring it is secure, sustainable, scalable and fit for purpose. Ensure optimal use of the Microsoft data ecosystem, including Azure-based services where appropriate. Lead the design and build of a centralised data model integrating key systems and data stores (e.g. finance system, pipeline and timesheets which are currently in a data warehouse). Establish best practice around data structure, integration and lifecycle management. Lead the implementation and use of Microsoft Fabric as the core data platform. Define and manage data ingestion, transformation, modelling and semantic layers. Ensure compliance with information security and regulatory requirements. Deliver a standardised reporting suite covering pipeline, timesheets and financial performance across all business dimensions (sector, service line, team and client). Ensure reporting supports both: Operational management (day-to-day performance), Strategic decision-making (forecasting, growth and profitability) Develop and maintain Power BI dashboards and reports that are intuitive, accurate and aligned to business needs. Work closely with senior stakeholders across Finance, commercial teams and Central Services to define reporting requirements. Translate business needs into robust, scalable technical solutions. Drive adoption of reporting tools and promote a data-driven culture across the business

Требования:

Proven track record delivering enterprise reporting platforms in a professional services environment Power BI (data modelling, DAX, reporting) Microsoft Fabric and wider Microsoft data ecosystem Data architecture and integration design Use of APIs and SQL to extract and model data Experience delivering financial and operational reporting, including pipeline, utilisation and profitability Strong stakeholder engagement skills, with the ability to operate at senior leadership level Ability to combine strategic thinking and clear communication of complex data with hands‑on delivery Будет плюсом: Knowledge of property management accounting databases and practices; Experience working within property, consultancy or professional services firms; Familiarity with Monday.com; Experience developing unified dashboards across multiple business systems

Условия:

• Hybrid working - to give you the flexibility you need
• Holidays: 25 days increasing in line with length of service to a maximum of 30 days
• Enhanced auto enrolment pension scheme - to help you save for the future
• Life assurance - to protect your loved ones should the worst happen
• Interest free season ticket loans
• Cycle to work scheme - discounted bicycles
• Flu and eye care vouchers - to keep you healthy
• Employee Assistance Programme - 24/7 health & wellbeing support
• Help@Hand Remote GP app - to give you and your family access to medical experts quickly
• Platform hosting 1000s of discounts at your favourite retailers, restaurants, supermarkets, leisure & days out venues, gyms and more
• Family & wellbeing policy - including enhanced maternity pay, menopause support, neurodiversity support, carer support, company sick pay and much more
• Purchasing up to 5 days additional holiday
• Discounted gym membership
• Discounted dental insurance
• Discounted private medical insurance for family cover
• Discounted critical health insurance and more