Data analyst in financial reporting in London

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.

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 (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) and 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.

Requirements:

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

Desirable:

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

Conditions:

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