Job Description

Toronto

Role Description:

Migration Strategy Planning

Define the overall migration roadmap from SAP BW to BigQuery.

Assess current BW landscape, data models, and ETL processes.

Develop a detailed migration plan, including timelines, risk mitigation, and resource requirements.Architecture Design

Design the target architecture on GCP, ensuring scalability, performance, and security.

Define data modeling standards for BigQuery aligned with business requirements.

Ensure integration with SAP S4HANA, SAP Data Services, and other enterprise systems.

Execution Delivery

Lead the migration of data models, reports, and analytics from BW to BigQuery.

Oversee ETLELT pipeline development using tools like SAP Data Services, Google Dataflow, or Cloud Composer.

Validate data accuracy, performance, and compliance post-migration.

Stakeholder Management

Collaborate with business teams, data analysts, and IT leadership to ensure alignment.

Provide technical guidance and mentorship to project teams.

Governance Optimization

Implement best practices for data governance, security, and cost optimization in BigQuery.

Monitor and optimize query performance and storage costs.

Essential Skills:

SAP Expertise

10 years of experience in SAP BW architecture, data modeling, and performance tuning.

Strong understanding of SAP ECCS4 integration with BW.Cloud BigQuery3 years of experience with Google Cloud Platform (GCP) and BigQuery.

Knowledge of GCP services like Cloud Storage, Dataflow, PubSub, and IAM.

Data Engineering

Proficiency in ETL, ELT tools and SQL.

Experience with data migration strategies and tools.

Leadership

Proven track record of leading large-scale data migration projects.

Excellent communication and stakeholder management skills.