Specialist, Talent Analytics & Workforce Planning

AECON

The Role

Overview

Design and maintain Power BI dashboards and workforce planning models for talent analytics.

Key Responsibilities

  • power bi
  • dashboard design
  • data validation
  • metrics development
  • workforce planning
  • user support

Tasks

-Gather user feedback, assess data needs, and evolve tools and dashboards to meet emerging business requirements. -Provide training, documentation, and end-user support for dashboards, reporting tools, and new analytics features. -Ensure data integrity by validating inputs, cleaning data sets, and improving automated data pipelines where applicable. -Conduct supply–demand analysis, identify talent risks (e.g., skill shortages, critical roles, peak hiring periods), and recommend mitigation strategies. -Document processes, data definitions, and reporting standards to improve clarity and consistency across TA and HR. -Maintain and continuously improve workforce planning processes, tools, and reporting standards. -Design, build, maintain, and optimize Power BI dashboards, reports, and data models that support Talent Acquisition and Workforce Planning priorities. -Analyze labour market trends and internal workforce data to guide stakeholders in strategic decision-making. -Analyze TA and workforce data to identify trends, gaps, and actionable insights, providing clear recommendations to improve hiring efficiency, quality, and forecasting accuracy. -Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being. -Research and apply industry best practices in TA analytics, reporting, and data visualization. -Oversee the technical maintenance of recruitment dashboards, including troubleshooting, updates, enhancements, and user access management. -Facilitate alignment between Operations and TA on resourcing timelines, ensuring recruitment strategies match project schedules. -Develop and monitor metrics that support business needs; time-to-fill, funnel analytics, forecasted hiring demand, headcount planning, etc. -Develop and maintain workforce planning models, templates, and Power BI dashboards that support annual business planning and ongoing forecasting cycles. -Partner with TA, HRBPs, Operations, and Finance to understand hiring demand, project requirements, and workforce gaps for short- and long-term planning. -Support scenario planning for project ramp-ups, demobilizations, and shifting resourcing needs. -Identify continuous improvement opportunities to enhance reporting efficiency, dashboard functionality, and talent data reliability. -Prepare data-driven summaries and insights for leadership reviews, translating complex information into clear, actionable narratives. -Collaborate cross-functionally to align talent data needs and planning assumptions. -Act as the primary point of contact for TA teams on analytics, dashboards, and workforce planning tools.

Requirements

  • power bi
  • advanced excel
  • 5+ years
  • talent analytics
  • workforce planning
  • hr metrics

What You Bring

-Strong sense of ownership, accountability, and proactive problem-solving -Experience partnering with HR, TA, Operations, Finance, and other cross-functional teams -Highly organized with strong attention to detail and accuracy -Communicate insights clearly to stakeholders at all levels with strong data storytelling skills. -Strong communication skills with the ability to translate technical data into business-friendly language -Experience developing workforce planning models, templates, and forecasting tools -Comfortable delivering training, documentation, or walkthroughs for dashboards and planning tools -Advanced Power BI expertise, including DAX, data modeling, data transformations, and building dashboards from scratch -Demonstrated ability to work independently with limited guidance -Strong understanding of Talent Acquisition and HR metrics (time-to-fill, funnel analytics, turnover, headcount trends, etc.) -Ability to interpret labour market trends and apply them to workforce planning and recruitment strategies -Ability to manage multiple priorities and pivot quickly as needs change -5-7+ years of experience in Talent Analytics, HR Analytics, Workforce Planning, or a related data/HR discipline -Ability to improve processes, reporting, and data tools through continuous improvement -Ability to analyze complex data sets and translate insights into actionable recommendations -Experience conducting supply–demand analysis and identifying workforce and skills gaps -Experience supporting Talent Acquisition, HR, or Operations with workforce planning, forecasting, or talent insights -Strong Excel skills (pivot tables, advanced formulas, modeling) -Ability to clean, validate, and combine large datasets from multiple sources -Ability to gather stakeholder requirements and translate them into dashboards or planning tools

The Company

About AECON

-Spanning over 150 years. -Operates in civil infrastructure, urban transportation, and energy solutions. -Involved in planning, financing, and execution through public-private partnerships. -Advanced urban transportation projects, such as the Réseau express métropolitain (REM). -Advancing projects like the Darlington Small Modular Reactor. -Committed to sustainability and cutting-edge technology.

Sector Specialisms

Civil

Nuclear

Industrial

Utilities

Transport