Forecast and Planning Analyst - CFCs - Hawthorn East

We've been trusted to serve Aussie communities since 1914 and grown to become a top 30-listed on the ASX with 120,000 team members and a portfolio of iconic brands. At Coles Group, you'll not only get to make a difference to millions of Aussie lives—you'll also get to see your impact.

About the team

Technology is the backbone of our business. Every day, our teams solve complex problems, the solutions help thousands of our fellow team members succeed and makes millions of customers’ lives easier.

About the role

A new, permanent opportunity of a Forecast and Planning Analyst for a is now available at the Coles Group.  

The main objective of this position will include:

• analyse historical sales data,
• trends,
• seasonality, and
• market conditions to develop accurate sales and order forecasts at annual, quarterly, weekly and daily levels
• evaluate and refine forecasting models using statistical methods and predictive analytics.
• monitor forecast accuracy and adjust projections based on changing business or market conditions

Key responsibilities will include

Sales forecasting for CFCs

• Analyse historical sales data, trends, seasonality, and market conditions to develop accurate sales and order forecasts at annual, quarterly, weekly and daily levels.
•  Evaluate and refine forecasting models using statistical methods and predictive analytics.  
• Monitor forecast accuracy and adjust projections based on changing business or market conditions.
• Collaborate with CFC growth, finance, planning, ONG, Ops to align forecasts with business strategies.

Data analysis to support CFC sales Growth

• Prepare regular and ad hoc reports on sales performance, variances, and trends for leadership review.
• Develop and manage forecasting systems and models for consistency and accuracy.
• Conduct "what-if" scenario analyses to assess the impact of potential business changes.
• Liaise with team members within finance to obtain, understand and/or validate information to support decision making.
• Accurate and timely delivery of data analysis, extraction and manipulation in support the development of new market segments for the direct business
• Analytical insight to deliver inputs into strategic

Self – Leadership (no direct reports)

• Accountable for individual compliance with company values, policies and procedures (including Coles Code of Conduct) and all applicable external laws and regulations.

About you & your skills

• Bachelor’s Degree in Business Administration, Finance, Statistics, or related field (Master’s degree, preferred).
•  4+ years of experience in sales forecasting or a related analytical role.  
• Familiarity with statistical modelling techniques and forecasting software.
• Previous experience preparing annual, quarterly and weekly sales forecasts within a large / complex multi-division organisation
• Creation and management of comprehensive, complex and structured financial models.
• Demonstrated experience in a planning environment including driving process improvement
• Previous exposure to Retail or FMCG environments

Commercial Skills and Formal Qualifications

• Advanced analytical and financial modelling skills. Proficient user of Excel pivot tables, vlookups, macros, nested functions.
• Proficient in scripting in SQL and Python/R using snowflake for data extraction and model building
• Sound knowledge of data visualisation technique and building reports in Power BI
• Apply state of the art machine learning techniques to resolve analytical problems • Campaign Targeting and Analysis
• Data Analysis, data extraction and transformation  
• Demonstrated commercial acumen, with exposure to delivering successful outcomes in commercial environments
• Strong understanding of commercial drivers and business strategy development  
• Presentation of complex financial information to all levels of the organisation
• Strong stakeholder management, influencing skills and storytelling ability
• Excellent communication skills to be able to explain complex concepts to both technical and non-technical audiences
• Capable of working collaboratively with teams and leaders across Digital

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 hot deals 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.

Take your next step into something bigger, apply now!

With us it’s not about the discounts (although you do get those), it’s about joining a team where your wellbeing and professional development is invested in and celebrating your contributions is the norm. And because everyone leads unique lives, we offer flexible work including work from home, additional leave, and parental leave entitlements.

We’re continuing to build a gender equitable team, and a culture that’s just as diverse, inclusive, and welcoming as the communities we serve. 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: 152025 

Employment Type: Full time