Business Analyst
Job Summary
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
- 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).
Required Experience:
IC
About Company
NewFound Recruiting is a Canadian staffing and recruitment agency based out of Ottawa, Canada, that connects top talent with reputable businesses.