Commercial Analyst: Workforce Forecasting & Insights

Bolton Clarke Residential Aged Care Opportunities; New South Wales; On-site; AUD 110,000 - 140,000; Full time

Benefits offered by this job

Salary packaging

Private health insurance

Gym discounts

Employee Assistance Program

Career progression opportunities

Job summary

Bolton Clarke is Australia’s largest not-for-profit aged care provider, seeking an experienced Commercial Analyst to drive workforce, financial and operational performance across 87 residential aged care homes. You will partner with leaders and transform data into actionable insights to inform decision-making.

Reporting to the Commercial Manager, you’ll contribute to budgeting, forecasting and governance, using advanced Excel and Power Query to analyse workforce and funding impacts.

Qualifications

• Commercial analysis, workforce analytics, financial analysis or business partnering roles.
• Labour forecasting, budgeting, workforce planning or operational performance reporting.
• Presenting insights and recommendations to operational leaders and senior stakeholders.
• Financial modelling, forecasting and business performance analysis.
• Advanced Excel skills including complex formulas, Power Query and large data set analysis.
• Experience in highly regulated environments such as aged care or healthcare.

Responsibilities

• Deliver labour forecasting, workforce reporting and commercial analysis across 87 residential aged care homes.
• Analyse workforce performance trends and provide recommendations to improve productivity and financial outcomes.
• Support annual budget and reforecast processes through workforce modelling and labour forecasting.
• Monitor labour performance against budgets and forecasts, identifying risks, variances and opportunities.
• Drive roster governance initiatives to improve compliance, workforce utilisation and cost management.
• Lead Direct Care Minutes (DCM) and Quarterly Financial Report (QFR) reporting requirements.
• Partner with operational leaders to optimise workforce performance and improve business outcomes.
• Review and optimise master rosters, balancing care requirements, funding and occupancy.
• Develop workforce models and funding forecasts to support strategic decision-making.
• Prepare Enterprise Agreement costings and analyse workforce-related business impacts.
• Support continuous improvement initiatives, tools, processes and reporting frameworks.

Skills

Commercial analysis

Workforce analytics

Financial analysis

Stakeholder influence

Excel (Advanced)

Power Query

Data-driven

Education

Commerce, Finance, Accounting, Business Analytics

CPA or CA (or progression)

Tools

Excel

Power Query

Financial modelling

Job description

Bolton Clarke is Australia’s largest not-for-profit aged care provider, seeking an experienced Commercial Analyst to drive workforce, financial and operational performance across 87 residential aged care homes. You will partner with leaders and transform data into actionable insights to inform decision-making.

Reporting to the Commercial Manager, you’ll contribute to budgeting, forecasting and governance, using advanced Excel and Power Query to analyse workforce and funding impacts.