Build GCP-native data pipelines with SQL and Python as an Intermediate Data Engineer at Clever Digital Marketing, working remotely within Canada. Support advertising operations through reliable production data systems. This Intermediate Data Engineer builds and maintains ELT pipelines within Data Platform 2.0. You will use BigQuery, Cloud Run, Cloud Functions, and Pub/Sub while integrating advertising, CRM, call tracking, and lead event data. The role delivers transformation logic and trusted datasets for reporting and AI/ML consumers.

Key Responsibilities
- Build ELT pipelines from Google Ads, Meta Ads, and Microsoft Ads APIs
- Maintain Bronze ingestion with audit trails and reliable failure handling
- Develop BigQuery models using dimensional modeling fundamentals




- Automate workflows with SQL, Python, and GCP services
- Monitor pipeline health and resolve data discrepancies at root cause

Requirements:
- Two to four years of production data engineering experience
- Solid SQL and working Python proficiency
- Hands-on BigQuery or equivalent cloud warehouse experience
- Practical REST and OAuth2 API integration experience
- Working GCP or equivalent cloud experience with Git habits Bring production pipeline ownership, BigQuery modeling, and cloud engineering skills to Clever Digital Marketing’s advertising data platform.

📌 Intermediate GCP Data Engineer (Canada)
🏢 Clever Digital Marketing
📍 Canada