Senior Business Analyst
On-siteBay Street Corridor, Ontario, Canada
Job Summary
Lead end-to-end requirements gathering across business, functional, and data domains for a large-scale data warehouse initiative. Document and validate business rules, define target-state relational structures, and develop source-to-target mappings while ensuring alignment with enterprise architecture. Create process maps, data flow diagrams, and integration requirements to support solution design and data standardization programs. Maintain requirements traceability, validate analytics-ready datasets, and transfer knowledge through comprehensive documentation and stakeholder engagement. Note: OPP Level 4 clearance is required prior to starting.
Required Qualifications
- OPP Level 4 Clearance
- Minimum 8 years of experience as a Business Analyst supporting medium to large enterprise projects
- Minimum 5 years leading end-to-end requirements across business, functional, data, and reporting domains
- Experience with requirements traceability, gap analysis, change impact assessments, and Agile delivery tools such as Azure DevOps and JIRA
- Minimum 5 years of experience applying data management frameworks within complex enterprise environments
- Experience with data lifecycle management, governance, metadata management, and data quality practices
- Experience supporting standardized enterprise data practices
- Minimum 5 years of experience analyzing and documenting data structures, flows, and lineage
- Experience performing end-to-end data mapping and defining validation rules
- Knowledge of enterprise integration patterns, data pipelines, interoperability frameworks, and reporting impacts of data movement
- Extensive senior-level Business Analysis experience (8+ years)
- Expertise in requirements gathering, traceability, gap analysis, and Agile delivery methodologies
- Strong data management, integration, mapping, governance, and data lineage experience
- Experience working with complex enterprise-scale data initiatives and analytics-ready data environments
Desired Qualifications
- Proven experience leading business analysis activities for large-scale, complex initiatives
- Strong ability to translate business needs into actionable requirements
- Experience producing business requirements, functional requirements, process maps, workflows, data flow diagrams, and technical specifications
- Experience working within Agile environments utilizing Scrum or Kanban methodologies
- Strong understanding of relational data modelling and data warehousing concepts
- Knowledge of ETL/ELT processes and analytics-ready dataset design
- Experience defining business rules and data logic for reporting and analytics
- Familiarity with Azure, Databricks, Oracle, and Azure SQL
- Experience working with large datasets and enterprise integrations
- Knowledge of data quality management, validation processes, metadata management, and enterprise data standards
- Experience supporting consistent and standardized data practices across organizations
- Strong communication and documentation skills
- Proven workshop facilitation and stakeholder engagement skills
- Ability to present complex information clearly to both technical and non-technical audiences
- Strong analytical and problem-solving abilities
- Ability to work independently and collaboratively
- Strong attention to detail and commitment to quality
- Experience within government or public sector environments
- Familiarity with justice, policing, corrections, or data-intensive public sector environments
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.