Business Analyst

Contract Term:12 months, with possible extension


Location:

• This role is a hybrid position and must be filled by individuals residing within National Capital Region
• Work from outside National Capital Region is not permitted.

Hourly Pay

• $65-80 per hour

(This represents the expected hourly compensation for this role.)

Vacancy Status

• This posting is for an existing contract vacancy.

Tasks / Deliverables

Key Responsibilities

• Requirements elicitation and documentation in various formats (i.e., User stories, Business Requirements Document (BRD) etc.) for considered alternatives;
• Translate business requirements into technical data specifications and analytical models;
• Perform business analyses of functional requirements to identify information, procedures, and decision flows;
• Evaluate existing procedures and methods, identify and document items such as database content, structure, integrated application subsystems;
• Analyze and map the existing business model and the operations, identify areas with scope for improvement;
• Analyze and evaluate existing business process;
• Define and document interfaces of manual to automated operations within application subsystems, to external systems, and between new and existing systems;
• Establish acceptance test criteria with client;
• Develop and establish service level agreements;
• Assist in the formalization of business process standards;
• Support and use the selected organizational methodologies;
• Assist in the development of organizational methodologies and tools;
• Analyze and develop of business success "critical success factors";
• Analyze and develop of architecture requirements design, process development, process mapping and training;
• Responsible for leading other functional staff to define business strategy and processes in support of transformation and change management activities;
• Participate in change impact analysis and change management activities;
• Participate in organizational realignment;
• Coordinate development of training and coordination with other stakeholders;
• Create presentations and present to various stakeholders and facilitate meetings and discussions.
• Document data definitions and ensure alignment with enterprise standards;
• Clean, transform, and model structured and semi-structured datasets;
• Validate transformations across Bronze / Silver / Gold layers (Databricks/lakehouse);
• Perform data reconciliation and identify discrepancies;
• Create and manage test datasets to support development and testing;
• Support data quality validation and reconciliation processes;
• Maintain documentation for dashboards, pipelines, and business rules;
• Define test scenarios covering business use cases and edge cases including integration and nonfunctional requirements; and
• Work closely with Delivery/Integration Lead for UAT coordination and readiness. This includes creating test cases, test data creation and conducting UAT
•  

The Proposed Resource should have the following requirements, at a minimum:
 

• Previous relevant experience as a Business Analyst;
• Experience working in Azure DevOps or similar environments;
• Ability to use Microsoft SQL Server Management Studio to review data; andUnderstanding SQL scripts and PowerShell scripts
• Experience with Azure DevOps, Databricks, SQL, the Microsoft ecosystem and other enterprise data platform initiatives (large scale data migrations).

Requirements

• Security Clearance: Must be eligible for Reliability level Federal Security Clearance (generally requires 5 years of residence in Canada)
• Applicants must be legally eligible to work in Canada

Language Requirements

• Proficiency in English (spoken and written) is required for this role.

Use of Artificial Intelligence

• Artificial intelligence may be used in the screening or assessment of applicants for this role.

Additional Information

• Accommodations are available throughout the recruitment process upon request.

Application Process

• Qualified candidates are encouraged to apply.
• Only applicants selected for an interview will be contacted.

The key duties and responsibilities include, but are not limited to, the following:

 

• Requirements elicitation and documentation in various formats (i.e., User stories, Business Requirements Document (BRD) etc.) for considered alternatives;
• Translate business requirements into technical data specifications and analytical models;
• Perform business analyses of functional requirements to identify information, procedures, and decision flows;
• Evaluate existing procedures and methods, identify and document items such as database content, structure, integrated application subsystems;
• Analyze and map the existing business model and the operations, identify areas with scope for improvement;
• Analyze and evaluate existing business process;
• Define and document interfaces of manual to automated operations within application subsystems, to external systems, and between new and existing systems;
• Establish acceptance test criteria with client;
• Develop and establish service level agreements;
• Assist in the formalization of business process standards;
• Support and use the selected organizational methodologies;
• Assist in the development of organizational methodologies and tools;
• Analyze and develop of business success "critical success factors";
• Analyze and develop of architecture requirements design, process development, process mapping and training;
• Responsible for leading other functional staff to define business strategy and processes in support of transformation and change management activities;
• Participate in change impact analysis and change management activities;
• Participate in organizational realignment;
• Coordinate development of training and coordination with other stakeholders;
• Create presentations and present to various stakeholders and facilitate meetings and discussions.
• Document data definitions and ensure alignment with enterprise standards;
• Clean, transform, and model structured and semi-structured datasets;
• Validate transformations across Bronze / Silver / Gold layers (Databricks/lakehouse);
• Perform data reconciliation and identify discrepancies;
• Create and manage test datasets to support development and testing;
• Support data quality validation and reconciliation processes;
• Maintain documentation for dashboards, pipelines, and business rules;
• Define test scenarios covering business use cases and edge cases including integration and nonfunctional requirements; and
• Work closely with Delivery/Integration Lead for UAT coordination and readiness. This includes creating test cases, test data creation and conducting UAT

The Proposed Resource should have the following requirements, at a minimum:
 

• Previous relevant experience as a Business Analyst;
• Experience working in Azure DevOps or similar environments;
• Ability to use Microsoft SQL Server Management Studio to review data; andUnderstanding SQL scripts and PowerShell scripts
• Experience with Azure DevOps, Databricks, SQL, the Microsoft ecosystem and other enterprise data platform initiatives (large scale data migrations).