RQ09232 - Business Analyst - Senior

Rubicon Path; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Business Analyst to support the modernization of their Social Assistance reporting platform. This role involves collaborating with agile teams to refine data models and enhance reporting capabilities. The ideal candidate will have a strong background in business transformation, data management, and proficiency with Azure technologies. This position offers a dynamic environment where you can make a significant impact on operational efficiency and reporting accuracy. If you're passionate about leveraging data to drive solutions, this opportunity is perfect for you.

Qualifications

• Experience in business transformation and data migration.
• Proficiency in Azure Databricks, SQL, and PySpark.

Responsibilities

• Collaborate with the Product Owner for backlog management.
• Gather and clarify requirements with stakeholders.
• Maintain documentation and provide project progress reports.

Skills

Business Transformation Management

Data Migration

Azure Databricks

SQL

PySpark

Data Profiling

Requirements Elicitation

Documentation Skills

Education

Bachelor's Degree in Computer Science or related field

Tools

Azure Data Warehouse

Azure DevOps

IBM CURAM

Job description

Please note: this is a half-year full-time posting.

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: Collaborate with the Product Owner to prioritize and refine the product backlog, ensuring user stories are well-defined and ready for development.
2. Sprint Planning: Participate in sprint planning to define scope and objectives aligned with business goals.
3. Requirement Elicitation: Gather and clarify requirements with stakeholders and the development team, using user stories and acceptance criteria.
4. Continuous Improvement: Engage in retrospectives to identify improvement areas and implement enhancements.
5. User Story Development: Write and refine user stories for clarity and actionability.
6. Stakeholder Collaboration: Facilitate communication to ensure solutions meet business needs.
7. Documentation and Reporting: Maintain documentation and provide project progress reports.
8. Data Profiling and Analysis: Profile and analyze data to refine logic and design using Databricks.

Technical Knowledge and Expertise - 35%

• Experience managing business transformation and solution design, focusing on business architecture and data migration.
• Knowledge of enterprise architecture concepts, especially in Azure data warehouses, marts, lakes.
• Proficiency with Azure Databricks, SQL, PySpark.
• Experience in designing enterprise data warehouses, data management, requirements gathering, data profiling, and documentation.
• Understanding of data warehouse modeling and design principles.
• Knowledge of large hardware/software operations, database management, and IT trends like cloud computing.
• Ability to provide source-to-target mapping consultations.
• Familiarity with SDLC, ITIL, relational databases, SQL, and emerging technologies.
• Knowledge of accessibility standards (AODA, WCAG).
• Optional: Experience with front-end web technologies and COTS tools like IBM CURAM.

Business Analysis and Problem-Solving Skills - 25%

• Experience in requirements elicitation, documentation, data analysis, and recommending solutions.
• Ability to develop clear epics and user stories, particularly in Azure DevOps.
• Translate needs into design models and concepts, develop technical documentation, and communicate effectively with stakeholders.

Organizational and Project Management Skills - 20%

• Plan and control projects, resolve technical problems, develop documentation, and facilitate knowledge transfer.

Communication and Interpersonal Skills - 20%

• Gather information, clarify needs, prepare documentation, and explain system options to clients.

Additional details:

• Closing date: 2025-05-09, 11:00 a.m.
• Maximum submissions: 1
• This is a half-year full-time position.
• The consultant is required to work in-office 3 days a week at 315 Front Street West, 3rd Floor.