RQ11277 - Business Analyst - Senior

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

Lead the design and implementation of a modern enterprise Police Data Warehouse and data standardization initiatives. The role involves gathering complex requirements, defining data standards, and ensuring the delivery of high-quality, analytics-ready datasets.

Requires over 8 years of senior business analysis experience, with at least 5 years specializing in enterprise data analysis and governance. Expertise in Agile delivery, relational data modeling, and public sector environments is essential.

Identified from the job description. Confirm important requirements above.

• Business Analysis
• Enterprise Data Analysis
• Data Governance
• Data Modeling
• Systems Integration
• Requirements Management
• Agile Delivery
• Relational Data Modeling
• ETL/ELT Concepts
• Data Flow Analysis
• Stakeholder Facilitation
• Azure DevOps
• JIRA
• Gap Analysis
• Metadata Management
• Process Modeling

• Data & Analytics
• Government & Public Sector
• Technology
• Consulting
• Management & Leadership

Minimum experience

10+ years

Apply by

Aug 26, 2026

Posting language

English

Working hours

37 hours per week

Seniority

Mid-Senior level