Business Analyst (ID#5100)

New Value Solutions; Regina; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A national IT consulting company is seeking a Business Analyst in Canada to support capacity and demand modeling. The ideal candidate will have over 5 years of experience, focusing on resource forecasting and strategic planning. Responsibilities include developing models, analyzing data, and collaborating with various departments. Competitive pay ranges from $65 to $90 per hour based on experience.

Qualifications

• 5+ years as a Business Analyst, preferably in Portfolio Management.
• Direct experience with capacity planning and resource forecasting.
• Success in developing demand models that balance initiatives.

Responsibilities

• Develop and maintain capacity and demand models.
• Analyze resource forecasts and utilization trends.
• Collaborate with Portfolio Managers to integrate demand assumptions.

Skills

Capacity planning

Resource forecasting

Data analysis

Excel (advanced)

Power BI

Tools

Excel

Power BI

Job description

New Value Solutions, a national IT consulting company, is seeking a Business Analyst to support the development, refinement, and reporting of organizational capacity and demand models. This role is pivotal in enabling balanced program portfolio planning by ensuring that project demand is realistically aligned with available organizational capacity across multiple business divisions and functions.

Responsibilities:

• Develop and maintain enterprise-wide capacity and demand models to inform prioritization and execution of program and project initiatives.
• Analyze and validate resource forecasts, utilization trends, and allocation scenarios across departments, including IT, Data, Operations, and Business Units.
• Collaborate with Portfolio Managers and Program Sponsors to ensure realistic demand assumptions are used in planning cycles.
• Integrate capacity considerations into the portfolio intake, planning, and prioritization processes, helping to balance initiative timing and resource availability.
• Provide clear, data-driven insights and recommendations through dashboards, visualizations, and executive summaries.
• Support the governance framework by ensuring timely reporting and escalations where demand exceeds capacity.
• Partner with Finance and HR to align resourcing assumptions with FTE availability, role types, skill sets, and budgetary constraints.
• Contribute to the continuous improvement of forecasting tools, capacity models, and reporting processes.
• Act as a subject matter expert on capacity and demand planning in strategic and operational discussions.
• Support scenario modeling for "what-if" planning to inform trade-off decisions in response to organizational shifts or emerging priorities.

Requirements:

• 5+ years as a Business Analyst, preferably in Portfolio Management, Strategic Planning, or Enterprise PMO environments.
• Direct experience working with capacity planning, resource forecasting, or workforce planning models.
• Proven success in developing and interpreting demand models that balance strategic initiatives and BAU workload across multiple business areas.
• Experience analyzing data across diverse departments and domains, including IT, corporate services, operations, and shared services.
• Strong experience with tools such as Excel (advanced), Power BI, or equivalent data visualization and reporting tools.
• Experience in the insurance, financial services, or regulated industries is preferred.
• Exposure to Agile and Waterfall project environments is preferred.
• Understanding of organizational design principles and how roles, teams, and skills interact with capacity planning is preferred.
• Familiarity with project portfolio management tools is preferred.

If you have this expertise, and are able to work in Canada, please submit your resume. While we thank all candidates in advance for their application, only those candidates who are shortlisted will be contacted.

ID# 5100

The hourly rate range for this position is $65 - $90, with the final rate based on consultant experience and fit for the role.