Assistant Finance & Power BI Analyst

Trafalgar Wharf Limited; Cumberland; On-site; AUD 75,000 - 110,000; Full time

Job summary

Trafalgar in New South Wales seeks an Assistant Finance / Power BI Analyst to join the Finance team, blending accounting fundamentals with Power BI dashboards, Dynamics 365 Business Central, and robust financial reporting to drive business decisions.

You will develop dashboards, support month-end close, and help improve financial processes across the organisation, requiring strong Excel skills, analytical thinking, and stakeholder collaboration.

Responsibilities

• Act as a key user of Microsoft Dynamics 365 Business Central and support system improvements and user training.
• Create, maintain, and enhance Power BI dashboards and reports based on business requirements.
• Assist with month-end and year-end close processes, including journals, accruals, prepayments, and reconciliations.
• Support preparation of management accounts, financial reports, and variance analysis.
• Maintain the integrity of the general ledger and balance sheet reconciliations.
• Support day-to-day accounting operations across the business.
• Provide backup support for payroll processing and payroll reconciliations.
• Analyse business performance data and provide actionable insights to stakeholders.
• Identify opportunities to improve processes, controls, and reporting efficiency.

Job description

We are seeking a motivated and detail-oriented Assistant Finance / Power Bi Analyst to join our Finance team. The successful candidate will combine strong accounting knowledge with proven expertise in Microsoft Dynamics 365 Business Central and Power BI, playing a key role in financial reporting, systems optimisation, dashboard development, and business process improvement.

Reporting to the Finance Manager, this role will support the delivery of accurate and timely financial information while actively contributing to the continuous improvement of finance systems and reporting capabilities across the business.

This is an excellent opportunity for an accounting professional who enjoys combining traditional finance responsibilities with data analytics, business intelligence, and systems improvement initiatives.

Responsibilities

Act as a key user of Microsoft Dynamics 365 Business Central and support system improvements and user training.

Create, maintain, and enhance Power BI dashboards and reports based on business requirements.

Assist with month-end and year-end close processes, including journals, accruals, prepayments, and reconciliations.

Support preparation of management accounts, financial reports, and variance analysis.

Maintain the integrity of the general ledger and balance sheet reconciliations.

Support day-to-day accounting operations across the business.

Provide backup support for payroll processing and payroll reconciliations.

Analyse business performance data and provide actionable insights to stakeholders.

Identify opportunities to improve processes, controls, and reporting efficiency.

Who are you?

Bachelor degree in Accounting, or Finance.

Actively working towards CPA/CA qualification with minimum of 2-3 years’ experience in commercial accounting environment.

Proven experience with Microsoft Dynamics 365 Business Central.

Proven experience with Power BI, including dashboard development, data modelling, and reporting.

Strong understanding of financial reporting, month-end processes, and accounting principles.

Advanced Microsoft Excel skills.

Strong analytical, communication, and stakeholder management skills.

Ability to manage multiple priorities and meet deadlines

Enthusiastic team player with a proactive and positive attitude.

Who we are?

Trafalgar is a proud Australian manufacturer and distributor of specialty fire and access products throughout Australia and New Zealand. With manufacturing facilities in South Granville, NSW, Trafalgar are known for Australian Made quality, innovative designs, and a wide range of products that meet and exceed all relevant standards.

The Trafalgar head office and manufacturing facilities are both located in South Granville in western Sydney, and offices and warehouses in Brisbane QLD and Mitcham VIC and Perth, WA