SAP Business Warehouse Development Specialist

We are seeking a highly accomplished SAP Business Warehouse Development Specialist for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier data architecture, ETL engineering, and SAP analytics capacity, specializing in designing, modernizing, and scaling enterprise data warehousing solutions across cloud and on-premises environments.

As an SAP Business Warehouse Development Specialist, you will bridge the gap between legacy data platforms, modern cloud analytics solutions, and business intelligence reporting. Operating within a hybrid work model in Toronto, you will lead the evolution of enterprise data platforms, design scalable data models in SAP Datasphere, optimize ETL process flows, and configure secure data pipelines connecting SAP and non-SAP source systems. This position demands a technical data authority with extensive experience in SAP BW/4HANA, Datasphere, BDC, SAC, and advanced SQL scripting who can drive platform modernization, establish governance controls, and deliver high-performance reporting structures.

Location: Toronto, ON

Assignment Type: Hybrid (3 days per week onsite, with Wednesday/Thursday anchor days)

Contract Duration: 6-month contract (with potential for 6-month extension)

Advantages
Cutting-Edge SAP Cloud Ecosystem: Lead data modernization using SAP Datasphere, SAP Analytics Cloud (SAC), and BW/4HANA platforms.

Complex Data Integration Scope: Architect multi-environment data flows connecting on-premises systems and cloud infrastructures using SDI, SDA, SLT, and ODP frameworks.

Full-Lifecycle Data Ownership: Own end-to-end delivery—from requirements gathering and dimensional data modeling to production cutover and operational hypercare.

Predictable Hybrid Setup: Enjoy a balanced working structure combining collaborative onsite teamwork in Toronto with remote work days.

Responsibilities
Analyze existing data warehouse architectures, translate complex reporting requirements into scalable data structures, and design dimensional data models.

Build, configure, and evolve cloud data products, semantic models, and analytical consumption views within SAP Datasphere, BDC, and SAP Analytics Cloud (SAC).

Design and implement data extraction, transformation, and loading (ETL/ELT) processes, including real-time replication flows, process chains, and task chains.

Develop and optimize complex SQL scripts, stored procedures, table functions, and Core Data Services (CDS) views for embedded analytics.

Architect secure data interfaces and replication flows between on-premises and cloud environments utilizing SDI, SDA, ODP frameworks, and REST/SOAP APIs.

Manage, configure, and secure spaces, source system connections, role-based access controls, and object privileges across the cloud data landscape.

Support modernization initiatives, system upgrades, readiness checks, and migration activities connecting legacy BW environments to modern cloud platforms.

Perform data validation, reconciliation, performance tuning, and quality assurance to ensure consistency across enterprise reporting environments.

Provide production operational support, monitoring data loads, resolving incidents, and managing SLA commitments during critical business cycles.

Author comprehensive technical design specifications, process flow diagrams, deployment guidelines, solution runbooks, and RFP technical scoping documentation.

Qualifications
Core Technical & SAP Data Warehousing Requirements
SAP BW & HANA Tenure: Minimum 10+ years of hands-on experience in SAP BW/HANA projects, including data architecture, dimensional modeling, ETL, and enterprise reporting.

Advanced BW Objects: Extensive experience working with Advanced DSOs (ADSOs), Open ODS Views, Composite Providers, and Core Data Services (CDS) views.

SAP Datasphere & Cloud Analytics: Demonstrated expertise designing data models, graphical views, replication flows, and semantic layers within SAP Datasphere and SAP Analytics Cloud (SAC).

Integration Frameworks: Hands-on experience integrating SAP source systems (S/4HANA, ECC, Ariba, SuccessFactors) and non-SAP sources using SDI, SDA, SLT, ODP, and APIs.

SQL & Database Scripting: Advanced proficiency in writing complex SQL scripts, stored procedures, and table functions for performance-optimized data flows.

Education: University degree in Computer Science, Information Technology, or a related discipline (or equivalent combination of education and experience).

Preferred Experience & Governance Assets
System Modernization & Migration: Proven track record in BW system upgrades, greenfield/brownfield implementations, and cloud migration frameworks.

Security & Governance: Experience implementing security frameworks, data governance practices, and role-based access controls (RBAC) in SAP environments.

Agile Tooling: Experience working within Agile or hybrid project delivery frameworks utilizing Jira, Confluence, or Solution Manager.

Soft Skills & Delivery Attributes
Analytical Problem Solving: Superior troubleshooting, diagnostic, and performance optimization skills to resolve complex data flow errors under tight timelines.

Communication & Collaboration: Excellent written and verbal communication skills with a proven ability to author detailed technical specifications and conduct knowledge transfer sessions.

Summary
If you're interested in the "SAP Business Warehouse Development Specialist" 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 [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.