Job Description

Must Have: (Please update Must have skills in summary part)

Lead/manage business transformation/solution design initiatives, with a focus on business architecture and data migration. 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)

Develop technical documentation and translate to business terms

(MUST HAVE)

Proficiency working in Azure Databricks, SQL.

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.

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.

Hybrid Assignment: The consultant needs to work at the office (315 Front Street West, 3rd Floor) 3 days per week

.

From October 20, 2025, the candidate is required to work onsite 4 days a week and 1 day from home

From January 5, 2026, the candidate is required to work onsite 5 days a week fully

Skills

Experience and Skill Set 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). Proficiency working in Azure Databricks, SQL. 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

(MUST HAVE)

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 (hand over 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
Job Type: Fixed term contract
Contract length: 6 months

Pay: Up to $85.00 per hour

Application question(s):

Do you have Ministry experience? Do you have Experienced in requirement elicitation, documentation, data profiling and analysis, evaluation of alternative solutions and making recommendations. (MUST HAVE)? Do you have Work with team to develop clearly defined epics and user stories? Do you have experience in writing user stories in Azure DevOps. (MUST HAVE)? Do you Develop technical documentation and translate to business terms (MUST HAVE)? Are you Proficiency working in Azure Databricks, SQL?
Work Location: Hybrid remote in Toronto, ON M5B 2L1