Data Architect — End-to-End BI & FP&A Automation

Ambition; Sydney; Hybrid; AUD 140,000 - 170,000; Full time

Job summary

Ambition in Sydney (in-office) is seeking a data analytics leader to own the end-to-end data reporting stack. You will design and implement how data is captured, stored and reported, building the Power BI suite from the ground up and integrating with the ERP development project.

You’ll bridge FP&A and technical work, automating processes and delivering dashboards for CFO-level decision support as the business scales over the next 12 months.

Qualifications

• Strong SQL skills (SSMS) and ability to write DAX expressions.
• Experience building Power BI dashboards and reporting models from scratch.
• Working knowledge of Power Platform and PowerShell scripting.

Responsibilities

• Own the transition to a single source of truth for data across the business.
• Design how data is captured, stored and reported; build the Power BI reporting suite from the ground up.
• Collaborate with an in-house ERP development team to translate operational and financial data into dashboards for senior leaders.
• Shift between FP&A activities (forecasting, reporting cycles) and technical automation work to scale reporting.
• Provide data-driven insights to support commercial decision-making at senior levels.

Skills

SQL

Power BI

DAX

Power Platform

API integration

Tools

Power Automate

PowerShell

REST/GraphQL

Job description

Ambition in Sydney (in-office) is seeking a data analytics leader to own the end-to-end data reporting stack. You will design and implement how data is captured, stored and reported, building the Power BI suite from the ground up and integrating with the ERP development project.

You’ll bridge FP&A and technical work, automating processes and delivering dashboards for CFO-level decision support as the business scales over the next 12 months.