Junior Financial Analyst

Founded as a farmers' mutual in 1936, the company is now one of the larger mutual insurers in Canada.

Overview:

This is an Excel-heavy role. We also use Adaptive Planning and Power BI. Hamilton Insurance Agency runs an annual budget with a rolling quarterly reforecast. You will own the model for two business units. Fully remote. You can work from anywhere in Canada. We do not have many meetings. Most updates happen in writing. You get a company laptop and a headset before you start.

Day to day:

• Partner with department heads to understand spending and headcount plans
• Develop dashboards in Power BI or Tableau for leadership
• Prepare monthly variance analysis against budget and prior year
• Reconcile forecast data with accounting after close
• Track headcount and payroll costs against plan

Qualifications:

• 0-2 years of FP&A, corporate finance or public accounting experience
• Experience building budgets and forecasts
• Familiar with an ERP such as NetSuite, SAP or Oracle
• Advanced Excel: INDEX/MATCH, XLOOKUP, SUMIFS, pivot tables and linked three-statement models
• Clear written commentary for monthly reporting
• Working knowledge of accounting and how the three statements connect

$54,000 - $63,000 a year

Why work with us:

• Extended health and dental benefits
• Group RRSP with employer matching
• Paid vacation
• Professional development budget

A resume is enough to apply. Cover letters are optional.

This position requires a background check.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Hamilton Insurance Agency.