Data Analyst, Audit

Sherwin-Williams • Cleveland, OH

1d • Onsite

About The Position

Located within the Audit and Loss Prevention Department, the Data Analyst, Audit will work both independently and closely with the Field Audit Team to assist in the continuous enhancement of the data analytics audit program. This position is not hybrid/remote and will be located at our Global Headquarters in Cleveland, OH. Because this role involves access to confidential financial information, the Company has determined that a review of criminal history is necessary to protect the business and its operations and reputation and to provide similar protections for its clients and potential investments.

Requirements

• Bachelor’s degree in Accounting, Finance, Management Information Systems, Technology, or Data Analytics
• 1+ years of auditing and/or data analytic experience
• Experience with common data analysis and data mining techniques
• Understanding of internal control concepts and frameworks (COSO, COBIT) as well as other leading business and IT control security frameworks (ITIL, PCI).
• General understanding of IT processes, business processes, and data flows to help identify key risks and opportunities to implement the use of data analytic procedures.
• Experience building or utilizing Tableau dashboards.
• Must be legally authorized to work in the United States without sponsorship now or in the future for employment visa status
• Must be at least eighteen (18) years of age

Nice To Haves

• Professional certifications such as CFE, CISA, and CIA
• Experience in using Tableau, Dataiku, Snowflake, Toad, Business Objects, or other data analysis tools.
• Experience with other technical environments such as Unix, Linux, Windows, Oracle databases, SQL databases, Active Directory
• Experience with development and understanding of SQL queries that can be utilized as part of continuous auditing and monitoring initiatives.
• Experience with extracting, understanding, formatting, mapping, and cleansing data for use in data analytic procedures, primarily from ERP’s and reporting systems.
• Strong understanding of how to merge multiple datasets from Excel files, data warehouses, and via PostgreSQL.
• Strong understanding of how to use data science tools like Dataiku or Tableau Prep to manipulate and analyze data.

Responsibilities

• Work with the Field Audit Team on enhancing the data analytics program.
• Development of scripts and ad-hoc queries using company-provided data analytic tools to assist with efficient and effective audit testing and support of continuous auditing and monitoring initiatives
• Support the Field Audit Team from a data analytic and data mining standpoint for all compliance (including Sarbanes-Oxley), operational, consulting, and management requested audits.
• Work with the Field Audit Team to identify opportunities to improve efficiencies and identify ways to enhance the field audit program through change and continuous monitoring.
• Gain an understanding of all key systems, data, business processes, and audit objectives to identify opportunities to provide analytic services to assist the Internal Audit and Loss Prevention Department.
• Provide sustainable services by independently assessing and challenging the data analytic program and existing scripts/queries to help improve efficiencies, completeness, and accuracy of testing.
• Assist in the completion of special projects using data analytic tools.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level