Excel Data Analyst: Reporting & Automation Specialist

Milestone IT (Milestone Information Technology); Melbourne; On-site; AUD 70,000 - 90,000; Full time

Job summary

Milestone IT (Milestone Information Technology) is seeking a Data Support Analyst with strong Excel expertise to manage and analyze data, enabling informed decision-making across teams. You will develop Excel-based tools, validate data integrity, and generate reports and dashboards, translating complex insights into actionable recommendations for stakeholders in a fast-paced environment.

The role emphasizes accuracy, automation opportunities, cross-functional collaboration, and mentoring

Qualifications

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, or related field.
• 1+ year experience as Data Support Analyst using Excel for data analysis and reporting.
• Proficient in Excel functions and formulas for large datasets.
• Ability to work independently and collaboratively in a fast-paced environment.

Responsibilities

• Utilize advanced Excel functions (such as VLOOKUP, INDEX/MATCH, PivotTables, Macros, etc.) to manipulate and analyze large datasets.
• Develop and maintain Excel-based tools and templates for data collection, validation, and reporting purposes.
• Cleanse and validate data to ensure accuracy, completeness, and integrity.
• Generate reports and dashboards that provide meaningful insights and visualizations to support business decisions.
• Collaborate with cross-functional teams to understand data requirements and provide technical support.
• Identify opportunities for process improvements and automation to enhance efficiency in data handling and reporting.
• Train and mentor team members on Excel best practices and data analysis techniques.

Skills

Excel

Data analysis

Reporting

Visualization

Attention to detail

Communication

Education

Bachelor’s degree in Data Analytics, Information Systems, Computer Science

Tools

SQL

Python

Job description

Milestone IT (Milestone Information Technology) is seeking a Data Support Analyst with strong Excel expertise to manage and analyze data, enabling informed decision-making across teams. You will develop Excel-based tools, validate data integrity, and generate reports and dashboards, translating complex insights into actionable recommendations for stakeholders in a fast-paced environment.

The role emphasizes accuracy, automation opportunities, cross-functional collaboration, and mentoring