RQ09397 - Business Analyst - Senior

Maarut Inc; Toronto; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in Canada seeks a Business Analyst with extensive experience in data-centric projects and strong SQL skills. The role involves interacting with stakeholders to gather requirements, preparing comprehensive documentation, and supporting data strategies. Ideal candidates will have expertise in Agile methodologies and data governance, facilitating efficient practices within the organization.

Qualifications

• 5-8 years of experience as a Business Analyst.
• In-depth knowledge of database management systems.
• Ability to write complex SQL queries.

Responsibilities

• Gather and analyze business needs and requirements.
• Prepare documentation like business requirements documents.
• Support data migration and business intelligence initiatives.

Skills

SQL

Data modeling

Agile methodologies

Data governance

Business analysis

Tools

Azure DevOps

Power BI

ETL processes

Job description

Job Description

Responsibilities:

• Provides a comprehensive range of I&IT business analysis services for clients with diverse business and technological needs.
• Interacts with business stakeholders and subject matter experts 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 in an agile data environment.
• Experience grooming and assembling requirements into coherent user stories and use cases, managing the Product Backlog Items, refining them, and communicating changes to the project manager/Team Lead.
• Lead and conduct business analysis 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 designing data models and data integration solutions.
• Support data migration, data warehousing, and business intelligence initiatives by ensuring clarity and accuracy of requirements.
• 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.
• Use 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 with information retrieval packages and understanding of Information Management principles, policies, and practices.
• Ability to translate business and data requirements into specifications for designing technology solutions.
• Experience with business analysis methods such as functional modeling, event modeling, and process mapping.
• Experience with structured, object-oriented, and agile methodologies for user requirements.
• Developing performance measures for business analysis evaluation and follow-up.
• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) and related 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 SQL queries, joins, subqueries, and use SQL functions.
• Experience with Agile project methodology using Azure DevOps.
• Experience translating requirements into user stories.
• Deep knowledge of delta tables, ETL pipelines, change data capture, and Databricks.

Skill Set Requirements:

Technical and Project Management Expertise:

• Expertise in data warehouse design, delta lake, Medallion Architecture.
• Experience with relational databases, Azure Databricks SQL Warehouse, and Azure Data Lake.
• Strong SQL skills for data manipulation and retrieval.
• Ability to interpret Entity-Relationship Diagrams.
• Knowledge of data analysis, data modeling, data warehousing, and ETL processes.
• Understanding of data governance, quality, metadata, and MDM.
• Ability to analyze data patterns and business requirements to define data models.
• Experience documenting data element definitions, structures, and rules.
• Familiarity with reporting tools like Power BI.
• Experience with ETL testing, defect fixing, and support activities.
• Ability to develop and maintain project plans with milestones and status reports.
• Good communication skills for explaining complex data concepts to non-technical stakeholders.
• Team-oriented with a track record of meeting deadlines.