Job DescriptionLocated within the Audit and Loss Prevention Department, the Data 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.
ResponsibilitiesCORE 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.
QualificationsPOSITION REQUIREMENTSFORMAL EDUCATION:
Required:
- Bachelor's 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 ERP's 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%
About UsAt 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 purpose, and for customers and our business to achieve great results. Sherwin-Williams is a place that takes its stability, growth and momentum and translates it to possibility for our people. Our people are behind the strength of our success, and we invest and support you in:
Life ... with rewards, benefits and the flexibility to enhance your health and well-being
Career ... with opportunities to learn, develop new skills and grow your contribution
Connection ... with an inclusive team and commitment to our own and broader communities
It's all here for you... let's Create Your
PossibleAt 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 Click on "Candidates" to view benefit offerings that you may be eligible for if you are hired as a Sherwin-Williams employee.
Compensation decisions are dependent on the facts and circumstances of each case and will impact where actual compensation may fall within the stated wage range. The wage range listed for this role takes into account the wide range of factors considered in making compensation decisions including skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The wage range, other compensation, and benefits information listed is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, with or without notice, subject to applicable law.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable federal, state, and local laws including with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act where applicable.
Sherwin-Williams is proud to be an Equal Employment Opportunity employer. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, marital status or any other consideration prohibited by law or by contract.
As a VEVRAA Federal Contractor, Sherwin-Williams requests state and local employment services delivery systems to provide priority referral of Protected Veterans.
Please be aware, Sherwin-Williams recruiting team members will never request a candidate to provide a payment, ask for financial information, or sensitive personal information like national identification numbers, date of birth, or bank account numbers during the application process.
Never miss an opportunity! Create an alert based on the job you applied for.
