Last Mile Analyst - Hawthorn East at Coles Group

Hawthorn East, Victoria, Australia -

Full Time

Start Date

Immediate

Expiry Date

15 Mar, 26

Salary

0.0

Posted On

15 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Analysis, Python, SQL, Excel, Power BI, Tableau, Logistics, Transportation Planning, Data Science, Business Intelligence, Dashboarding, Advanced Analytics, Stakeholder Engagement, Reporting, Data Quality, Experiment Design

Industry

Retail

Description

We’ve been proudly serving Australian communities since 1914 and have grown to become a top 30-listed company on the ASX with a portfolio of iconic homegrown brands. At the heart of our continued success is over 115,000 team members working across the country, all contributing to bringing our customers smiles. You’ll not only get to see your work make a difference, you’ll be part of a team working together to help Australians eat and live better every day. About the team As the way we shop continues to evolve, our Digital team keeps us at the cutting edge. Driven by our innovative, inclusive, and forward-thinking culture, we’re constantly looking at ways to create differentiated, omni-channel experiences for our customers and build the next generation of digital retailing.About the role This role is a key part of a major logistics transformation program. Coles is rebuilding last-mile planning and execution systems, as part of building a best in market grocery delivery capability. This role will work with vendors and technologies not otherwise in use elsewhere in Australia. Key Responsibilities Manage and analyse large transportation datasets from planning and execution systems, including fleet time and activity tracking. Apply data science or similar advanced analytics techniques to transform and manipulate these datasets into accurate performance metrics and dashboards. Use data insights to identify, quantify, and prioritize opportunities for improving delivery performance and reducing cost-to-serve. Ability to work with large datasets using Python (or similar) mandatory. Key Experience Required 5+ years of experience in similar roles below working for complex organisations, preferably retail, FMCG or supply chain -Logistics analyst / fulfilment analyst -Operations research analyst -Business intelligence / data analyst (logistics) -Transportation planning analyst Built automated reporting ideally across Last Mile; ie TMS/WMS, e-commerce, carrier APIs and telematics, delivering reliable dashboards (cost per order, on-time delivery, route density etc). Developed business cases for new features, including ROI/NPV, payback, assumptions and benefit tracking. Identified and prioritised savings opportunities in channel mix, delivery density, failed deliveries, and depot/driver utilisation with quantified impact. Partnered with stakeholders (e.g. Operations, Product, Finance and Technology) to translate insights into actions; led concise readouts and decision forums. Improved data quality by reconciling sources, defining metric semantics, implementing tests/alerts and maintaining Privacy controls. Working knowledge of Python for analysis and light data modelling; Git basics; exposure to dbt/Airflow. Advanced SQL and Excel; proven dashboarding in Power BI /Tableau on large, complex datasets. Understanding of last-mile logistics, TMS/WMS planning systems, carrier performance metrics and telematics data. Experience using time-series (i.e. vehicle activity over time) Advanced modelling skills: unit economics, driver trees, ROI/NPV, payback, scenario and sensitivity analysis. Experiment design and evaluation Advanced Powerpoint skills; ability to build narrative around data through slides Degree in Commerce, Economics, Business/Data Analytics or similar; desirable certifications (e.g., Power BI, SQL) and commitment to ongoing upskilling. What’s in it for you? Flexible working options: We know that work is only one part of your life, so we actively encourage a positive work-life balance and provide hybrid working options to help you achieve it. Office perks: Take advantage of our gym facility and fitness classes, free parking, BBQ area, mini-Coles supermarket, fooderie hub where you can sample new products before they hit the shelves, school holiday program and so much more when you come in. Discounts: Eligible team members receive 5% discount all year round on your Supermarket and Liquor online and in-store purchases. We also offer additional periods of double discount (10%) at various times throughout the year. As well as hotdeals exclusive to team members that translate into additional savings. Reward through recognition: Give and receive recognition, linked to our Coles values, through our digital recognition platform ‘mythanks’. You can accumulate points to redeem in the online shop for exciting gifts and electronic gift cards from an extensive range of retailers. Opportunities for learning and development: No matter where you start within our diverse business, you’ll have experiences, exposure, and education to satisfy you. Discover and explore a variety of career development programs and job-specific training. Paid parental leave: We understand how important your life outside work is and offer permanent team members paid parental leave to support you in balancing work and family. Investment in your future: Our annual team member share plan offer allows eligible team members to make regular pre-tax salary sacrifice deductions to purchase Coles Group shares. About the recruitment process We’re continuing to build a gender equitable team, and a culture that is just as diverse, inclusive and welcoming as the communities we serve. We are committed to creating a workplace that is safe and respectful for our team. We encourage applications from people of all ages, cultures (including Aboriginal and Torres Strait Islander peoples), abilities, sexual orientation and gender identities. We’re happy to adjust our recruitment process to support candidates with disability. For further information and additional contact details visit the ‘Our Recruitment Process’ section of our careers site or email inclusionrecruitment@coles.com.au Job ID: 174383 Employment Type: Full time #LI-OR1

Responsibilities

Manage and analyze large transportation datasets to improve delivery performance and reduce costs. Apply advanced analytics techniques to transform data into performance metrics and dashboards.