Audit Analytics Senior - Data Extraction Specialist

Profile

16,667
Job Information
Deloitte
Audit Analytics Senior - Data Extraction Specialist
in
Los Angeles
California
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. (****Qualifications
Required:
Bachelor’s or Master’s degree in engineering, computer science and/or management information systems
6-7 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).
Preferred:
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
How you’ll grow
At Deloitte, we believe in professional development and helping our people grow. We offer learning opportunities to help you sharpen your skills in addition to hands-on experience in the global, fast-changing business world. We support the development of leadership and technical skills through leading-edge learning development solutions such as our Audit on-boarding training program. When you join, you’ll participate in Welcome to Deloitte, a 2-day orientation followed by audit analytics-specific training to set you up for success on the team. Explore Deloitte University, The Leadership Center. (****Benefits
At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. (****Deloitte’s culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte. (****Corporate citizenship
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte’s impact on the world. (****Recruiter tips
We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you’re applying to. We also suggest that you brush up on your interviewing skills and practice discussing your experience and job history with a family member, friend, or mentor. Check out recruiting tips from Deloitte professionals. (****#IND:AUD #LI-AUD
Category: Accounting & Auditing
About Deloitte
As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see ****for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. 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.

Company info

Sign Up Now - SQLCrossing.com