Data Engineer — Pipelines, SQL & Cloud Cost Optimization

Gestion Zagora; Westmount; On-site; CAD 85,000 - 125,000; Full time

Job summary

Gestion Zagora in Montreal is seeking a Data Engineer to join the Data Strategy & Innovation team. You will work with finance, data and software engineers and get real work from month one.

You will optimize GCP spend, refactor the data warehouse, maintain CI/CD deployments, support KPI reporting, monitor data quality, and assist ERP migration. This role offers growth toward senior data/analytics engineering as you develop domain ownership.

Qualifications

• Solid Python skills, OOP and pandas; write clean code.
• Proficient SQL with joins, window functions and CTEs.
• Some exposure to cloud platforms; GCP preferred; BigQuery a plus.
• Good understanding of REST APIs and reading unfamiliar docs.
• GCP IAM and ability to scope permissions responsibly.
• Bonus: Apps Script or Google Sheets automation; dashboards experience.

Responsibilities

• Cost. Help optimize GCP spend by identifying costly queries and proposing fixes.
• Refactor and consolidate warehouse tables with partitioning and clustering.
• Ship through CI/CD; own deployments of apps and data pipelines and ensure reports are on time.
• Support reporting and analysis; maintain KPI reporting across Finance, Asset Management, Operations, Accounting, Leasing.
• Monitor pipeline health and data quality; surface cost anomalies and read billing data.
• Assist ERP migration: extraction, validation, and reconciliation work.

Skills

Python

SQL

Pandas

BigQuery

GCP

REST APIs

Apps Script

Tools

Google Sheets

CI/CD

ETL pipelines

Job description

Gestion Zagora in Montreal is seeking a Data Engineer to join the Data Strategy & Innovation team. You will work with finance, data and software engineers and get real work from month one.

You will optimize GCP spend, refactor the data warehouse, maintain CI/CD deployments, support KPI reporting, monitor data quality, and assist ERP migration. This role offers growth toward senior data/analytics engineering as you develop domain ownership.