Join our team as a Senior Business Analyst to lead data-centric initiatives within a hybrid work environment (2–3 days onsite). This role focuses on translating business requirements into actionable data solutions across complex system integrations and data warehousing projects. You'll work closely with stakeholders to develop user stories, define data models, and support ETL pipelines using tools like SQL Server, Oracle, and Azure Databricks. With strong expertise in Agile methodologies, data governance, and analytics, you’ll ensure accurate data migration, reporting, and compliance. Ideal for professionals with a strong technical foundation in databases, ETL processes, and enterprise data strategies.

 

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

Hybrid Work Arrangement: FFS will need to work at 5700 Yonge for 2-3 days per week at discretion of HM.

 

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 

 

Supplier Comments

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St.

Maximum number of Candidate Submissions: 1 (one)

 

 

 

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