Data and Analytics Specialist - Digital Financial Audit
Posted on Jul 15, 2022 by Allen Lane Ltd.
Are you a data analytics specialist looking for an opportunity to help build out a specialist audit Data & Analytics Operation? Are you interested in working directly with large government departments improving efficiency and insight into government data?
The National Audit Office (NAO) supports Parliament to hold the government to account for the way public services are delivered. Their primary role is to scrutinise public spending for Parliament.
A key part of the National Audit Office's (NAO) strategy is to make greater use of technology in the delivery of its audits. This includes the objective of embedding data analytics in their business as usual audit processes.
To this end they have recently developed a Cloud based data platform (called AIMS, Audit Information Management System) which is used as a central location to upload client data, analyse that data using in house developed applications, and store that data securely. The only data they are currently uploading, analysing and storing is general ledger data obtained from the NAO's financial audit clients, however they are actively working to expand this to sub-ledger and other data sets.
We are also building out a Specialist Financial Audit Data & Analytics Operations capability within their Digital Financial Audit [DFA] team to support and develop this strategic objective.
This Financial Audit (FA) Data & Analytics Specialist role is a wide-ranging role, requiring the holder of the role to effectively provide specialist delivery, development and support for Data & Analytics execution in support of Financial Audits.
The purpose of this role will be to support the FA D&A Manager, working with other FA D&A Specialists and the broader DFA (Digital Financial Audit) team to:
-Working with Financial Audit teams to support their use of service line wide Data & Analytics offerings through:
Assisting them with obtaining, understanding, reconciling, transforming and ingesting the required data. This includes the use of improved training, guidance and support elements
Using the analytics tools developed either through direct coaching or broader training, guidance and support elements
-Working with Financial Audit teams to identify audit challenges where Data & Analytics solutions will provide quality, efficiency or value add. Supporting the team with the development, execution and application of analytics to address these audit challenges
-Working with Data & Analytics stakeholder across the office to input into the maintenance and improvements of existing D&A tools, and development of new D&A tools for the FA service line. As well as the broader D&A offering through the key enablers such as infrastructure requirements, training, coaching, guidance
-Experienced in the use of data analytics for audit work and so be capable of providing solutions that address audit teams' needs
-The role requires a good understanding of auditing (including financial auditing and its associated professional standards requirements) and the methods and techniques typically applied in the audit process
-An understanding of data structures as understanding this will be integral to helping develop such solutions. Our data analytics work typically involves the major ERP systems (eg SAP and Oracle) so knowledge of these systems would be an advantage. However our around 400 audited bodies have a wide range of other finance systems so ability to deal with a range of systems will be required
-Good experience in SQL to analyse data
- For application development they use R and Python. For data visualisation they use Tableau and Power BI, so knowledge of some of these tools/languages would be desirable but training will also be provided
-An understanding of some of the key business processes operated by our clients (eg purchase to pay, order to cash and payroll) would also be desirable
-Given the NAO's strategic plan to move systems into the Cloud, experience gained in a Cloud environment would be valuable
-Enthusiasm and a commitment to providing excellent data & analytics offering
-Excellent communication and interpersonal skills
-Excellent presentational skills
-Good problem solver/logical thinker able to work through problems to identify root causes and solutions
-Brings new innovative and proactive ideas for improving data & analytics offerings
LOCATION: London or Newcastle. The new ways of working will include a mix of time at your assigned office, time at client sites across the UK as required and working from home. (2 days in the office a week)
SALARY: London: £54,735 -£65,146 Newcastle: £44,367- £59,088
ROLE TYPE: Permanent