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:

• 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
  

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
  

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
  

Skill Set Requirements:

Technical and Project Management Expertise:

• 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