Data Science / Analytics Intern, Corporate Audit

Key Skills

Microsoft-Excel, Python Programming, SQL, PowerBI, Tableau, SAS

Job Description

Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom’s of Maine, Sanex, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet, Hill’s Prescription Diet and Hill’s Ideal Balance.

For more information about Colgate’s global business, visit the Company’s web site at http://www.colgatepalmolive.com. To learn more about Colgate Bright Smiles, Bright Futures® oral health education program, please visit http://www.colgatebsbf.com. To learn more about Hill's and the Hill’s Food, Shelter & Love program please visit hillspet.com. To learn more about Tom’s of Maine please visit http://www.tomsofmaine.com

Function Description

The Corporate Audit Department (“CAD”) is an integral part of the control and governance framework of the Organization.

CAD is an independent, objective assurance function that employs a systematic, risk-based approach to the review and evaluation of the adequacy, effectiveness, and sustainability of risk management procedures, internal control systems, information systems, and governance systems and processes.

Corporate Audit Objectives

We aspire to transform the Corporate Audit function so it can be aligned to the key risks and strategies of our organization. Harnessing the ongoing wealth of available data, the Audit analytics team embeds analytics into every phase of the audit process and enables insights-driven auditing by generating valuable new insights for the risk assessment, building flexibility in the audit plan, providing greater assurance, and reengineering the operating model to allow agile audit today and well into the future.

Assignment Description

The position of Data Scientist Intern contributes to the execution, monitoring, and evaluation of the data analytics audit strategy and is responsible for generating insights to protect the organization from internal and external risks through the identification of risky human behavior, process design and control deficiency. The successful candidate will be an Analytics evangelist bringing their innovation, critical thinking, influence, industry and functional expertise while leveraging advanced analytics to drive successful audits.

This role will actively drive the integration of data analytics and associated data visualizations into internal audit projects to deliver innovative, insightful, and actionable analyses. Your role is to help auditors turn insight into foresight by leveraging emerging technology, data enabled/driven methodologies and innovation to deliver results with more accuracy, efficiency and value.

Data scientist interns need to be knowledgeable and be able to deploy techniques such as correlation tests, hypothesis tests, machine learning, cluster analysis, data mining and visualization to automate processing raw data into valuable insights. They need to demonstrate understanding of IT/business processes, data pipelines, operational risk management, and related regulatory and compliance standards.

Responsibilities:

• Develop automated analytical scripts, tests and analytical reports using SQL based query, SAS or Python and/or data visualization tools such as Tableau.
• Provide data analytics support for various audits performed throughout the assignment, including requirements brainstorming, data acquisition, data management, iterative analysis design and analytics, and data visualization (where appropriate) for various audit engagements.
• Develop dashboards and related reports to create more compelling visuals that highlight impactful insights which are easier to consume for key stakeholders.
• Identify, understand and acquire large underlying information/data to meet objectives.
• Perform large-scale data mining and data science projects as well as ad hoc statistical and data mining analyses.
• Summarize results to present anomalies, error rates and dollar impact from anomalies / exceptions.
• Present results of analyses to business auditor teams, explain technical and statistical concepts to non- technical/non-statistical associates and vice-versa.

Qualifications

• Currently pursuing a BSc./MSc. degree in Data Science, Management Information Systems, Computer Science, Engineering, Statistics, Mathematics, or related study
• Strong programming capability; ability to solve problems through programming and simulation.
• Demonstrated working knowledge of tools for data analysis, such as Python or SAS and business intelligence products such as Tableau.
• Demonstrated experience with SQL and knowledge of data extraction and manipulation.
• Ability to work with multiple sources of disparate data.
• Strong analytical background with attention to details to deliver quality results.
• Ability to conceptualize and execute analytical work based on broad business objectives.
• A passion for detail, accuracy, reliability and speed coupled with desire for data exploration to reveal deeper insights, business process improvement opportunities and areas of potential risk
• Ability to analyze large, complex data sets in order to identify common themes and solutions
• Inquisitive nature, resourceful, and an ability to seek out information
• Understanding of data reconciliation requirements, including the identification, evaluation, and resolution of data anomalies
• Technical aptitude with strong logical, problem solving and decision-making skills. 
• Strong written and verbal English communication skills.
• Ability to present complex information in an understandable and compelling manner.
• Strong communication skills and ability to thrive in a fast paced, multiple-deliverable, team-oriented environment.
• Ability to demonstrate understanding of data governance concepts

Preferred Skills & Experience

• Competent in SAS, Python, R, Tableau or any other programming experience
• Proficiency in statistical data analysis or modeling languages (SAS, R, Python, Spark, etc.)
• Experience using data visualization tools (Excel, SAS Visual Analytics, Tableau, PowerBI, Qlik, etc.)
• CISA (Certified Information Systems Auditor), CDMP (Certified Data Management Professional) certifications or interest in obtaining a certification in one of these disciplines