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.

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonSQLBigQueryDataflowLookMLGA4Pub/Subdata pipelinesdata transformationdata quality

Soft Skills

consultationleadershipdocumentationroot cause analysiscollaborationindependencecommunicationagile deliveryproblem-solvingorganizational skills