RQ11277 - Business Analyst - Senior
About the role
Business Analyst – Senior
Client: Ministry of Public and Business Service Delivery and Procurement (MPBSDP)
Work Model: 100% Onsite – Toronto / North Bay, Ontario
We are seeking an experienced Senior Business Analyst to support the design and implementation of a modern enterprise Police Data Warehouse and data standardization initiatives. The ideal candidate will possess extensive experience in business analysis, enterprise data management, data governance, and systems integration, with the ability to bridge business objectives and technical solutions in large-scale digital transformation programs.
This role requires 8+ years of senior Business Analysis experience, including 5+ years of enterprise data analysis, data governance, and integration, with expertise in requirements management, relational data modeling, Agile delivery, and enterprise reporting solutions.
Role Snapshot
Job Details Job Title RQ11277 – Senior Business Analyst Client Ministry of Public and Business Service Delivery and Procurement Work Location 25 Grosvenor St / 200 First Avenue, North Bay, Ontario Work Model 100% Onsite (5 Days/Week) Estimated Start Date October 1, 2026 Estimated End Date October 5, 2027 Duration 250 Business Days Extension Likely based on project requirements Hours 7.25 Hours per Day Security Clearance OPP Level 4
Application Requirements
Interested candidates should submit the following documents to hrsmss@smsoftconsulting.com by Monday, July 27, 10:00 AM EST.
Mandatory Documents
Updated Resume (Word Format)
Professional References Expected Hourly Rate Visa Status LinkedIn Profile URL
Position Overview
The Senior Business Analyst will play a critical role in delivering enterprise data modernization initiatives focused on policing and correctional services. Working closely with business stakeholders, architects, and data engineering teams, the consultant will gather complex business and technical requirements, define enterprise data standards, support data integration initiatives, and ensure delivery of high-quality, analytics-ready datasets.
The successful candidate will have strong expertise in enterprise data governance, data modeling, process analysis, and Agile project delivery within complex public-sector environments.
Key Responsibilities
Business Analysis & Requirements Management (35%)
Lead enterprise-wide business and data requirements gathering activities. Facilitate stakeholder workshops across ministry and justice partners.
Document and validate
Business requirements Functional and non-functional requirements Data and reporting requirements Integration requirements User stories Acceptance criteria Business rules Perform gap analysis, change impact assessments, and requirements traceability. Ensure requirements remain aligned with project objectives and enterprise governance standards.
Enterprise Data Analysis & Modeling (30%)
Analyze existing enterprise data structures and information assets. Document current-state and target-state data models.
Define
Business entities Relationships Normalized relational structures Primary and foreign keys Develop: Source-to-target mappings Transformation rules Data lineage documentation Validation logic Support development of analytics-ready and reporting-ready datasets.
Data Integration & Solution Design (20%)
Produce enterprise data flow diagrams and process models. Document system interfaces and integration requirements. Identify enterprise data dependencies and interoperability considerations. Collaborate with solution architects and development teams to ensure technical feasibility. Support enterprise data warehouse implementation and modernization initiatives.
Data Governance & Quality Management (15%)
Develop and maintain: Data dictionaries Business glossaries Metadata standards Naming conventions Data quality rules Promote enterprise data governance best practices. Ensure consistency, quality, and traceability of enterprise datasets. Support implementation of data lifecycle management processes and governance controls.
Required Skills & Experience
Skill / Experience Years Required Senior Business Analysis experience on enterprise initiatives 8+ Years Leading end-to-end business, functional, and data requirements 5+ Years Enterprise data analysis, mapping, and integration 5+ Years Data governance, metadata management, and data quality 5+ Years Requirements traceability, gap analysis, and impact assessment Required Agile delivery using Azure DevOps and/or JIRA Required Relational data modeling and enterprise data warehousing Required ETL / ELT concepts and analytics-ready data design Required Enterprise data architecture and integration patterns Required Data flow analysis and process modeling Required Business rules development and reporting logic Required Strong stakeholder facilitation and workshop leadership Required Excellent documentation and communication skills Required
Preferred Qualifications
Candidates with experience in the following areas will be highly regarded
Azure Data Platform
Databricks Oracle Database Azure SQL Enterprise reporting solutions Large-scale digital transformation programs Government or Public Sector environments Justice, Policing, or Corrections data domains
Core Competencies
Business Analysis Leadership
Enterprise Data Analysis Data Governance Data Modeling Data Integration Requirements Engineering Process Improvement Agile Delivery (Scrum/Kanban) Stakeholder Engagement Workshop Facilitation Enterprise Documentation Analytical Thinking Problem Solving Communication & Presentation Skills
Why Join This Opportunity?
This engagement offers the opportunity to contribute to a high-impact public sector data modernization initiative supporting policing and correctional services across Ontario. The selected consultant will work on enterprise-scale data transformation projects involving modern data architecture, governance, analytics, and digital service delivery.
How To Apply
Please submit the following to hrsmss@smsoftconsulting.com by Monday, July 27, 10:00 AM EST:
Updated Resume (Word Format)
Professional References Expected Hourly Rate Visa Status LinkedIn Profile URL
Not the right fit? Search for RQ11277 jobs in Toronto, Ontario, Canada
About S M Software Solutions Inc
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.
Similar Jobs
RQ11277 - Business Analyst - Senior
About the role
Business Analyst – Senior
Client: Ministry of Public and Business Service Delivery and Procurement (MPBSDP)
Work Model: 100% Onsite – Toronto / North Bay, Ontario
We are seeking an experienced Senior Business Analyst to support the design and implementation of a modern enterprise Police Data Warehouse and data standardization initiatives. The ideal candidate will possess extensive experience in business analysis, enterprise data management, data governance, and systems integration, with the ability to bridge business objectives and technical solutions in large-scale digital transformation programs.
This role requires 8+ years of senior Business Analysis experience, including 5+ years of enterprise data analysis, data governance, and integration, with expertise in requirements management, relational data modeling, Agile delivery, and enterprise reporting solutions.
Role Snapshot
Job Details Job Title RQ11277 – Senior Business Analyst Client Ministry of Public and Business Service Delivery and Procurement Work Location 25 Grosvenor St / 200 First Avenue, North Bay, Ontario Work Model 100% Onsite (5 Days/Week) Estimated Start Date October 1, 2026 Estimated End Date October 5, 2027 Duration 250 Business Days Extension Likely based on project requirements Hours 7.25 Hours per Day Security Clearance OPP Level 4
Application Requirements
Interested candidates should submit the following documents to hrsmss@smsoftconsulting.com by Monday, July 27, 10:00 AM EST.
Mandatory Documents
Updated Resume (Word Format)
Professional References Expected Hourly Rate Visa Status LinkedIn Profile URL
Position Overview
The Senior Business Analyst will play a critical role in delivering enterprise data modernization initiatives focused on policing and correctional services. Working closely with business stakeholders, architects, and data engineering teams, the consultant will gather complex business and technical requirements, define enterprise data standards, support data integration initiatives, and ensure delivery of high-quality, analytics-ready datasets.
The successful candidate will have strong expertise in enterprise data governance, data modeling, process analysis, and Agile project delivery within complex public-sector environments.
Key Responsibilities
Business Analysis & Requirements Management (35%)
Lead enterprise-wide business and data requirements gathering activities. Facilitate stakeholder workshops across ministry and justice partners.
Document and validate
Business requirements Functional and non-functional requirements Data and reporting requirements Integration requirements User stories Acceptance criteria Business rules Perform gap analysis, change impact assessments, and requirements traceability. Ensure requirements remain aligned with project objectives and enterprise governance standards.
Enterprise Data Analysis & Modeling (30%)
Analyze existing enterprise data structures and information assets. Document current-state and target-state data models.
Define
Business entities Relationships Normalized relational structures Primary and foreign keys Develop: Source-to-target mappings Transformation rules Data lineage documentation Validation logic Support development of analytics-ready and reporting-ready datasets.
Data Integration & Solution Design (20%)
Produce enterprise data flow diagrams and process models. Document system interfaces and integration requirements. Identify enterprise data dependencies and interoperability considerations. Collaborate with solution architects and development teams to ensure technical feasibility. Support enterprise data warehouse implementation and modernization initiatives.
Data Governance & Quality Management (15%)
Develop and maintain: Data dictionaries Business glossaries Metadata standards Naming conventions Data quality rules Promote enterprise data governance best practices. Ensure consistency, quality, and traceability of enterprise datasets. Support implementation of data lifecycle management processes and governance controls.
Required Skills & Experience
Skill / Experience Years Required Senior Business Analysis experience on enterprise initiatives 8+ Years Leading end-to-end business, functional, and data requirements 5+ Years Enterprise data analysis, mapping, and integration 5+ Years Data governance, metadata management, and data quality 5+ Years Requirements traceability, gap analysis, and impact assessment Required Agile delivery using Azure DevOps and/or JIRA Required Relational data modeling and enterprise data warehousing Required ETL / ELT concepts and analytics-ready data design Required Enterprise data architecture and integration patterns Required Data flow analysis and process modeling Required Business rules development and reporting logic Required Strong stakeholder facilitation and workshop leadership Required Excellent documentation and communication skills Required
Preferred Qualifications
Candidates with experience in the following areas will be highly regarded
Azure Data Platform
Databricks Oracle Database Azure SQL Enterprise reporting solutions Large-scale digital transformation programs Government or Public Sector environments Justice, Policing, or Corrections data domains
Core Competencies
Business Analysis Leadership
Enterprise Data Analysis Data Governance Data Modeling Data Integration Requirements Engineering Process Improvement Agile Delivery (Scrum/Kanban) Stakeholder Engagement Workshop Facilitation Enterprise Documentation Analytical Thinking Problem Solving Communication & Presentation Skills
Why Join This Opportunity?
This engagement offers the opportunity to contribute to a high-impact public sector data modernization initiative supporting policing and correctional services across Ontario. The selected consultant will work on enterprise-scale data transformation projects involving modern data architecture, governance, analytics, and digital service delivery.
How To Apply
Please submit the following to hrsmss@smsoftconsulting.com by Monday, July 27, 10:00 AM EST:
Updated Resume (Word Format)
Professional References Expected Hourly Rate Visa Status LinkedIn Profile URL
Not the right fit? Search for RQ11277 jobs in Toronto, Ontario, Canada
About S M Software Solutions Inc
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.