Data & Reporting Analyst: Power BI & Excel Automation

Mars Partnership Pty. Ltd.

Melbourne

Hybrid

AUD 90,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work model

Job summary

MARS PARTNERSHIP PTY. LTD. in Melbourne is seeking a Data & Reporting Analyst to own, maintain and enhance core business reporting tools with a focus on Power BI and advanced Excel.

You’ll manage dashboards, oversee data inputs, and lead the development of an automated reporting solution, collaborating with regional and global stakeholders to improve automation and insight. You will support consolidations and deliver ad hoc analyses to identify performance trends and growth opportunities,

Qualifications

  • Experience in data analytics and reporting for retail/consumer sectors.
  • Strong knowledge of Power BI dashboards and Excel data modelling.
  • Experience delivering QA for data pipelines and working with cross-functional stakeholders.

Responsibilities

  • Own monthly Power BI reporting tool maintenance, refresh cycles and enhancements.
  • Oversee data inputs and QA across automated retailer data pipelines.
  • Lead design and ownership of a new automated Power BI dashboard with weekly/monthly refreshes.
  • Support regional/global reporting consolidations and ad hoc analyses to identify trends.
  • Deliver performance reporting to identify retailer opportunities and growth areas.
  • Utilise advanced Excel capabilities (Power Query, dynamic arrays, XLOOKUP, INDEX MATCH, VBA) to automate reporting and ensure data integrity.
  • Collaborate with analytics, commercial and technology teams to improve Power BI reporting quality.

Skills

Data analysis
Reporting
Stakeholder collaboration

Tools

Power BI
Excel
Power Query
Power Pivot
VBA

Job description

MARS PARTNERSHIP PTY. LTD. in Melbourne is seeking a Data & Reporting Analyst to own, maintain and enhance core business reporting tools with a focus on Power BI and advanced Excel.

You’ll manage dashboards, oversee data inputs, and lead the development of an automated reporting solution, collaborating with regional and global stakeholders to improve automation and insight. You will support consolidations and deliver ad hoc analyses to identify performance trends and growth opportunities,

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data & Reporting Analyst
Data & Reporting Analyst

Mars Partnership Pty. Ltd. • Melbourne

Hybrid
AUD 90,000 - 120,000
Hybrid work model
Data & Reporting Analyst — Power BI & SQL Insights
Data & Reporting Analyst — Power BI & SQL Insights

A098 Agl Energy Limited • Melbourne

Hybrid
AUD 90,000 - 120,000
Senior Data & Analytics Lead - Power BI & Insights
Senior Data & Analytics Lead - Power BI & Insights

Work Initiatives • Melbourne

On-site
AUD 120,000 - 160,000
Exclusive employee discounts via DBGHE
Acacia EAP wellbeing support
Leadership & development academies
Senior Data & Insights Lead — Power BI & Dashboards
Senior Data & Insights Lead — Power BI & Dashboards

DBG Health Pty • Melbourne

On-site
AUD 140,000 - 190,000
Employee discounts
Wellbeing support
Professional development
+3
Strategic Reporting Specialist Power BI Dashboards Flexible
Strategic Reporting Specialist Power BI Dashboards Flexible

BHP • Brisbane

On-site
AUD 90,000 - 120,000
Flexible working options
Performance-based bonuses
Employee share program
Finance Data Analyst – Power BI & Automation
Finance Data Analyst – Power BI & Automation

Vectec Pty Ltd • Sydney

On-site
AUD 90,000 - 130,000
Power BI & AI Analytics Reporting Specialist
Power BI & AI Analytics Reporting Specialist

Agl Energy Limited • Melbourne

On-site
AUD 90,000 - 130,000
Hybrid Power BI Reporting Analyst – KPI Dashboards
Hybrid Power BI Reporting Analyst – KPI Dashboards

JB Hi-Fi Limited • Victoria

Hybrid
AUD 90,000 - 120,000
Power BI Data & Strategy Analyst — Brisbane Contract
Power BI Data & Strategy Analyst — Brisbane Contract

Quality People Pty Ltd • Brisbane

On-site
AUD 100,000 - 145,000
Data & Insights Analyst — Power BI, SQL, Azure (Hybrid Melbourne)
Data & Insights Analyst — Power BI, SQL, Azure (Hybrid Melbourne)

Trulieve • Melbourne

Hybrid
AUD 115,000 - 125,000
Hybrid work
Flexible hybrid in Melbourne
Top locations