Business Analyst 9397-2015

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

Description

Responsibilities:

Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs. Interacts with the business stakeholders and subject matter experts in order to understand their requirements through gathering, documenting, and analyzing business needs and requirements.

Prepares and advises on business analysis policies, processes, best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.

General Skills:

Leads and conducts business analysis in order to assess client's business problems/opportunities and documents the business requirements in such a way that I&IT solutions can be determined.

Applies re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches

Leads and conducts business analysis at varying levels of detail appropriate to the project and phases of project, aligning with OPS Unified Project Management Methodology, Enterprise Architecture and Gating Process, and OPS Standard Systems Development Methodologies

Develops strategies, prepares business cases and cost-benefit analysis, and conducts feasibility studies for business I&IT initiatives

Develops sound processes for requirements gathering including but not limited to JAD sessions, interviews, mockups, etc.

Conducts business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects Monitors progress, resolves problems and reports regularly to I&IT management and stakeholders

Develops performance measures and traceability matrices for business analysis evaluation and conducts follow-up

Experience developing strategies, preparing business cases and cost-benefit analysis

Experience conducting requirements gathering, developing documentation, including presentations and briefing notes and conducting stakeholder engagement

Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope

Awareness of emerging I&IT trends and technologies Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

A team player with a track record for meeting deadlines

Desirable Skills:

Experience in the use of information retrieval packages

Knowledge and understanding of Information Management principles, concepts, policies and practices

Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions

Experience with a wide range of methods, tools and techniques for business analysis such as: business functional modelling, business event modelling, business process mapping

Experience in structured, object oriented and agile methodologies for user requirements

Experience developing performance measures for business analysis evaluation and subsequent follow-up

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Skills

Experience and Skill Set Requirements

Must Haves:

• In-depth knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, Data Bricks).
• Ability to write complex queries, joins, subqueries, and use SQL functions
• Experience with Agile project methodology leveraging Azure DevOps
• Experience transposing requirements into coherent user stories
• In-depth knowledge of delta tables, ETL pipelines, change data capture and databricks
  
  

General Skills - 50%

• 5â8 years of experience as a Business Analyst, with at least 3 years focused on data-centric projects
• Experience in large-scale system integrations, data migrations, or legacy system replacements
• Experience with agile practices, including sprints, user stories, and iterative development, especially when working in an agile data environment
• Experience grooming and assembling requirements into coherent user stories and use cases and managing the Product Backlog Items, refining them and communicate changes to project manager/Team Lead
• Lead and conduct business analysis in order to assess client's business problems/opportunities at varying levels of detail appropriate to the project
• Analyze current and future data needs, data flows, and data governance practices to support enterprise data strategies
• Translate business requirements into data requirements (e.g., data sourcing, transformation logic, reporting needs, and data quality rules)
• Lead data discovery efforts and participate in the design of data models and data integration solutions
• Support data migration, data warehousing, and business intelligence initiatives by ensuring clarity and accuracy of requirements
• Ability to write clear and comprehensive documentation: business requirements documents (BRD), data dictionaries, mapping documents, and use cases.
• Conduct gap analyses between current and desired states of data assets or data processes
• Ensure data requirements align with privacy, security, and OPS regulatory standards
• Conduct business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions
• Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope
• Apply re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches
  
  

Technical and Project Management Expertise - 50%

• Expert Knowledge of data warehouse design methodologies, delta lake, Medallion Architecture
• Experience working with relational databases (e.g., SQL Server, Oracle), Azure Databricks SQL Warehouse, Azure Data Lake
• Strong skills in SQL query, manipulate, and retrieve data from relational databases.
• Experience how to create and interpret Entity-Relationship Diagrams to represent the relationships between different data entities
• Strong knowledge of data analysis techniques, data modeling, data warehousing, and of Extract/Transform/Load processes (ETL) processes
• Solid understanding of data governance, data quality, metadata, and master data management (MDM)
• Ability to analyze data patterns, structures, and business requirements to define an optimal data model
• Ability to translate business requirements into effective data models that align with organizational goals
• Documenting definitions, structures, and rules for data elements
• Familiarity with reporting tools (e.g., Power BI) and how data is structured
• Experience in defect fixing, testing support and development activities for ETL tool
• Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
• Good communication skills to explain complex data modeling concepts to non-technical business users and ensure alignment with their needs
• A team player with a track record for meeting deadlines
  
  

Must Haves:

• In-depth knowledge of database management systems (e.g., SQL Server, Oracle, MySQL, Data Bricks).
• Ability to write complex queries, joins, subqueries, and use SQL functions
• Experience with Agile project methodology leveraging Azure DevOps
• Experience transposing requirements into coherent user stories
• In-depth knowledge of delta tables, ETL pipelines, change data capture and databricks