RQ11277 Business Analyst Senior

Scope:

• The Business Analyst will support the design and delivery of a police data warehouse and related data standardization initiatives and the modernization of data acquisition and access for correctional services such as:
  
• Gathering complex business and data requirements supporting data integration and translate business and operational needs into clear artifacts (process models business rules data definitions data dictionary etc.).
  
• Working closely with business stakeholders and data engineering teams to define data requirements document transformation logic and ensure the delivery of high quality analytics-ready datasets.
  

Assignment Deliverables:

1. Business & Data Requirements

• Lead end-to-end requirements gathering across ministry and justice partners.
  
• Document and validate:
  
• Business functional non-functional data integration and reporting requirements
  
• User stories acceptance criteria and business rules
  
• Ensure requirements are clear prioritized and aligned with data acquisition and governance objectives.
  

2. Data Analysis Modelling & Mapping

• Analyze current-state (including non-relational) data and document key elements.
  
• Define target relational data structures including:
  
• Entities relationships and normalized tables
  
• Primary and foreign keys aligned to business domains
  
• Develop:
  
• Source-to-target mappings (column-level)
  
• Transformation logic (analytics-ready / SQL-ready)
  
• End-to-end data traceability
  

3. Process Data Flow & Integration

• Produce core artifacts:
  
• Process maps and workflows
  
• Data flow diagrams and data models
  
• Integration and interface requirements
  
• Identify data flows integration points and system dependencies.
  
• Support solution design by ensuring requirements are feasible and aligned with architecture.
  

4. Data Standards Governance & Quality

• Develop and maintain:
  
• Data definitions business rules and data dictionary
  
• Naming conventions and metadata standards
  
• Align deliverables with ministry data governance frameworks.
  
• Support design of data management processes (intake validation quality controls).
  
• Maintain requirements traceability and support validation to ensure datasets are accurate complete and analytics ready.
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Extensive senior-level business analysis experience: Minimum 8 years experience as a Business Analyst including leading end-to-end requirements across business and data needs with expertise in requirements traceability gap analysis and Agile delivery tools (e.g. Azure DevOps JIRA).
  
• Strong data management integration and governance expertise: At least 5 years experience working with data including analyzing mapping and integration within complex enterprise environments including data modelling lineage and transformation as well as applying data governance frameworks to support standardized analytics-ready datasets.
  

Skill Set Requirements:

Mandatory Requirements

1. Business Analysis Experience

• Minimum 8 years as a Business Analyst supporting medium to large enterprise projects.
  
• At least 5 years leading end-to-end requirements across business functional data and reporting domains.
  
• Experience with:
  
• Requirements traceability gap analysis and change impact assessment
  
• Agile delivery tools (e.g. Azure DevOps JIRA)
  

2. Data Management & Governance:

• Minimum 5 years applying data management frameworks in complex environments including:
  
• Data lifecycle and governance
  
• Metadata management and data quality
  
• Experience supporting standardized controlled data practices across enterprise systems.
  

3. Data Analysis Mapping & Integration:

• Strong experience (5 years) in:
  
• Analyzing and documenting data structures flows and lineage
  
• End-to-end data mapping and validation rules
  
• Knowledge of enterprise data architecture and integration patterns including:
  
• Data pipelines and interoperability
  
• Impacts to analytics reporting and downstream use
  

Desired Skills and Experience:

1. Business & Data Requirements:

• Lead end-to-end requirements gathering across ministry and justice partners.
  
• Document and validate:
  
• Business functional non-functional data integration and reporting requirements
  
• User stories acceptance criteria and business rules
  
• Ensure requirements are clear prioritized and aligned with data acquisition and governance objectives.
  

2. Data Analysis Modelling & Mapping:

• Analyze current-state (including non-relational) data and document key elements.
  
• Define target relational data structures including:
  
• Entities relationships and normalized tables
  
• Primary and foreign keys aligned to business domains
  
• Develop:
  
• Source-to-target mappings (column-level)
  
• Transformation logic (analytics-ready / SQL-ready)
  
• End-to-end data traceability
  

3. Process Data Flow & Integration:

• Produce core artifacts:
  
• Process maps and workflows
  
• Data flow diagrams and data models
  
• Integration and interface requirements
  
• Identify data flows integration points and system dependencies.
  
• Support solution design by ensuring requirements are feasible and aligned with architecture.
  

4. Data Standards Governance & Quality:

• Develop and maintain:
  
• Data definitions business rules and data dictionary
  
• Naming conventions and metadata standards
  
• Align deliverables with ministry data governance frameworks.
  
• Support design of data management processes (intake validation quality controls).
  
• Maintain requirements traceability and support validation to ensure datasets are accurate complete and analytics ready.
  

Business Analysis & Delivery:

• Proven experience leading business analysis activities on large complex multi-stakeholder digital projects.
  
• Strong ability to translate business needs into clear structured and actionable requirements.
  
• Experience producing key BA artifacts including:
  
• Business and functional requirements
  
• Process maps and workflows
  
• Data flow diagrams and specifications
  
• Experience working in Agile delivery environments (Scrum/Kanban) using tools such as Azure DevOps or JIRA.
  

Data Analysis & Technical Knowledge:

• Solid understanding of relational data modeling and data warehousing concepts.
  
• Knowledge of data transformation processes (ETL/ELT) and analytics-ready dataset design.
  
• Experience defining business rules and data logic to support reporting and analysis.
  
• Familiarity with:
  
• Enterprise data platforms (e.g. Azure Databricks)
  
• Relational databases (e.g. Oracle Azure SQL)
  
• Understanding of large datasets data structures and integration concepts.
  

Data Governance & Quality:

• Knowledge of data governance principles including:
  
• Data quality and validation
  
• Metadata management and data standards
  
• Experience supporting standardized data definitions and consistent data practices across systems.
  

Communication & Facilitation:

• Strong communication and documentation skills with the ability to tailor messaging to technical business and executive audiences.
  
• Proven facilitation skills to lead workshops and discussions with diverse stakeholder groups.
  
• Ability to synthesize complex information into clear and concise outputs.
  

Professional Attributes:

• Strong analytical and problem-solving skills.
  
• Ability to work independently and collaboratively in fast-paced multi-stakeholder environments.
  
• High attention to detail and commitment to quality.
  

Sector Knowledge (Asset):

• Experience or familiarity with justice policing or corrections data is an asset.
  

Business Analyst Skills:

• Proven experience leading business analysis activities on large complex multi-stakeholder digital projects.
  
• Strong ability to translate business needs into clear structured and actionable requirements.
  
• Experience producing key BA artifacts including:
  
• Business and functional requirements
  
• Process maps and workflows
  
• Data flow diagrams and specifications
  
• Experience working in Agile delivery environments (Scrum/Kanban) using tools such as Azure DevOps or JIRA.
  
• Ability to work independently and collaboratively in fast-paced multi-stakeholder environments.
  

Technical & Data Skills:

• Solid understanding of relational data modeling and data warehousing concepts.
  
• Knowledge of data transformation processes (ETL/ELT) and analytics-ready dataset design.
  
• Experience defining business rules and data logic to support reporting and analysis.
  
• Familiarity with:
  
• Enterprise data platforms (e.g. Azure Databricks)
  
• Relational databases (e.g. Oracle Azure SQL)
  
• Understanding of large datasets data structures and integration concepts.
  
• Knowledge of data governance principles including:
  
• Data quality and validation
  
• Metadata management and data standards
  
• Experience supporting standardized data definitions and consistent data practices across systems.
  
• Strong analytical and problem-solving skills.
  
• High attention to detail and commitment to quality.
  

Communication Skills:

• Strong communication and documentation skills with the ability to tailor messaging to technical business and executive audiences.
  
• Proven facilitation skills to lead workshops and discussions with diverse stakeholder groups.
  
• Ability to synthesize complex information into clear and concise outputs.
  

Public Sector Experience:

• Previous experience working in Government or Public Sector organizations.
  
• Experience or familiarity with justice policing or corrections data is an asset.
  

Required Skills:

Experience and Skill Set Requirements: Must Haves: Extensive senior-level business analysis experience: Minimum 8 years experience as a Business Analyst including leading end-to-end requirements across business and data needs with expertise in requirements traceability gap analysis and Agile delivery tools (e.g. Azure DevOps JIRA). Strong data management integration and governance expertise: At least 5 years experience working with data including analyzing mapping and integration within complex enterprise environments including data modelling lineage and transformation as well as applying data governance frameworks to support standardized analytics-ready datasets. Skill Set Requirements: Mandatory Requirements 1. Business Analysis Experience Minimum 8 years as a Business Analyst supporting medium to large enterprise projects. At least 5 years leading end-to-end requirements across business functional data and reporting domains. Experience with: Requirements traceability gap analysis and change impact assessment Agile delivery tools (e.g. Azure DevOps JIRA) 2. Data Management & Governance: Minimum 5 years applying data management frameworks in complex environments including: Data lifecycle and governance Metadata management and data quality Experience supporting standardized controlled data practices across enterprise systems. 3. Data Analysis Mapping & Integration: Strong experience (5 years) in: Analyzing and documenting data structures flows and lineage End-to-end data mapping and validation rules Knowledge of enterprise data architecture and integration patterns including: Data pipelines and interoperability Impacts to analytics reporting and downstream use Desired Skills and Experience: 1. Business & Data Requirements: Lead end-to-end requirements gathering across ministry and justice partners. Document and validate: Business functional non-functional data integration and reporting requirements User stories acceptance criteria and business rules Ensure requirements are clear prioritized and aligned with data acquisition and governance objectives. 2. Data Analysis Modelling & Mapping: Analyze current-state (including non-relational) data and document key elements. Define target relational data structures including: Entities relationships and normalized tables Primary and foreign keys aligned to business domains Develop: Source-to-target mappings (column-level) Transformation logic (analytics-ready / SQL-ready) End-to-end data traceability 3. Process Data Flow & Integration: Produce core artifacts: Process maps and workflows Data flow diagrams and data models Integration and interface requirements Identify data flows integration points and system dependencies. Support solution design by ensuring requirements are feasible and aligned with architecture. 4. Data Standards Governance & Quality: Develop and maintain: Data definitions business rules and data dictionary Naming conventions and metadata standards Align deliverables with ministry data governance frameworks. Support design of data management processes (intake validation quality controls). Maintain requirements traceability and support validation to ensure datasets are accurate complete and analytics ready. Business Analysis & Delivery: Proven experience leading business analysis activities on large complex multi-stakeholder digital projects. Strong ability to translate business needs into clear structured and actionable requirements. Experience producing key BA artifacts including: Business and functional requirements Process maps and workflows Data flow diagrams and specifications Experience working in Agile delivery environments (Scrum/Kanban) using tools such as Azure DevOps or JIRA. Data Analysis & Technical Knowledge: Solid understanding of relational data modeling and data warehousing concepts. Knowledge of data transformation processes (ETL/ELT) and analytics-ready dataset design. Experience defining business rules and data logic to support reporting and analysis. Familiarity with: Enterprise data platforms (e.g. Azure Databricks) Relational databases (e.g. Oracle Azure SQL) Understanding of large datasets data structures and integration concepts. Data Governance & Quality: Knowledge of data governance principles including: Data quality and validation Metadata management and data standards Experience supporting standardized data definitions and consistent data practices across systems. Communication & Facilitation: Strong communication and documentation skills with the ability to tailor messaging to technical business and executive audiences. Proven facilitation skills to lead workshops and discussions with diverse stakeholder groups. Ability to synthesize complex information into clear and concise outputs. Professional Attributes: Strong analytical and problem-solving skills. Ability to work independently and collaboratively in fast-paced multi-stakeholder environments. High attention to detail and commitment to quality. Sector Knowledge (Asset): Experience or familiarity with justice policing or corrections data is an asset. Business Analyst Skills: Proven experience leading business analysis activities on large complex multi-stakeholder digital projects. Strong ability to translate business needs into clear structured and actionable requirements. Experience producing key BA artifacts including: Business and functional requirements Process maps and workflows Data flow diagrams and specifications Experience working in Agile delivery environments (Scrum/Kanban) using tools such as Azure DevOps or JIRA. Ability to work independently and collaboratively in fast-paced multi-stakeholder environments. Technical & Data Skills: Solid understanding of relational data modeling and data warehousing concepts. Knowledge of data transformation processes (ETL/ELT) and analytics-ready dataset design. Experience defining business rules and data logic to support reporting and analysis. Familiarity with: Enterprise data platforms (e.g. Azure Databricks) Relational databases (e.g. Oracle Azure SQL) Understanding of large datasets data structures and integration concepts. Knowledge of data governance principles including: Data quality and validation Metadata management and data standards Experience supporting standardized data definitions and consistent data practices across systems. Strong analytical and problem-solving skills. High attention to detail and commitment to quality. Communication Skills: Strong communication and documentation skills with the ability to tailor messaging to technical business and executive audiences. Proven facilitation skills to lead workshops and discussions with diverse stakeholder groups. Ability to synthesize complex information into clear and concise outputs. Public Sector Experience: Previous experience working in Government or Public Sector organizations. Experience or familiarity with justice policing or corrections data is an asset.

Employment Type : Full Time
Experience: years
Vacancy: 1