GRADUATE DATA ANALYST

Josh's Rainbow Eggs; Shire of Macedon Ranges; On-site; AUD 60,000 - 75,000; Full time

Job summary

Josh's Rainbow Eggs is seeking a Graduate Data Analyst to support reporting, data collection and systems capability for the business. You will help ensure data is captured accurately and on time, maintain dashboards and databases, and report insights to support performance and growth.

This development role offers structured training and mentorship to grow into full ownership, with exposure to SQL, Python and AWS QuickSight as you progress.

Qualifications

• Tertiary qualification in data science, statistics, computer science, information systems, mathematics, engineering or commerce, completed within the last two years.
• Working knowledge of SQL, ideally MySQL, including writing queries, joins and filtering.
• Working knowledge of Python, including data handling with libraries such as pandas.
• Good understanding of Excel, including VLOOKUP, INDEX and pivot tables.

Responsibilities

• Support and maintain the ThingsBoard data collection platform — form creation and modification, calculated fields and user access.
• Maintain databases across Excel, SQL and AWS to uphold data integrity standards.
• Run and monitor automated data loads from retail partners, and investigate any discrepancies.
• Maintain and develop daily and weekly dashboards in AWS QuickSight for business owners and department managers.

Skills

SQL (MySQL)

Python (pandas)

Excel (VLOOKUP, pivot)

Analytical mindset

Independent work

Strong communication

Right to work in Australia

Education

Tertiary qualification in data science / statistics / CS / IS / maths / eng / commerce (within last 2 years)

Tools

Amazon QuickSight

SQL tooling

Job description

The Graduate Data Analyst supports and progressively takes ownership of the reporting, data collection and systems capability of the business. They ensure data is captured accurately and on time, maintain the dashboards and databases the business relies on, and interpret the figures to report insights that support business performance and identify areas for growth and change.

This is a development position. The successful candidate will receive structured training and support to grow into full ownership of the role.

POSITION OBJECTIVE

The Graduate Data Analyst supports and progressively takes ownership of the reporting, data collection and systems capability of the business. They ensure data is captured accurately and on time, maintain the dashboards and databases the business relies on, and interpret the figures to report insights that support business performance and identify areas for growth and change.

This is a development position. The successful candidate will receive structured training and support to grow into full ownership of the role.

RESPONSIBILITIES

Data Collection & Systems

• Support and maintain the ThingsBoard data collection platform — form creation and modification, calculated fields and user access.
• Support the farm automation and monitoring systems, including Node-RED control flows and Victron VRM solar and battery monitoring.
• Maintain databases across Excel, SQL and Amazon Web Services to uphold data integrity standards.
• Run and monitor automated data loads from retail partners, and investigate any discrepancies.
• Carry out regular audits and validation to ensure the accuracy and reliability of data.
  

Reporting & Analysis

• Maintain and develop daily and weekly dashboards in AWS QuickSight for business owners and department managers.
• Compile accurate department figures weekly into the Scorecard Meeting spreadsheet for the leadership team.
• Report to the leadership team on performance, fluctuations and growth, with recommendations for improvement or change.
• Use MS Office, particularly Excel, including complex nested formulas and functions, to derive key metrics.
• Directly update sales and related data covering delivery, grading and farm team activities.
  

Systems & IT Support

• Support Google Workspace users, groups and access, and email security and filtering.
• Manage the company mobile phone and SIM card fleet.
• Maintain software licences and subscriptions for data and IT tools.
• Provide day-to-day IT support to office and farm teams.
• Document systems, processes and procedures so business knowledge is retained.

TRAINING & DEVELOPMENT

• Structured induction across the farm, packing, delivery and office teams.
• Regular one-on-one support from the reporting manager.
• Access to external technical support for mentoring and escalation.
• Training budget to build technical skills.
  

PERSONAL ATTRIBUTES

• Able to demonstrate the core values and behaviours of the business.
• Analytical mind and passionate about numbers.
• Willing to ask questions and seek help when unsure.
• Curious about the wider business, including the farm and packing operations.
• Ability to meet deadlines and prioritise tasks.
• Adaptable to ongoing change.
• Detail oriented and task focused.
  

SKILLS & QUALIFICATIONS REQUIRED

• Tertiary qualification in data science, statistics, computer science, information systems, mathematics, engineering or commerce, completed within the last two years.
• Working knowledge of SQL, ideally MySQL, including writing queries, joins and filtering.
• Working knowledge of Python, including data handling with libraries such as pandas.
• Good understanding of Excel, including VLOOKUP, INDEX and pivot tables.
• Excellent written and verbal communication skills.
• Ability to work independently and as part of a team.
• Current driver's licence.
• Right to work in Australia.

Desirable: exposure to dashboard tools such as Amazon QuickSight; exposure to any cloud platform; exposure to IoT or sensor data; exposure to JavaScript or HTML.