Audit Analytics - Senior Data Extraction Specialist

Audit & Accounting | Core Audit Services
Same job available in 3 locations

Chicago, Illinois, United States

Los Angeles, California, United States

New York, New York, United States

Position Summary

Are you an individual with strong data extraction skills with a good knowledge in SQL and ERP financial systems? Do you enjoy working with innovative technologies to turn data into information? At Deloitte, we provide teams with a way to innovate their audit delivery to achieve greater effectiveness and consistency in executing the audit. Data acquisition can many times be the greatest challenge in the analytic development and deployment process. In this role, the specialist will manage and drive the process of linking client data repositories to analytic needs through their ERP knowledge and technical extraction and analytical skills.

Work you’ll do
As an Audit Analytics Senior-Data Extraction Specialist, you will play a critical role in data extraction from various ERP financial systems by determining the tables, fields, filters, and transformations required for analytics that will be used by audit engagement teams. You will be working with a team of experienced leads, technical developers, ERP specialists, testers and business resources to build deliverables that support audit quality and objectives. You will be part of a team working closely with the senior leadership. You’ll use your analytical, research and investigative skills to:

  • Develop and drive data extraction from various ERP financial systems by analyzing specific use cases through platform enabled data sources.
  • Liaise and communicate effectively with cross border teams.
  • Ensure the work performed is in accordance with quality standards of the organization.

The team
Our audits are fueled by more than just technology – what sets us apart are our insightful professionals, collaborative culture, and commitment to innovation and continuous improvement. Our audit professionals apply a streamlined, intelligent approach to the audit, enabled by innovative tools and technologies. Quality is our top priority, and by focusing on innovation, we continue to raise the bar of quality and deliver greater value to our clients. Learn more about Deloitte Audit.


  • Bachelor’s or degree in engineering, computer science and/or management information systems or equivalent years of relevant experience.
  • 6+ years of overall experience, with a blend of functional knowledge (audit, accounting, finance) and technical knowledge (SQL).
  • Strong knowledge and working experience with SQL, relational databases and data modelling.
  • Deep knowledge of at least one of the following ERP systems: SAP, Oracle, JD Edwards, Microsoft Dynamics AX, Great Plains, or Peoplesoft.
  • Working knowledge of audit, accounting, and finance concepts (e.g. reconciliation and financial reporting).
  • Ability to write and produce technical documents with experience in demonstrating technical solutions to end-users.
  • Good knowledge of testing and quality assurance for new development of data extraction procedures.
  • Ability to perform data quality checks and identify and analyze data anomalies / issues.
  • Good understanding of various SDLC processes including Agile methodologies (e.g. Scrum and SAFe).
  • Ability to travel up to 30%, on average, based on the work you do and the clients and industries/sectors you serve
  • Limited immigration sponsorship may be available


  • Master’s degree in related field
  • Good experience with ETL Tools (e.g. Informatica)
  • Good knowledge in data warehouse concepts
  • Functional or technical certification in any ERP system (e.g. SAP/ Oracle/ PeopleSoft)
  • Working knowledge of Azure DevOps (VSTS)
  • Experience working independently on multiple assignments or engagements, even in a virtual environment

Our people and culture

Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work. Learn more about our inclusive culture.

Professional development

From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

As used in this posting, "Deloitte" means Deloitte & Touche LLP, a subsidiary of Deloitte LLP. Please see for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Certain services may not be available to attest clients under the rules and regulations of public accounting.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, where applicable. See notices of various ban-the-box laws where available.

Requisition code: 107386


Caution against fraudulent job offers!

We have been informed of instances where jobseekers are led to believe of fictitious job opportunities with Deloitte US (“Deloitte”). In one or more such cases, false promises of actual or potential selection, or initiation or completion of the recruitment formalities appear to have been or are being made. Some jobseekers appear to have been asked to pay money to specified bank accounts of individuals or entities as a condition of their selection for a ‘job’ with Deloitte. These individuals or entities are in no way connected with Deloitte and do not represent or otherwise act on behalf of Deloitte.

We would like to clarify that:

  • At Deloitte, ethics and integrity are fundamental and not negotiable.
  • We are against corruption and neither offer bribes nor accept them, nor induce or permit any other party to make or receive bribes on our behalf.
  • We have not authorized any party or person to collect any money from jobseekers in any form whatsoever for promises of getting jobs in Deloitte.
  • We consider candidates on merit and that we provide an equal opportunity to eligible applicants.
  • No one other than designated Deloitte personnel (e.g., a Deloitte recruiter or Deloitte hiring partner) is permitted to extend any job offer from Deloitte.

Anyone who at any time has made or makes any payment to any party in exchange for promises of job or selection for a job with Deloitte or any matter related to this (including those for ‘registration’, ‘verification’ or ‘security deposit’) or otherwise engages with any such person who has made or makes fraudulent promises or offers, does so (or has done so) entirely at their own risk. Deloitte takes no responsibility or liability for any such unauthorized or fraudulent actions or engagements. We encourage jobseekers to exercise caution.