Business Analyst

On behalf of our public sector client, Affinity is looking for a highly analytical and collaborative 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.

Qualifications:

Required Experience:

• 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.

Preferred Experience:

• Experience in the insurance, financial services, or regulated industries.

• Exposure to Agile and Waterfall project environments.

• Understanding of organizational design principles and how roles, teams, and skills interact with capacity planning.

• Familiarity with project portfolio management tools

Key Competencies:

• Analytical Thinking: Ability to interpret complex data and draw insights to support actionable decisions.

• Business Acumen: Understands how strategic goals translate into operational work and capacity needs.

• Stakeholder Engagement: Skilled at building relationships and translating technical or analytical insights for non-technical audiences.

• Communication: Strong written and verbal skills; able to clearly convey analysis, rationale, and recommendations.

• Problem Solving: Able to assess constraints, risks, and trade-offs to support sound decision-making.

• Process Improvement Mindset: Continuously looks for opportunities to streamline, enhance, or automate planning and reporting.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12388