Associate Data Analyst - Supply Chain

Hamilton Insurance Agency is looking for an Associate Data Analyst - Supply Chain to join a small, steady team. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. This role is fully remote within Canada. Weekday working hours, with room to shift your day when needed. You get a company laptop and a headset before you start.

Your responsibilities:

Clean and reconcile data from CRM, ERP and spreadsheet sources. Automate recurring Excel reports with Power Query, Python or scheduled SQL. Analyze trends, cohorts and funnel drop-off and summarize findings in plain language. Field ad hoc requests through a ticket queue and prioritize them with your manager. Present results to managers and answer follow-up questions. Create forecasts and simple models in Excel or Google Sheets.

Skills and experience:

1+ years of experience in a data or reporting analyst role. Advanced Excel: pivot tables, XLOOKUP, Power Query. Strong SQL (joins, CTEs, aggregations, window functions). Habit of checking your own numbers before anyone else sees them. Basic statistics: averages vs. medians, distributions, significance.

Perks and benefits:

Health spending account. RRSP matching. Paid vacation.

Company overview:

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

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Start dates are flexible, usually within a few weeks of an offer.

Start: Flexible.

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