Commercial Data Analyst - Sydney, Australia - Hill's Pet Nutrition

Hill's Pet Nutrition

Verified Company

Sydney, Australia

2 weeks ago

Posted by:

Olivia Brown

beBee Recruiter

Description

Relocation Assistance Offered Within Country
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 nontechnical 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 welldocumented data models (dashboards) to drive clarity and efficiency for end users

Specifically:

Compile data from wholesalers, update and maintain exwholesalers 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