Business Analyst

Zortech Solutions; Toronto; On-site; CAD 166,000 - 174,000; Full time

Job summary

A leading company is seeking a Senior Business Analyst to support the modernization of their Social Assistance reporting platform. The ideal candidate will work closely with agile teams to redesign data models and enhance operational reporting. Key responsibilities include backlog management, user story development, and stakeholder collaboration. Strong skills in Azure Databricks, SQL, along with business architecture and data migration are essential for success in this role.

Qualifications

• Experience with Azure Databricks, SQL, and PySpark is a must.
• Led business transformation initiatives focusing on architecture and data migration.
• Proficient in requirements elicitation and user story writing.

Responsibilities

• Collaborate with Product Owner for backlog management.
• Participate in sprint planning to define scope and objectives.
• Engage in data profiling and analysis using Azure Databricks.

Skills

Business architecture

Data migration

Azure Databricks

SQL

PySpark

Data profiling

Problem-solving

User story development

Job description

Title - Business Analyst
Office location - Toronto, ON
Rate - $80/HR
Submission Last Date - 9th May, 2025, 11am EST

Description

Supporting the modernization of the Social Assistance reporting platform (Legacy Cognos system), the Senior Business Analyst will work alongside the agile product team to review existing data model and redesign to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting.

Responsibilities include:

1. Backlog Management: Collaborating with the Product Owner to prioritize and refine the product backlog, ensuring that user stories are well-defined and ready for development.
2. Sprint Planning: Participating in sprint planning meetings to help define the scope and objectives of each sprint, ensuring alignment with business goals.
3. Requirement Elicitation: Working closely with stakeholders and the development team to gather and clarify requirements, often through user stories and acceptance criteria.
4. Continuous Improvement: Engaging in sprint retrospectives to identify areas for improvement and implement changes to enhance team performance and product quality.
5. User Story Development: Writing and refining user stories, ensuring they are clear, concise, and actionable for the development team.
6. Stakeholder Collaboration: Facilitating communication between stakeholders and the development team to ensure that the delivered solutions meet business needs.
7. Documentation and Reporting: Maintaining up-to-date documentation and providing regular reports on project progress and performance metrics.
8. Data Profiling and Analysis: Profiling and analysing data to refine logic and design using Databricks.

Skills and Experience Requirements:

• Technical Knowledge and Expertise - 35%
• Led/managed business transformation/solution design initiatives, with a focus on business architecture and data migration. (MUST HAVE)
• Knowledge of enterprise architectural concepts and processes, specifically in the area of business architecture for data warehouses, marts, lakes (in Azure platform). (MUST HAVE)
• Proficiency working in Azure Databricks, SQL, PySpark. (MUST HAVE)
• Experience in conceptual design of enterprise data warehouses and extensive experience in data management supporting development teams - working on requirements gathering, data profiling and analysis, and design documentation
• Understand data warehouse modeling concepts and design principles
• Advanced technical knowledge of large hardware and software operations and utilities, productivity tools, online processing systems, web-based technologies and database management systems
• Provide consultation on source to target mapping to ensure business and technical alignment
• Knowledge of Systems Development Life Cycle Methodologies, familiarity with ITIL Processes for Change/Release Management, relational data base technologies, use of information retrieval packages using SQL and other query languages.
• Knowledge of emerging IT trends and technologies - cloud computing, enterprise data warehousing, etc.
• Knowledge of accessibility compliance requirements e.g AODA, WCAG 2.1 Level A and AA or the most recent WCAG requirements
• Knowledge of front end, web-based technologies and data-mining/reporting-based COTS tools (e.g., IBM CURAM, Social Assistance Management System) encompassing feasibility studies, requirements definition, analysis, prototyping, system design, implementation, testing and maintenance (Nice to have)

Business Analysis and Problem-Solving Skills - 25%

• Experienced in requirement elicitation, documentation, data profiling and analysis, evaluation of alternative solutions and making recommendations. (MUST HAVE)
• Work with team to develop clearly defined epics and user stories.
• Experience in writing user stories in Azure DevOps. (MUST HAVE)
• Help program understand their needs and translate to design models and concepts
• Recommend approaches and discuss with team and stakeholders
• Develop technical documentation and translate to business terms

Organizational and Project Management Skills - 20%

• Plan, develop, manage, control projects and resolve complex technical design problems
• Knowledge of project management, task estimation, scheduling and control
• Development of documentation and materials as part of a review and knowledge transfer to other members
• Development of specific activities as part of a review (handover to ministry staff) and building block approach which, build on knowledge transfer and skills development from the previous stage to the next

Communication and Interpersonal Skills - 20%

• Gather information, clarify needs and desired system changes, explain system development recommendations, explain and provide instruction on new/modified systems and technology
• Prepare business cases, systems documentation, user manuals and guidelines
• Clarify and discuss systems development options with clients

Note: Please see highlighted in evaluation criteria.