Intermediate business analyst to support technology projects across data, applications, and infrastructure

Our valued client is looking for an Intermediate Business Analyst to support technology projects across data, applications, and infrastructure.

This is a hybrid position (2 days per week in Ottawa)

Tasks include:

• Translate business requirements to technical specifications, requirement elicitation, backlog management, test data creation, testing and confirmation that business and technical requirements meets specifications
• Gather, document, and refine user requirements and stories to advance a variety of IT initiatives
• 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

Must have:

• Reliability level security clearance
• 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
• Understanding SQL scripts and PowerShell scripts

Nice to have

• Experience with Azure DevOps, Databricks, SQL, the Microsoft ecosystem and other enterprise data platform initiatives (large scale data migrations)

Disclaimer

AI may be used in evaluating candidates.

This posting is for an existing vacancy. Apply