senior business analyst.

We are seeking a highly accomplished Senior Business Analyst for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier analytical and data governance capacity, specializing in the design, modeling, and delivery of enterprise data warehouse platforms and digital data modernization initiatives.

As a principal business analyst, you will bridge the gap between complex operational business units and data engineering squads. Operating on-site, you will lead end-to-end requirements elicitation, construct detailed source-to-target data mappings, define transformation logic, and enforce strict data governance rules. This position demands a well-rounded expert who can confidently model relational structures, produce clear data dictionaries, and ensure the delivery of high-quality, analytics-ready datasets.

Location: Toronto, ON

Assignment Type: Onsite (5 days per week)

Contract Duration: 12 months

Advantages
High-Impact Data Architecture: Lead end-to-end requirements for enterprise data warehouse modernizations and large-scale data acquisition channels.

Advanced Technical Depth: Gain hands-on exposure to column-level data mapping, relational database modeling, and ETL/ELT transformation logic.

Full-Lifecycle Ownership: Drive requirements from early stakeholder discovery through process mapping, data dictionary design, and Agile release loops.

Onsite Collaboration: Work directly alongside cross-functional engineering teams, solution architects, and executive leaders in a focused, hands-on environment.

Responsibilities
Lead end-to-end business, functional, non-functional, data, integration, and reporting requirements gathering across diverse stakeholder networks.

Translate complex operational needs into clear Agile user stories, explicit feature acceptance criteria, business rules, and detailed requirements traceability matrices.

Analyze current-state relational and non-relational datasets to document data elements, lineage, and structural dependencies.

Define target relational structures, including entities, normalized table relationships, and primary/foreign key mappings aligned with core business domains.

Develop column-level source-to-target mappings, SQL-ready transformation logic, and end-to-end data lineage specifications.

Author core architectural artifacts, including business process maps, workflows, data flow diagrams, and integration interface specs.

Establish and maintain master data dictionaries, standardized data definitions, metadata guidelines, and naming conventions aligned with enterprise data governance frameworks.

Design and enforce data management validation processes, intake workflows, and quality controls to guarantee completeness and analytics readiness.

Collaborate with data engineering and architecture teams to ensure functional requirements are feasible and structurally aligned with target cloud platforms.

Facilitate stakeholder workshops, design reviews, and requirements alignment sessions across multi-disciplinary project groups.

Qualifications
Core Business Analysis & Technical Requirements
Professional BA Tenure: 8+ years of experience as a Business Analyst supporting medium-to-large enterprise digital projects.

End-to-End Requirements Leadership: 5+ years leading comprehensive requirements elicitation across business, functional, data, and reporting domains.

Data Management & Governance: 5+ years applying data management, metadata, data quality, and data lifecycle governance frameworks within complex environments.

Data Modeling & Integration Depth: 5+ years analyzing data structures, mapping column-level transformations, establishing data lineage, and defining validation rules.

Agile Tooling Mastery: High proficiency using Agile tools such as Azure DevOps or Jira within Scrum or Kanban frameworks.

Data Architecture Knowledge: Strong understanding of relational data modeling, data warehousing concepts, ETL/ELT transformation pipelines, and enterprise data platforms (such as Azure, Databricks, Oracle, or Azure SQL).

Preferred Assets & Domain Attributes
Public Sector & Domain Context: Experience working within public sector environments, with familiarity in company, policing, or corrections data domains considered a strong asset.

Clearance Status: Active OPP Level 4 clearance (or eligibility to attain clearance prior to engagement start) is mandatory.

Soft Skills & Leadership
Consultative Facilitation: Outstanding verbal, written, and presentation skills, with a proven ability to tailor technical concepts for business, engineering, and executive audiences.

Analytical Problem Solving: Superior analytical reasoning, critical thinking, and attention to detail to synthesize complex, multi-layered data structures.

Independent Execution: Strong ability to operate both independently and collaboratively in fast-paced, multi-stakeholder delivery environments.

Summary
If you're interested in the "Senior Business Analyst" role based in Toronto, we encourage you to apply online at Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to View email address on randstad.com to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies. show more