
Workforce & Cost Reporting Analyst
- Ontario
- Permanent
- Temps-plein
- Creates and maintains dashboards: open roles, offers/PAFs in flight, joiners/leavers, timesheet compliance, PTO trends, overtime flags.
- Maintain the master roster :employee status, title, cost center/WBS, rate, start/end dates, work location, funding code.
- Reconcile systems like workday or others ↔ timesheet app ↔ payroll; investigate and clear discrepancies
- Support month-end close: accruals for payroll timing, PTO/leave provisions, overtime, allowances.
- Maintain rate tables and cost allocations; coordinate changes tied to promotions, transfers, and role conversions.
- Partner with HR and Project Controls to produce rolling 3–6–12-month manpower and cost forecasts.
- Translate hiring plans (recruitment tracker) into costed forecasts with start dates, ramp profiles, and risks.
- Prepare the financial sections of PAFs (new hires, promotions, conversions), confirming budget neutrality or variance with mitigation.
- Track organizational changes vs approved org/budget; maintain audit trail for client reporting.
- Monitor attrition and offboarding cost impacts; produce replacement vs reduction scenarios.
- Own data standards, naming conventions, and SOPs for roster, PAFs, and cost codes.
- Build/maintain automated reports (Power Query/Power BI/Excel); manage SharePoint/Microsoft Lists folders and permissions
- 1-3 years in finance, commercial, or HR analytics
- Advanced Excel/Power Query; Power BI or equivalent.
- Comfortable with Workday (or similar HRIS), timesheet systems, and payroll interfaces.
- Strong variance analysis and narrative writing.
- Assets: Power Bi, Tableau, SQL