senior business analyst.

We are seeking a highly sophisticated, data-centric Senior Business Analyst to join the Support and Data Migration team for the Office of the Public Guardian and Trustee (OPGT) Modernization program. In this strategic role, you will lead the business and systems analysis required to build the refined "Golden Layer" of a modern Microsoft Azure data lakehouse and deliver a modernized Business Intelligence (BI) reporting platform. Acting as the critical liaison between operational business units and the core data engineering squad, you will translate data migration workflows and transactional information from enterprise ERP/CRM systems into clear reporting specifications, data schemas, and Agile user stories.

Location: Toronto, ON (Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)

Duration: 10-month contract (aligned with VOR framework timelines)

Advantages
High-Impact Data Modernization: Command a highly visible analysis portfolio driving the data governance and reporting transformation for a massive public service program.

Deep Cloud & ERP Visibility: Broaden your technical marketability by architecting data pipelines extracted out of integrated tier-1 platforms (D365 CE/F&O) into advanced Azure Synapse or Lakehouse golden layers.

Strategic Autonomy: Own the reporting roadmap completely, directly shaping executive-level decision dashboards from initial user story capture up to production launch.

Stable Daytime Framework: Benefit from a highly reliable, predictable daytime schedule within a structured, collaborative corporate office in downtown Toronto.

Responsibilities
BI Strategy & MVP Definition: Lead the structural scoping and definition of the reporting Minimum Viable Product (MVP). Inventory and audit legacy reports, conduct deep gap analyses, and deliver formal future-state recommendations.

Requirements Architecture: Elicit, elaborate, and translate complex business data requirements into technical system specifications, reporting definitions, screen layouts, and backend migration rules.

Agile Backlog Engineering: Document reporting and migration requirements as actionable user stories and acceptance criteria within Azure DevOps, managing feature prioritization across sprints.

Advanced Data Modeling & Mapping: Conduct multidimensional business modeling, process mapping, data flow diagramming (DFDs), and conceptual-to-logical data modeling optimized for data warehouse/lakehouse topologies.

Cross-Functional Liaison: Bridge the communication gap between non-technical business area stakeholders, database developers, ETL engineers, and QA testing teams.

Data Quality & Reconciliation: Identify and address data quality anomalies, define data profiling rules, formulate test cases, and perform complex data reconciliations to guarantee the accuracy and integrity of migrated data assets.

Quality Assurance & Defect Governance: Participate actively in defect management workflows—identifying, logging, and tracking anomalies from discovery through to regression validation using industry-standard QA practices.

Analytics Implementation Support: Assist in building robust KPIs and tracking metrics to monitor the velocity, completeness, and overarching quality of the data migration pipeline.

Post-Implementation Hypercare: Provide critical post-migration support, clarify data schema questions for operational teams, and offer expert insights to continuously optimize data management processes in the new environment.

Qualifications
Core Seniority: 10+ years of progressive professional experience leading business and systems analysis for large-scale, complex IT environments.

Enterprise Analytics Blueprinting: Proven experience defining business logic and functional rules for data marts, data warehouses, enterprise lakehouses, or big data analytics initiatives.

Dynamics 365 Domain Expertise: Direct experience conducting business and system analysis for Microsoft Dynamics 365 Customer Engagement (CE) and/or Finance & Operations (F&O) backend data structures.

Methodological Flexibility: Deep fluency in both Agile/Scrum and traditional Waterfall project delivery frameworks, with a distinct emphasis on scaling Agile practices.

Technical Data Proficiency: Working knowledge of relational databases with a demonstrated ability to write and execute SQL queries to profile data and audit source-to-target mapping.

ETL & Data Governance Acumen: Strong conceptual understanding of extract, transform, and load (ETL) pipelines, data cleansing patterns, data privacy boundaries, and error-handling routines.

Visual Dashboards Familiarity: Functional familiarity with reporting and visualization suites, specifically Power BI.

Governance Compliance: Experience operating within structured corporate frameworks, security protocols, and strict documentation standards (ideally aligned with public sector guidelines).

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