Audit Data Analyst

JOB SUMMARY

We are looking for an experienced auditor that has data analytics, controls testing and reporting experience to support the Internal Audit Department. Under direction this person will perform complex, highly technical and advanced financial, statistical and management analyses used to drive operational improvements and efficiency around the audit process. A secondary role is to perform annual IT General Control (ITGC) testing in accordance with our J-SOX compliance requirements.In summary, this position requires a blend of technical expertise (both data analytics and internal audit/compliance related experience), solid communication skills, ability to work independently and strong reporting abilities.

Essential Functions

• Bachelor's degree in Statistics, Accounting, Data Analytics or a related field.
• 5 years’ experience in internal audit, compliance or a related field.
• 3 years’ experience in data analysis, business intelligence, etc.
• 3 years’ experience with Power BI or other data visualization tools.
• Experience testing business process controls.
• Working knowledge and experience with ITGC testing.
• Working knowledge and experience with SOX and/or J-SOX compliance.
• Advanced skills with data analysis tools and programming languages (e.g., SQL, ACL/Diligent) including Excel.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication, reporting and presentation abilities.
• Ability to work independently in a fast-paced environment.
• Available for up to 25% domestic overnight travel.

Required for All Jobs

•Performs other duties as assigned

• Complies with all policies and standards

QUALIFICATIONS

Work Experience

1-3 years

Working knowledge and experience with ITGC testing.

Working knowledge and experience with SOX and/or J-SOX compliance.

3-5 years

3 years’ experience in data analysis, business intelligence, etc.

3 years’ experience with Power BI or other data visualization tools.

Advanced skills with data analysis tools and programming languages (e.g., SQL, ACL/Diligent) including Excel.

5 years’ experience in internal audit, compliance or a related field.

Knowledge, Skills and Abilities

• Executes data analysis procedures using Audit Command Language (ACL), Excel, or other data analysis software, including script writing.
• Works on complex data analysis programs to increase the efficiency and scope of audit procedures.
• Works closely with audit managers on audit projects to identify, acquire, and organize data relevant to the audit scope and objectives.
• Works closely with audit team members to collect information about data analysis needs and approaches; applies analytical techniques such as data visualization, benchmarking, and hypothesis testing to increase the use and sophistication of analytical techniques.
• Maintains technical skills such as data acquisition, data file formats and structures, transporting data, merging files, and data manipulation/management.
• Provides training and support for data analysis techniques to audit personnel as necessary.
• Lead retail audits using a predefined detailed audit program to assess and review financial and operational controls surrounding the operations and security over our 170 retail locations.
• Ability to lead audits verifying the accuracy of our perpetual inventory stock quantity records for material control and accounting at the retail level.
• Ability to participate in and/or lead ad-hoc operational audits and fraud investigations.
• Work with site staff and regional management to develop and agree on specific recommendations to help address noncompliance identified during the audits.
• Prepare written reports ensuring audit comments are factual, clear and concise.