FP&A Analyst
Ambition Group
Job Description
FP&A & Data Analyst
Sydney (in-office)
Salary + super
Scale-up business - expanding in the next 12 months
You\'ve built strong finance foundations - FP&A, reporting, forecasting. And somewhere along the way, the manual reporting grind pushed you into SQL, Power BI, APIs, or automation - not because it was your job title, but because you got tired of fixing the same broken report every month.
But in most roles, that\'s where it stops. You build the workaround, automate the one process, and then you\'re back to BAU. The systems stay fragmented. Nobody gives you the permission to actually rebuild how the business captures and reports on its data.
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:
Most FP&A roles either keep you close to the numbers or move you into a purely technical function and is rarely both. 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:
You have:
- 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
- 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?
#J-18808-Ljbffr