RQ10022 - Business Analyst - Senior at S M Software Solutions Inc

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 595 Bay Street, Toronto, Ontario, Onsite

Estimated Start Date: 2026-01-05

Estimated End Date: 2026-08-21

#Business Days: 159.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC + Credit Check

Must Have

• 10+ years of experience leading and conducting business and system analysis to assess client’s business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.
• Proven experience in both agile and waterfall project management methodologies.
• Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lake house or Business Intelligence/Data Analytics and Reporting solutions.
• Demonstrated experience working as a business analyst in large/complex data migration projects.
• Demonstrated experience with writing user stories and using tools such as DevOps.
  
  

Description

Scope

The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Analysts to assist with report development for the new data warehouse/lake house and associated data migration activities.

Assignment Deliverables

• As a member of the OPGT modernization data analytics and reporting team, you will be responsible to build and deliver modernized reports from the new data warehouse/lake house. A high-level list of deliverables follows:
• Lead and conduct business and system analysis in respect to building the golden layer of the data lake house and modernized reports in Power BI..
• Lead the effort into defining the reporting MVP; document legacy reports in scope of MVP; conduct gap analysis and provide recommendations.
• Document report requirements in user stories in DevOps. Conduct analysis at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
• Liaise between Business Areas and the data migration and reporting team, to clarify business requirements and translate them into system and reporting requirements.
• Conduct business modelling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects, including report requirements, screen specifications, business rules, data migration requirements, etc.
• Produce/update documentation which will allow future support of the implemented solutions.
• Assist with identifying and resolving data quality issues, defining test cases, performing data reconciliation, and addressing any issues or discrepancies that arise during the testing phase; developing KPIs to report on the progress, completeness and quality of the reporting and data migration effort.
• Ongoing Support: provide post-migration support, analyze and address data-related issues or questions; help with optimizing data management processes in the new environment.
• Other duties as assigned.
  
  

The Vendor’s Personnel Will Also Be Required To

• Complete work and achieve milestones within the assigned deadlines.
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
• Submit Deliverables for the Cluster/Ministry approval as they are completed.
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
  
  

Desired Skills And Experience

• 10+ years of experience leading and conducting business and system analysis to assess client’s business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.
• Experience conducting analyses at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
• Experience conducting business modeling; use case modeling; conceptual and logical data modeling; process and data flow modelling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects, including screen specifications, business rules, data migration requirements, etc.
• Proven experience in both agile and waterfall project management methodologies.
• Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lake house or Business Intelligence/Data Analytics and Reporting solutions
• Demonstrated experience working as a business analyst in large/complex data migration projects.
• Familiarity with BI/reporting tools such as Power BI
• Basic knowledge of SQL language; ability to execute SQL queries.
• Understanding of concepts around ETL, data quality, data cleaning, data issues’ handling.
• Experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions.
• Experience creating use cases, test plans, test cases, test scripts ideally around reporting and/or data migration.
• Experience with defect management processes, defect identification, logging, tracking, and resolution.
• Familiarity with industry-standard quality assurance practices, such as ISO standards, CMMI, or Agile methodologies
• Experience consulting and coordinating between Business Areas and the IT Development and Testing teams to clarify business requirements and translating them into system requirements.
• Critical thinking, analytical and problem-solving skills; proven gap analysis experience
• Excellent verbal and written communication skills
• Proven ability to engage with stakeholders and build strong working relationships.
• Demonstrated experience with writing user stories and using tools such as DevOps.
  
  

Experience And Skill Set Requirements

Criteria 1: Business Analysis Experience - 25 Points

• 10+ years of experience leading and conducting business and system analysis to assess client’s business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.
• Experience conducting analyses at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards.
• Experience conducting business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects, including screen specifications, business rules, data migration requirements, etc.
• Proven experience in both agile and waterfall project management methodologies, with emphasis on agile.
  
  

Criteria 2: Dynamics 365 CE / F&O Experience - 25 Points

• Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lakehouse or Business Intelligence/Data Analytics and Reporting solutions built against Dynamics 365 CE and F&O data
• experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions
  
  

Criteria 3: Data Analysis - 25 Points

• Demonstrated experience working as a business analyst in large/complex data migration projects.
• Basic knowledge of SQL language; ability to execute SQL queries.
• Understanding of concepts around ETL, data quality, data cleaning, data issues’ handling.
• Familiarity with BI/reporting tools such as PowerBI
  
  

Criteria 4: Quality Assurance - 15 Points

• Experience creating use cases, test plans, test cases, test scripts ideally around reporting and/or data migration.
• Experience with defect management processes, defect identification, logging, tracking, and resolution.
• Familiarity with industry-standard quality assurance practices, such as ISO standards, CMMI, or Agile methodologies
  
  

Criteria 5: DevOps and Agile - 10 Points

• Demonstrated experience with writing user stories and using tools such as DevOps.
  
  

Note

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

The VOR Master Service Agreement expires on April 5, 2027, and includes a six (6)-month survival clause, allowing the Statement of Work (SOW) to continue, if operationally required, until October 5, 2027. Extension(s) are only allowed using unused days and/or funds remaining on the contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. JTS may exercise its option(s) to extend the SOW beyond April 5, 2027, in accordance with the survival clause. Services required beyond this date will be acquired through a Request for Services (RFS) issued under the successor VOR.

The start date is subject to change based on security clearances and contract signing timelines.

Eligibility and Application Steps

If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: [email protected]

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)
  
  

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!

If you have any questions or need further clarification, feel free to call or text at (647) 408-1348.