Analyst jobs in Canada

Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.

We currently have a multiple, re-extendable, long term contract roles as a GCP Data Lead - Hybrid with our global SAP consulting client, working onsite at large CPG/Entertainment client's office 2-3 days a week in downtown Toronto. This is a 6 month contract initially, but will be extended long term.

GCP Data Lead - Hybrid

Type: Contract

# of Roles: 1

Duration: 9-12 months to start + possible extensions

Location: Toronto, ON - Hybrid, 2-3 days onsite in downtown Toronto

Rate: Open based on expectations as a C2C contractor

We are seeking a highly skilled Google Cloud Platform (GCP) Data Lead with strong SAP data integration expertise to design, implement, and oversee enterprise-grade data solutions. The ideal candidate will combine deep expertise in cloud data platforms, data governance, security, and data modeling with hands‑on experience in ETL/ELT pipelines, SAP data extraction, system migrations, and analytics. This role will collaborate with business stakeholders, and engineering teams to create a robust, scalable, and cost‑effective data ecosystem that bridges SAP and GCP environments.

1. Mentoring
   • Lead and mentor a team of data engineers in building ETL/ELT pipelines for SAP and other ERP sources into GCP
   • Set engineering standards, best practices, and coding guidelines.
2. Provide technical direction, code reviews, and support for complex data solutions.
   • Collaborate with project managers, provide the estimates, track the progress, remove roadblocks to ensure timely completion of work.
   • Collaborate with BI teams, Data analyst to enable reporting solution.

• Design conceptual, logical, and physical data models to support analytics and operational workloads.
• Implement star, snowflake, and data vault models for analytical systems.

• Design data solutions on GCP using BigQuery, Cloud Storage, Dataflow, and Dataproc.
• Implement cost optimization strategies for GCP workloads.

• Design and orchestrate ETL/ELT pipelines using Apache Airflow (Cloud Composer), and Dataflow.
• Integrate data from multiple systems including SAP BW, SAP HANA, Business Objects using tools like SAP SLT, or Google Cortex Framework.
• Leverage integration tools such as Boomi for system interoperability.

• Develop complex SQL queries for analytics, transformations, and performance tuning.
• Build automation scripts and utilities in Python.

• Lead on‑premise to cloud migrations for enterprise data platforms [SAP BW/Bobj].
• Manage migration of SAP datasets to GCP ensuring data integrity and minimal downtime.

• Implement CI/CD pipelines for data workflows using GitHub Actions, Cloud Build, and Terraform.
• Apply infrastructure‑as‑code principles for reproducible and scalable deployments.

• 8+ years of proven experience with GCP BigQuery, Composer, Cloud Storage, Pub/Sub, Dataflow.
• Min 2–3 years of leadership experience in mentoring small to mid‑size data engineering team.
• Strong SQL and Python programming skills.
• Hands‑on experience with SAP data extraction, modeling, and integration from ERP, BW, and/or HANA systems.
• Knowledge of data governance frameworks and security best practices.
• Familiarity with DevOps tools for data.
• Understanding of Google Cortex Framework for SAP‑GCP integrations.