Data Analyst- Audit

CORE RESPONSIBILITIES AND TASKS

Located within the Audit and Loss Prevention Department, the Data Analyst, Audit will work both independently and closely with the Field Audit, Corporate Audit and Loss Prevention teams to assist in the evolution and execution of the data analytics audit program. Data Analyst, Audit will be responsible for the following: 

1. Assist on the completion and execution of audit and loss prevention procedures using data analytic tools.
2. Report findings to appropriate personnel and working with management to provide value-added guidance.
3. Assist on development of visualizations using Tableau, Dataiku, and / or TableauPrep to assist with efficient and effective audit testing and support of continuous auditing and monitoring initiatives.
4. Gain an understanding of all key data points and audit objectives to identify opportunities to assist the Department.
5. Assist the team lead on assessing and challenging the data analytics program and existing scripts/queries to help improve efficiencies, completeness, and accuracy of testing. 
6. Assist in the completion of special projects using data analytics tools. 

POSITION REQUIREMENTS 

FORMAL EDUCATION: 
 

Required:

• Bachelor's degree in Accounting, Finance, Data Analytics, Management Information Systems, Technology or a related Technology field from an accredited institution  

Preferred:

• Professional certifications such as CFE, CISA, and CIA

KNOWLEDGE & EXPERIENCE:

Required:

• 1-3 years of auditing and/or data analytics experience 
• Detail-oriented, organized, and possess strong data analytic and communication skills
• Proficient user of Microsoft Office (Excel, Word, PowerPoint)
• Work independently under minimal supervision and as part of a team 
• Self-motivated and possess a continuous improvement mindset 
• 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. 

Preferred:

• Strong data analytic skills and experience with extracting, understanding, formatting, mapping, and cleansing data for use in visualization tools (Tableau) or data preparation tools (Dataiku, TableauPrep, Alteryx) 
• Experience with common data analysis and data mining techniques
• Experience with reporting and data analytic tools such as Tableau, Power BI, Alteryx, TableauPrep, Dataiku, SQL Server, Toad, Business Objects, OBIEE.
• Experience with development and understanding of SQL queries that can be utilized as part of continuous auditing and monitoring initiatives 
• Experience with writing SQL queries to pull data from relational databases (e.g. Snowflake, PostgreSQL, Oracle).
• General understanding of IT process, business processes, and data flows to help identify key risks and opportunities to implement the use of data analytic procedures. 
• Familiarity of audit related data points and their relevance to a specific task

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, Alteryx or Tableau Prep to manipulate and analyze data.

TRAVEL REQUIREMENTS:

• 10%

Here, we believe there’s not one path to success, we believe in careers that grow with you. Whoever you are or wherever you come from in the world, there’s a place for you at Sherwin-Williams. We provide you with the opportunity to explore your curiosity and drive us forward. Sherwin-Williams values the unique talents and abilities from all backgrounds and characteristics. All qualified individuals are encouraged to apply, including individuals with disabilities and Protected Veterans. We’ll give you the space to share your strengths and we want you show us what you can do. You can innovate, grow and discover in a place where you can thrive and Let Your Colors Show!  At Sherwin-Williams, part of our mission is to help our employees and their families live healthier, save smarter and feel better. This starts with a wide range of world-class benefits designed for you. From retirement to health care, from total well-being to your daily commute—it matters to us. A general description of benefits offered can be found at http://www.myswbenefits.com/. Click on “Candidates” to view benefit offerings that you may be eligible for if you are hired as a Sherw