Data Analyst

Ambition Group; Sydney; On-site; AUD 90,000 - 130,000; Full time

Job summary

Ambition Group is seeking a Data Analyst in Sydney to own how the business captures and reports data end-to-end. You will design data capture, storage and reporting, and build the Power BI suite from the ground up.

You’ll work with an in-house ERP developer to translate operational and financial data into dashboards for senior leadership, alternating between FP&A tasks and automation to deliver a scalable data solution.

Qualifications

• Strong SQL skills (SQL Server Management Studio) and ability to write your own DAX.
• Experience building Power BI dashboards and reporting models from scratch.
• Working knowledge of Power Platform (Power Automate) and PowerShell scripting.
• API experience (REST/GraphQL) and understanding of data gateways.
• Comfort with large datasets, ideally from FMCG or large organisations.
• It’s beneficial to have FP&A, financial analysis or commercial finance exposure.
• Strong commercial acumen and ability to translate complex data for non-finance stakeholders.

Responsibilities

• Own the transition to a single source of truth, designing data capture, storage and reporting.
• Design and build the Power BI reporting suite from the ground up.
• Collaborate with an in-house software developer on ERP integration.
• Translate operational and financial data into dashboards for senior leadership.
• Move between BAU FP&A and technical automation with end-to-end ownership.

Skills

SQL

Power BI

Power Platform

PowerShell

APIs

Large datasets

FP&A exposure

Job description

Data Analyst

Sydney (in-office)

Salary + super

Scale-up business - expanding in the next 12 months

You've spent your career in data - SQL, Power BI, APIs, automation. Somewhere along the way, you probably picked up some finance related responsibilites - forecasting, reporting cycles, budget cycles - but that's never been the job. The job has been fixing what's broken, building what's missing, and making the numbers usable.

In most roles, that's exactly where it stops. You build the dashboard, automate the report, and it gets absorbed into someone else's BAU. Nobody hands you the mandate to actually own how the business captures and reports on its data end to end.

This role changes that.

About the business:

We are exclusively partnered with a fast-scaling company undergoing a major capital expansion. As volume scales over the next 12 months, the business needs financial and commercial decision support that's backed by data systems robust enough to scale with it. This isn't a role for someone who wants a settled, steady-state environment.

What your new role looks like:

Reporting directly to the CFO, you'll take full ownership of the organisation's transition to a single source of truth, designing how data is captured, stored and reported across the business, and building the Power BI reporting suite from the ground up. You'll work closely with an in-house software developer building the company's ERP, translating operational and financial data into dashboards and reports that senior leadership can use.

This isn't a role where you're handed a fixed remit and told to stay in your lane. You'll move fluidly between BAU FP&A (forecasting, EOW/EOM reporting, commercial analysis) and the more technical, exploratory work of automating it all away - with real ownership over how the future state of reporting looks.

What's different about this role:

This role gives you commercial exposure at CFO level while keeping you hands-on with the systems and data underneath it, with genuine license to experiment, automate and reshape how the business reports on itself.

About you:

• Strong SQL skills (SQL Server Management Studio) and confidence writing your own DAX
• Experience building Power BI dashboards and reporting models from scratch
• Working knowledge of Power Platform (Power Automate) and PowerShell scripting
• API experience (REST/GraphQL) and an understanding of how data gateways work
• Comfort working with large datasets - ideally from an FMCG or large organisation background
• It is beneficial to have had experience in an FP&A, financial analysis or commercial finance role
• Strong commercial acumen and the confidence to translate complex data for non-finance stakeholders

Ready for a role where you build the system, not just work around it?