Senior Business Analyst

Tangentia; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading consulting firm seeks a Senior Business Analyst to manage complex data-centric projects. This hybrid role involves analyzing data needs, crafting user stories, and ensuring data governance compliance. Ideal candidates will possess extensive experience in data management and agile practices, contributing to innovative solutions for clients.

Qualifications

• 5-8 years as a Business Analyst focusing on data-centric projects.
• Experience with large-scale system integrations and data migrations.
• Strong documentation skills, including business requirements documents.

Responsibilities

• Lead business analysis to assess client’s data needs.
• Translate business requirements into data requirements.
• Support data migration and business intelligence initiatives.

Skills

Database management systems

SQL proficiency

Agile methodology

Requirement transposition

Data governance

Education

Degree in Business, IT, or related field

Tools

Azure DevOps

Power BI

Job description

Role: Senior Business Analyst
Location: Toronto, ON
Duration: 1 year plus
Hybrid : 3 days work from office and 2 days work from home

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