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
Requirements
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
