We are seeking a highly accomplished, data-focused Senior Business Analyst to drive foundational system analysis, data modeling, and requirements engineering for an enterprise data warehouse/lakehouse modernization initiative. In this role, you will bridge the gap between core business units and technical data migration squads, ensuring legacy operational assets are accurately mapped, cleaned, and integrated into modern cloud-ready reporting structures. Operating across both Agile and Waterfall methodologies, you will take hands-on ownership of translating complex stakeholder workflows into detailed technical data specifications, process maps, and business intelligence solutions.
...
Location: Toronto, ON (Fully Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)
Duration: 4-month contract.
Advantages
High-Impact Architecture Specialization: Command deep functional experience shaping modern data lakehouse structures, advanced ETL workflows, and enterprise Power BI pipelines.
Diverse Framework Mastery: Maximize your project delivery profile by executing complex, multi-tiered deliverables across tight hybrid Agile and Waterfall constraints.
Deep Structural Autonomy: Act as the definitive analytical lead defining the business rules, logical data shapes, and interface criteria for a major organizational modernization program.
Stable Daytime Operations: Benefit from a highly consistent, reliable daytime onsite footprint within a structured public sector professional landscape.
Responsibilities
Data Lakehouse & BI Analysis: Lead comprehensive business and system analysis to design the semantic data layer (golden layer) of a modern data lakehouse and drive the rollout of modernized Power BI dashboards.
MVP Scope Definition & Gap Analysis: Champion the effort to define the reporting Minimum Viable Product (MVP), comprehensively audit and document legacy reporting structures, conduct rigorous gap analyses, and deliver strategic technical recommendations.
Agile Requirements Engineering: Author highly detailed, structured user stories and acceptance criteria within Azure DevOps, ensuring requirements mapping aligns completely with corporate digital standards across varying project phases.
Cross-Functional Liaison: Act as the principal translation authority between non-technical Business Areas and the core data migration/reporting engineering squads to distill operational pain points into explicit functional requirements.
Advanced Data & Process Modeling: Formulate robust analytical blueprints, including conceptual and logical data models, detailed process/data flow diagrams, use case surveys, screen specifications, data migration rules, and non-functional requirements definitions.
Data Quality & Triage Governance: Diagnose, isolate, and address systemic data quality anomalies, orchestrate end-to-end data reconciliation, define test scripts, and build target KPIs to track the progress and structural completeness of the migration track.
Post-Migration Support & Lifecycle Tuning: Provide high-tier operational support post-migration, resolving complex data-related dependencies, and delivering structured user and system documentation to allow smooth future platform support.
Qualifications
Core Business Analysis Seniority: Minimum of 10+ years of progressive professional experience leading business and system analysis, assessing enterprise system blockers, and documenting detailed requirements to guide downstream technical execution.
Hybrid Methodology Delivery: Proven, verified experience operating successfully under both Agile (Scrum) and Waterfall project management methodologies.
Data Warehousing & BI Acumen: Demonstrated mastery conducting structural business analysis specifically focused on building data marts, data warehouses, data lakehouses, or enterprise Business Intelligence and analytics reporting solutions.
Complex Data Migration Background: Proven professional track record working as a core Business Analyst navigating large-scale, high-risk, and multi-tiered data migration initiatives.
Agile Management Toolchain Literacy: Hands-on experience writing agile user stories, mapping acceptance conditions, and managing backlogs within DevOps environments.
Data Manipulation & Query Literacy: Foundational command of SQL with the practical capability to execute database queries, validate data tables, and interpret underlying data cleansing/ETL concepts.
Enterprise Platform Awareness: Technical exposure or functional analysis familiarity dealing with central ERP/CRM architectures, specifically Microsoft Dynamics 365 (CE, F&O) or similar large-scale software solutions.
Quality Assurance & Defect Handling: Demonstrated background creating test plans, tracking execution scripts, performing data reconciliation matrices, and managing structured defect logging and resolution workflows.
Soft Skills: Elite critical thinking, verbal, and written communication skills, with an established history of managing multi-stakeholder expectations and translating abstract data specifications into clear actionable designs.
Summary
If you're interested in the "Senior Business Analyst" role based in Toronto, we encourage you to apply online at www.randstad.ca. 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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
We are seeking a highly accomplished, data-focused Senior Business Analyst to drive foundational system analysis, data modeling, and requirements engineering for an enterprise data warehouse/lakehouse modernization initiative. In this role, you will bridge the gap between core business units and technical data migration squads, ensuring legacy operational assets are accurately mapped, cleaned, and integrated into modern cloud-ready reporting structures. Operating across both Agile and Waterfall methodologies, you will take hands-on ownership of translating complex stakeholder workflows into detailed technical data specifications, process maps, and business intelligence solutions.
Location: Toronto, ON (Fully Onsite, 7.25 hours per day between 8:00 AM and 5:00 PM)
Duration: 4-month contract.
Advantages
High-Impact Architecture Specialization: Command deep functional experience shaping modern data lakehouse structures, advanced ETL workflows, and enterprise Power BI pipelines.
Diverse Framework Mastery: Maximize your project delivery profile by executing complex, multi-tiered deliverables across tight hybrid Agile and Waterfall constraints.
...
Deep Structural Autonomy: Act as the definitive analytical lead defining the business rules, logical data shapes, and interface criteria for a major organizational modernization program.
Stable Daytime Operations: Benefit from a highly consistent, reliable daytime onsite footprint within a structured public sector professional landscape.
Responsibilities
Data Lakehouse & BI Analysis: Lead comprehensive business and system analysis to design the semantic data layer (golden layer) of a modern data lakehouse and drive the rollout of modernized Power BI dashboards.
MVP Scope Definition & Gap Analysis: Champion the effort to define the reporting Minimum Viable Product (MVP), comprehensively audit and document legacy reporting structures, conduct rigorous gap analyses, and deliver strategic technical recommendations.
Agile Requirements Engineering: Author highly detailed, structured user stories and acceptance criteria within Azure DevOps, ensuring requirements mapping aligns completely with corporate digital standards across varying project phases.
Cross-Functional Liaison: Act as the principal translation authority between non-technical Business Areas and the core data migration/reporting engineering squads to distill operational pain points into explicit functional requirements.
Advanced Data & Process Modeling: Formulate robust analytical blueprints, including conceptual and logical data models, detailed process/data flow diagrams, use case surveys, screen specifications, data migration rules, and non-functional requirements definitions.
Data Quality & Triage Governance: Diagnose, isolate, and address systemic data quality anomalies, orchestrate end-to-end data reconciliation, define test scripts, and build target KPIs to track the progress and structural completeness of the migration track.
Post-Migration Support & Lifecycle Tuning: Provide high-tier operational support post-migration, resolving complex data-related dependencies, and delivering structured user and system documentation to allow smooth future platform support.
Qualifications
Core Business Analysis Seniority: Minimum of 10+ years of progressive professional experience leading business and system analysis, assessing enterprise system blockers, and documenting detailed requirements to guide downstream technical execution.
Hybrid Methodology Delivery: Proven, verified experience operating successfully under both Agile (Scrum) and Waterfall project management methodologies.
Data Warehousing & BI Acumen: Demonstrated mastery conducting structural business analysis specifically focused on building data marts, data warehouses, data lakehouses, or enterprise Business Intelligence and analytics reporting solutions.
Complex Data Migration Background: Proven professional track record working as a core Business Analyst navigating large-scale, high-risk, and multi-tiered data migration initiatives.
Agile Management Toolchain Literacy: Hands-on experience writing agile user stories, mapping acceptance conditions, and managing backlogs within DevOps environments.
Data Manipulation & Query Literacy: Foundational command of SQL with the practical capability to execute database queries, validate data tables, and interpret underlying data cleansing/ETL concepts.
Enterprise Platform Awareness: Technical exposure or functional analysis familiarity dealing with central ERP/CRM architectures, specifically Microsoft Dynamics 365 (CE, F&O) or similar large-scale software solutions.
Quality Assurance & Defect Handling: Demonstrated background creating test plans, tracking execution scripts, performing data reconciliation matrices, and managing structured defect logging and resolution workflows.
Soft Skills: Elite critical thinking, verbal, and written communication skills, with an established history of managing multi-stakeholder expectations and translating abstract data specifications into clear actionable designs.
Summary
If you're interested in the "Senior Business Analyst" role based in Toronto, we encourage you to apply online at www.randstad.ca. 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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
