Data Analyst, Audit
Share
Job Location:
Cleveland, TN - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Located within the Audit and Loss Prevention Department theData Analyst Audit will work both independently and closely with the Corporate Audit team Field Audit team and Loss Prevention Department to assist in the continuous enhancement of the data analytics audit program.
This role is not hybrid/remote and will report into 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.
Responsibilities
CORE RESPONSIBILITIES AND TASKS
- Work with the Corporate Audit Field Audit and Loss Prevention teams 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 Corporate 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.
Qualifications
POSITION REQUIREMENTS
FORMAL EDUCATION:
Required:
- Bachelors degree in Accounting Finance Management Information Systems Technology Data Analytics or Technology field from an accredited institution
Preferred:
- Professional certifications such as CFE CISA and CIA
KNOWLEDGE & EXPERIENCE:
Required:
- 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.
- Detail-oriented organized and possess strong data analytic and communication skills
- Must be able to clearly report communicate and present on data analytic procedures utilized key issues identified business impact and recommendations for improvement to Senior Management.
- Self-motivated and possess a continuous improvement mindset
Preferred:
- Experience in using Alteryx Tableau Power BI Dataiku Snowflake SQL Server Toad Business Objects or other data analysis tools.
- Familiarity 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.
- Data analytic skills and experience with extracting understanding formatting mapping and cleansing data for use in data analytic procedures primarily from ERPs and reporting systems.
TECHNICAL/SKILL REQUIREMENTS:
Required:
- Has experience building or utilizing Tableau dashboards.
Preferred:
- 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.
Travel: 10%
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
At Sherwin-Williams, our purpose is to inspire and improve the world by coloring and protecting what matters. Our paints, coatings and innovative solutions make the places and spaces in our world brighter and stronger. Your skills, talent and passion make it possible to live this purp ... View more
