Business Analyst 9232-0911

Foilcon; Toronto; Hybrid; CAD 80,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 hybrid role involves collaborating with an agile product team to redesign data models for improved scalability and flexibility. You will engage in backlog management, sprint planning, and requirement elicitation, ensuring that solutions align with business needs. If you thrive in a dynamic environment and have a passion for data-driven decision-making, this opportunity offers a chance to make a significant impact in the realm of social assistance programs.

Qualifications

• Experience leading business transformation initiatives with a focus on data migration.
• Proficiency in Azure Databricks, SQL, and PySpark for data analysis.

Responsibilities

• Collaborate with the Product Owner on backlog management and sprint planning.
• Gather and clarify requirements through user stories and stakeholder engagement.

Skills

Business transformation/solution design

Enterprise architecture concepts

Azure Databricks

SQL

PySpark

Data profiling and analysis

User story development

Stakeholder collaboration

Documentation and reporting

Project management

Education

Bachelor's degree in a relevant field

Certifications in Business Analysis

Tools

Azure DevOps

IBM CURAM

Job description

HM Note: This hybrid contract role is three (3) days in office. Candidates' resumes must include first and last name.

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 it 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 - requirements gathering, data profiling, analysis, and design documentation.
• Understanding data warehouse modeling concepts and design principles.
• Advanced knowledge of large hardware and software operations, database management systems, and web-based technologies.
• Provide consultation on source to target mapping to ensure alignment.
• Knowledge of Systems Development Life Cycle methodologies, ITIL processes, and relational database technologies.
• Awareness of emerging IT trends like cloud computing and enterprise data warehousing.
• Knowledge of accessibility compliance requirements (e.g., AODA, WCAG 2.1).
• Familiarity with front-end, web technologies, and data-mining/reporting tools (e.g., IBM CURAM, Social Assistance Management System) - Nice to have.

Business Analysis and Problem-Solving Skills - 25%

• Experience in requirement elicitation, documentation, data profiling, analysis, and recommending solutions. (MUST HAVE)
• Ability to develop clear epics and user stories.
• Experience in writing user stories in Azure DevOps. (MUST HAVE)
• Translate stakeholder needs into design models and concepts.
• Develop technical documentation and translate it into business terms.

Organizational and Project Management Skills - 20%

• Plan, develop, manage, and control projects, resolving complex technical design problems.
• Knowledge of project management, task estimation, scheduling, and control.
• Develop documentation and materials for knowledge transfer and review.
• Implement a building block approach for knowledge transfer across project stages.

Communication and Interpersonal Skills - 20%

• Gather information, clarify needs, explain system changes, and provide system development guidance.
• Prepare business cases, documentation, user manuals, and guidelines.
• Discuss system options with clients effectively.