Senior Data Analyst - Advisory in Audit - Deloitte China
31 July, 2018
Analytics can materially enhance the quality, efficiency and insight of an audit; Deloitte’s vision is for analytics to be used on all audits. The Deloitte Analytics Centre is to support Audit staff and engagement teams with data extraction, formatting and uploading it into the Analytics Solution. If you’re a team player and strong communicator who understands the importance of deadlines and the value of great service, you might just find what you’re looking for at Deloitte. The main activities of the team will include: • Being the engagement team’s first point of call when using the Analytics Solution for troubleshooting or general functionality queries; providing them with assistance and guidance in the use of our bespoke Analytics Solution. • Provide in-country support for data acquisition and extraction from clients’ accounting systems. • Carry out the manipulation and upload of the more complex data sets from a variety of finance systems across various business areas and clients into an in-house built system. • Having a high level understanding of the system being supported and use Microsoft SQL to troubleshoot any issues raised by the Audit practice. Description: • Data manipulation using SQL to load data packages. • Perform reconciliations to verify the completeness of datasets provided to you. This task will require a degree of problem solving and the ability to understand basic accounting concepts which will be part of the training provided. • Using your understanding of the system being supported to troubleshoot issues using the SQL backend. • Manage a portfolio of engagement teams, ensuring tasks are being done by CoE in an efficient and accurate manner. • Assist and guide audit teams with data extraction from client systems. • Supporting junior data analysts in resolving data quality or integrity issues within their own datasets. • Manage a micro team of junior data analyst and being responsible for the output of your micro team. Responsibility: • Preferably in Computer Science, Mathematics or Science related. However consideration will be given to other skills • A level in Mathematics, Physics, Chemistry, Computing or IT is preferred • An understanding of basic accounting principle is beneficial but not required. • One year’s prior experience working with SQL is required • Individuals should be enthusiastic and have a flair for problem solving and troubleshooting • A strong working knowledge of Excel (including formulae such as SUM, COUNT, IF, VLOOKUP, ISERROR) • Good communication skills both verbal and written (English Language) • Strong interpersonal skills and the ability work in a team
“Deloitte” is the brand under which tens of thousands of dedicated professionals in independent firms throughout the world collaborate to provide audit & assurance, consulting, financial advisory, risk advisory, tax and related services to select clients.Deloitte is one of the "Big Four" accounting organizations and the largest professional services network in the world by revenue and number of professionals.