Senior Data Engineer – Google Cloud

Role Overview

• Demonstrate deep knowledge of the data engineering domain to build and support non-interactive (batch, distributed) & real-time, highly available data pipelines
• Build fault-tolerant, self-healing, adaptive, and highly accurate data computational pipelines
• Provide consultation and lead the implementation of complex programs
• Develop and maintain documentation relating to all assigned systems and projects
• Tune queries running over billions of rows of data running in a distributed query engine
• Perform root cause analysis to identify permanent resolutions to software or business process issues
• Implement and maintain dbt transformation models, CI pipelines, and data contracts for curated campaign, ad group, keyword, audience, and landing-page marts.
• Build and monitor data quality gates (Great Expectations and reconciliation checks) and freshness SLOs.
• Optimize BigQuery cost and performance using query tuning, storage design, and reservation strategy.
• Implement platform hardening controls including retries, dead-letter queues, DR runbooks, and support for VPC-SC and DLP validation.

Requirements

• Strong expertise in: Python
• for building data pipelines, processing tasks, and automation
• SQL
• Advanced SQL capabilities (nested fields, analytic functions).
• Hands-on experience with Core GCP Data Stack:
• BigQuery: Expert-level SQL, performance tuning, and specifically BigQuery for advanced SQL, performance tuning, partitioning and clustering strategy, and production-grade curated marts and feature tables; working knowledge of BQML for scoring and evaluation in analytics workflows.
• Dataflow (Apache Beam)
• Strong proficiency in building reliable batch and incremental pipelines for GA4/Google Ads data into BigQuery, with streaming patterns (windowing/watermarks/triggers) used when near-real-time alerting is required.
• Pub/Sub: Experience with event-driven architecture and message queuing.
• Hands-on experience with Visualization & BI:
• Looker Core – Advanced proficiency in LookML (not just drag-and-drop), including derived tables, explores, and Liquid syntax.
• Semantic Modeling: Develop robust LookML models to create a trusted layer of data governance, ensuring metrics are consistent across the organization.
• Dashboard Creation: Design intuitive, high-impact dashboards in Looker for two distinct audiences: Operational teams (paid search performance monitoring, anomaly triage, and optimization workflows) and Executives (ROAS, conversion efficiency, budget pacing, and channel contribution reporting).
• Ability to independently own workstreams while collaborating closely with data science, analytics, and engineering peers in agile delivery.
• Advanced English skills.

Tech Stack

• Apache
• BigQuery
• Google Cloud Platform
• Python
• SQL

Benefits

• A comprehensive insurance plan, where you can choose the module that best suits your needs—Gold, Silver, or Bronze. The employer may contribute up to 80% of your coverage depending on the selected module. This plan includes short
• and long-term disability coverage.
• Dialogue via Sun Life provides virtual healthcare services, allowing you to consult with a healthcare professional for emergencies, prescription renewals, and more. You also have access to the Employee and Family Assistance Program, as well as a complete mental health support program.
• A $500 Personal Spending Account, which can be used for healthcare reimbursements, gym memberships, public transit passes, office supplies, or contributions to your RRSP through Valtech.
• A retirement plan where Valtech will match 100% of your RRSP contributions through a Deferred Profit Sharing Plan (DPSP), up to a maximum of 4%. You can start contributing to your RRSP immediately, and to the DPSP after 3 months. The vesting of the DPSP will be after a 24 months of service.
• Access to a flexible vacation under Valtech's policy to support your work-life balance, with 5 days available during your probation period and a prorated amount calculated for the remainder of the year.
• Personal Technology Reimbursement – $30/month for every employee-offered on day 1.
• We close during the winter holidays and offer flexible scheduling throughout the year, so you can enjoy those sunny Friday afternoons—provided your weekly hours are completed.