Analyst jobs in Canada

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.

• 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).

• 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.

• 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.

• 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.

Closing Date: May 9, 2025, 11:00 AM.

The consultant needs to come 3 days in the office per week at 315 Front Street West, 3rd Floor.