At a Glance
- Tasks: Join an agile team to modernize social assistance reporting and enhance data management.
- Company: Dynamic organization focused on impactful social programs and innovative solutions.
- Benefits: Competitive salary, flexible work arrangements, and opportunities for professional growth.
- Other info: Work in a vibrant office with a supportive team and excellent career advancement opportunities.
- Why this job: Make a difference in social assistance while developing your skills in a collaborative environment.
- Qualifications: Experience in business analysis, data management, and proficiency in Azure Databricks and SQL.
The predicted salary is between 82800 - 101200 $ per year.
About the job RQ09232 - Business Analyst - Senior
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.
- 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.
- Sprint Planning: Participating in sprint planning meetings to help define the scope and objectives of each sprint, ensuring alignment with business goals.
- Requirement Elicitation: Working closely with stakeholders and the development team to gather and clarify requirements, often through user stories and acceptance criteria.
- Continuous Improvement: Engaging in sprint retrospectives to identify areas for improvement and implement changes to enhance team performance and product quality.
- User Story Development: Writing and refining user stories, ensuring they are clear, concise, and actionable for the development team.
- Stakeholder Collaboration: Facilitating communication between stakeholders and the development team to ensure that the delivered solutions meet business needs.
- Documentation and Reporting: Maintaining up-to-date documentation and providing regular reports on project progress and performance metrics.
- Data Profiling and Analysis: Profiling and analysing data to refine logic and design using Databricks.
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 database 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.
- (MUST HAVE) Experience in writing user stories in Azure DevOps.
- 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 (hand over to ministry staff) and building block approach which builds 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.
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.
Senior Business Analyst in Toronto employer: Rubicon Path
As a Systems Testing/QA Specialist at our Toronto location, you will thrive in a collaborative and innovative work culture that prioritizes quality and continuous improvement. We offer competitive benefits, opportunities for professional growth, and a commitment to work-life balance, ensuring that you can excel in your role while contributing to meaningful projects that impact the community. Join us to be part of a dynamic team dedicated to delivering high-quality solutions in a supportive environment.
