HM Note: This contract role is remote, and candidates work remotely. Candidates must reside in Ontario, Canada. Candidate resumes must include first and last name, email and telephone contact information. This role commences April 1, 2026.

Description

• Provide senior technical expertise, project leadership and coordination of activities in the development, implementation and maintenance of a diverse range of cost effective I&IT solutions.
• Provide technical advice to clients and leverage OPS I&IT solutions and applications to meet program/service goals and objectives ensuring efficiency.

General Skills

• Provides specialized technical expertise in the overall analysis of the design and architecture of systems solutions.
• Ability to evaluate recommendations and ensures all recommended solutions for improvement are congruent with the project goals and objectives.
• Identifies short and long-term project goals/objectives, and as a senior technical expert, defines and identifies program and service delivery requirements in support of the development and/or acquisition of client applications.
• Leads the analysis, development and documentation of design and architecture of systems solutions.
• Leads the development of testing, integration and implementation of systems solutions into the clients' applications.
• Guides the feasibility studies and cost effective analyses of proposed client I&IT initiatives, ensures all studies and analyses are documented.
• Leads the technical aspects of projects related to the development and/or acquisition of a diverse range of client applications through all stages of the Systems Development Life Cycle (SDLC).
• This includes planning, scheduling and estimating resources, providing technical expertise, co-ordination, monitoring progress and providing management with project status updates.
• Demonstrated experience gathering requirements, translating business documents into technical specifications.
• Experience leading development/support teams supporting multi-dimensional and relational databases and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Demonstrated experience designing and developing complex applications utilizing relational and multi-dimensional databases.
• Ability to provide implementation and post implementation support as required.
• Oversees the research and evaluation of the technical components in the acquisition of software, hardware, technology, systems and products.
• Recommends and directs the measurement and improvement of tools, techniques, standards and performance criteria to control the quality of application development initiatives.
• Provides coaching and direction to junior analysts throughout the project, related to the development and/or acquisition of a diverse range of client applications through all stages of the Systems Development Life Cycle.

Desirable Skills

• Knowledge and experience in rapid application development (RAD) methodologies.
• Knowledge and experience with middleware and gateways.
• Knowledge and understanding of Information Management principles, concepts, policies and practices.
• Experience with development/maintenance of documentation as per Methodology.
• Good working knowledge of Dimensions and Facts.
• Knowledge of multidimensional structures (cubes).
• Ability to gather, review and provide feedback to business requirements.

Skills

Experience and Skill Set Requirements

Requirements:

The Consultant will be responsible for providing some or all of the following services:

• Business/Systems Analysis and Design
• Development/maintenance of documentation as per Methodology (UPM)
• Incident management/support

The Consultant will also be responsible for providing the following services:

• Complete work as assigned
• Provide progress/status information to Client Management
• Comply with Client security procedures and practices
• Comply with Client Conflict of Interest, and Confidentiality Guidelines
• Provide skills / knowledge transfer to appropriate Client staff.

Required Skills

• Demonstrated experience gathering requirements, translating business documents into technical specifications,
• Demonstrated experience presenting findings to both to client and to technical resources,
• Demonstrated experience in accounting principles /financial analysis,
• Demonstrated experience leading development/support teams supporting multi-dimensional and relational database and their applications for effective planning, budgeting, strategizing, and forecasting procedures,
• Demonstrated experience designing and developing complex applications utilizing Relational and multi-dimensional databases,
• Sound and current knowledge of planning and budgeting processes and practices as applied within the OPS,
• Sound and current knowledge of Project Management and system development practices within the OPS.

The Consultant must be able to demonstrate the ability to deal tactfully with people and have excellent interpersonal communication skills both verbal and written.

Evaluation Criteria

Experience and SkillSet

Requirements will be weighted to 70%

Database Experience: 30%

• Demonstrated experience leading development/support teams supporting multidimensional and relational database and their applications for effective planning, budgeting, strategizing, and forecasting procedures.
• Demonstrated experience designing and developing complex applications utilizing relational and multi-dimensional databases, including experience working with Oracle and SAP technologies.

Scripting Experience: 20%

• Demonstrated experience with SQL scripting skills.
• Demonstrated experience with Multi-Dimensional eXpressions (MDX) Query skills.

Microsoft Technologies Experience: 20%

• Knowledge of multidimensional structures (Cubes) in a SQL Server Analysis Services
• (SSAS) environment.
• Good working knowledge of Dimensions and Facts.
• Understanding of data extraction, transformation, and loading (ETL) concepts and
• processes in an SQL Server Integration Services (SSIS) environment.
• Knowledge of SQL Server Reporting Services (SSRS).

Business Analysis and Financial Skills: 20%

• Demonstrated experience gathering requirements, translating business documents into technical specifications
• Demonstrated experience presenting findings to both to client and to technical resources.
• Demonstrated experience in accounting principles/financial analysis

Public Sector Experience: 10%

• Current knowledge of planning and budgeting processes and practices as applied within large complex public sector environments.
• Current knowledge of Project Management and system development practices within large complex public sector environments.

Must Haves:

• Please refer to the Experience and Skill Set Requirements