Commercial Data Analyst

Relocation Assistance Offered Within Country
147700 - Sydney, New South Wales, Australia

**About Hill’s**

We are Hill’s - an innovative growth company reimagining a healthier future for all people, their pets, and our planet. We are part of Colgate-Palmolive a leading global consumer products company with a portfolio in Oral Care, Personal Care, Home Care and Pet Nutrition.

At Hill's we have a purpose Every day around the world, we transform the lives of millions of pets through groundbreaking innovation, outstanding nutrition, and committed people.

Our strong culture of diversity, sustainability and inclusion is rooted in our core values of Caring, Global Collaboration and Continuous Improvement. Employees are rewarded by rich career development and experiences.

We pride ourselves on our work life balance, our focus on delivering high ethical standards and our dedication to developing our employees. With many local benefits such as Summer Hours, Live Better activities, Product Parcels and Health Checks.

We're looking for an experienced data and analytics professional to join our AU Analytics team.

As a Commercial Data Analyst, you will collaborate with departments across the company, including, global data and analytics teams, local Finance, Marketing & Sales teams. In addition to building data transformation pipelines, your responsibilities will include developing and updating existing dashboards for business use using tableau and transforming data using tableau prep builder. You will also be responsible for identifying and solving process automation opportunities.
- You are an expert in wrangling and managing raw data and combining data from different sources using tableau and tableau prep builder
- You have an eye for detail, you are a champion for data quality, transparency, and documentation
- You are able to clearly and dynamically translate information into impactful insights to technical and non-technical audiences
- You have curiosity to take ambiguous problems and tackle them to achieve hypothesis driven results
- You have the ability to balance multiple projects at once and deliver projects independently
- Experienced in process automation to simplify business processes
- You are a collaborator by nature

**Key Responsibilities**:
**1.Cleaning, Collating and running Tableau workflows /Dashboards (Monthly cadence)**
- Translate business requirements and logic into well-documented data models (dashboards) to drive clarity and efficiency for end users

Specifically:

- Compile data from wholesalers, update and maintain ex-wholesalers data mapping files, run tableau flows and update / publish relevant tableau dashboards
- Compile data from retailers, run the tableau flows and update / publish dashboards
- Collate data release forms and request missing data from Wholesalers and Customers

**2.Pro active data reporting and Insight generation**
- Collaborate cross functionally to understand and identify data needs and opportunities to use data to drive business solutions
- Provide Analytical support for the commercial team develop ad hoc tableau/Domo reports using sales data
- Support commercial team identifying business questions and generating insights from our sales data

**3.Project based analytics support**
- Support Global Data and Analytics with snowflake data ingestion and translation for the AU region
- Transition all monthly reporting across to Domo and lead local upskilling
- Partner with Global data and analytics teams on regional analytics initiatives eg providing inputs for MMM, Pricing analysis, customer lifetime value etc.
- Partner with Global data and analytics teams to align on data architecture, analytics tools, and other technologies for our region
- Stay connected with Global data and analytics teams to share best practices

**Required Qualifications**:

- Bachelor’s degree in business or a quantitative field
- Expert in using data visualization and/or BI tools (e.g. Domo, Tableau, Tableau Prep, Excel) to analyse data
- Demonstrated proficiency in the use of SQL and/or Python to wrangle, clean, and integrate data from a variety of sources highly regarded
- Demonstrated understanding of modern data warehouse design principles and data

**Preferred Qualifications**:

- Demonstrated understanding of marketing analytics concepts, including marketing mix modeling, churn risk prediction, and customer lifetime value
- Familiarity with SAP systems (ECC, C4C)

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.

Work that matters, fueled by passion for pets At Hill’s we have a purpose. Every day around the world, we transform the lives of millions of pet f