Overview
Business Analyst Jobs in Ottawa, Ontario, Canada at Government Entity
Title: Business Analyst
Company: Government Entity
Location: Ottawa, Ontario, Canada
- What you will be doing:Requirements elicitation and documentation in various fomats (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.
Things you need to have:
- 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; and
- Understanding SQL scripts and PowerShell scripts.
