Share this Job

Excel Modelling Analyst

Date: Nov 5, 2020

Location: London, United Kingdom

Company: KPMG UK

The Team

The capabilities within the Clara Analytics Team are vast as they are unique: from Innovations – spearheading the creation of audit applications such as the Inventory Count Tool, and Confirmations Tool – to the performance of D&A procedures by the ERP, General Ledger and Bespoke capabilities. At the face of the team, the Business Relationship Group bridge the gap between audit teams and D&A specialists – providing one point of contact for D&A interpretation, queries and support.

Whether it involves providing Skype workshops to audit teams, presenting a Proof of Concept to leadership, or engaging in in-depth analysis using our market leading technology capabilities, the Clara Analytics Team leverages a wide variety of skillsets. There are technical specialists performing D&A procedures, and there are those with in-depth audit experience; some of us enjoy giving presentations, for others, their strengths lie in analysing complex datasets. One thing that we all share in common, is a commitment to continuous improvement and innovation – both in our work, and our approach to solving problems.

We’re flexible, too. The Clara Analytics team straddles different KPMG office locations – with large hubs in Leeds, London (CSQ), Birmingham, Manchester and Edinburgh – all leveraging skype to communicate remotely where needed.

If you’re looking for a challenging, yet rewarding role putting you at the centre of a rapidly-changing audit practice, the Clara Analytics Team could be the place for you.


This is an exciting role for someone who has strong excel skills and is eager to develop a specialism. You will be working within an expanding Technology team, who are building a new Excel modelling capability and that’s where you come in.

On a typical day your primary role will be managing a busy mailbox, triaging requests from our client facing Audit staff, reviewing complex client Excel spreadsheets to determine what needs to be Audited. Holding consultations with the Auditor to scope (and descope) the activities required on any given request and agree a timeline for completion. You will also be required to identify available resource within our operational team using our resource schedule to allocate each request.

There may from time to time be ad-hoc excel projects that require support, including creating MI reports and other modelling activities.

The Role

-Manage a busy mailbox day to day.
-Process requests, evaluating complexity of spreadsheets, scoping the activities for the operational team to undertake.
-Hold consultations with Auditors regarding the audit of spreadsheets.
-Escalate issues to Team Leader as required.
-Establish strong relationships with audit teams and clients.
-Prepare documentation of modelling work performed and deliverables for use by audit teams
-Manage the needs of multiple stakeholders:ensuring deadlines are met and keeping audit teams and the Clara Analytics Team lead updated; reacting quickly to any issues; deal with various audit teams concurrently.
-Contributing to practice management, e.g. innovation, training, knowledge management.
-Develop and implement best practice to ensure that ‘quality’ is embedded within all activities performed by the team.

The Person

-Strong knowledge of excel including writing complex formulas
-Excellent communication skills with an ability to give instructions to non-technical audience.
-Proactive attitude with an eagerness to learn.
-Excellent oral and written communication skills and confidence to promote and present value of solutions.
-Excellent organisational and project management skills.
-Ability to function effectively in challenging situations/circumstances.
-A flexible approach and ability to multi-task, manage time effectively and handle tight deadlines.
-Proven experience of working within a fast paced environment with conflicting priorities and deadlines.
-Ability and willingness to network both internally and externally with key decision makers.
-Pro-active and innovative in approach.


Job Segment: Accounting, ERP, Project Manager, Finance, Technology