ETL jobs in Vancouver, BC

Job Description

We are looking for an experienced Data Engineer to design, build and operate production-grade data pipelines across real-time streaming and batch-processing environments.

This role is suited to an engineer who enjoys solving complex data challenges, improving platform reliability and building systems that are observable, testable and easy to operate. You will work with technologies including Python, SQL, Apache Flink, Apache Kafka, PostgreSQL, S3-compatible storage, Docker and Kubernetes.

What You’ll Do

• Design and maintain scalable streaming, microbatch and batch data pipelines.
• Build stateful stream-processing applications using Apache Flink’s Table API and DataStream API.
• Implement exactly-once processing, checkpointing, deduplication, enrichment and late-event handling.
• Develop Kafka-based event ingestion and distribution solutions using Apache Kafka, Kafka REST Proxy and Confluent Platform.
• Build and optimise ETL and ELT workflows for operational and analytical data use cases.
• Design dimensional data models, fact tables, dimensions and data marts.
• Implement change data capture, incremental processing, replay and batch-reprocessing capabilities.
• Integrate pipelines with PostgreSQL, Redis, MinIO, Amazon S3 and other S3-compatible platforms.
• Develop automated tests using pytest, synthetic data, benchmarks and CI smoke tests.
• Establish data-quality checks covering completeness, accuracy, uniqueness, timeliness and consistency.
• Implement resilient error handling, retries, dead-letter processing, alerting and recovery workflows.
• Containerise and deploy services using Docker, Docker Compose, Docker Bake, AWS ECR and Kubernetes.
• Build CI/CD workflows with GitHub Actions.
• Create Grafana dashboards, structured logs, operational metrics and actionable alerts.
• Troubleshoot production issues involving latency, duplication, ordering, schema changes and data availability.
• Collaborate with engineers, analysts, architects and stakeholders to deliver maintainable data solutions.

What You’ll Bring

• Strong commercial experience in data engineering or a closely related role.
• Proficiency in Python and advanced SQL.
• Working knowledge of Java.
• Hands-on experience with Apache Flink, including state management, checkpoints, savepoints and event-time processing.
• Strong knowledge of Apache Kafka, including producers, consumers, topics, partitions, offsets and consumer groups.
• Experience designing reliable ETL, ELT, CDC and event-driven data architectures.
• Practical experience with PostgreSQL, Redis, MinIO or Amazon S3.
• Experience developing automated tests with pytest.
• Understanding of idempotency, replay, deduplication, data quality and failure recovery.
• Experience with Docker, Kubernetes, Linux and Bash.
• Familiarity with Git, GitHub and GitHub Actions.
• Experience with monitoring, structured logging, dashboards and production alerting.

Technology Stack

• Languages: Python, SQL, Java, Bash
• Stream and Batch Processing: Apache Flink, Table API, DataStream API
• Event Streaming: Apache Kafka, Kafka REST Proxy, Confluent Platform
• Databases and Storage: PostgreSQL, Redis, MinIO, Amazon S3
• Testing: pytest, synthetic data generation, benchmarking, integration testing, CI smoke tests
• Infrastructure: Docker, Docker Compose, Docker Bake, AWS ECR, Kubernetes
• Monitoring: Grafana, structured logging, notifications and alerting
• Delivery: Git, GitHub, GitHub Actions
• Python Libraries: smart-open, confluent-kafka, boto3, psycopg2, tenacity and requests

Desirable Experience

• Operating Kafka and Flink workloads in Kubernetes.
• Schema evolution, data contracts, metadata management and data lineage.
• Performance tuning for high-volume or low-latency data pipelines.
• Infrastructure-as-code and automated environment provisioning.
• Security controls for sensitive or regulated data.
• Experience supporting high-availability production platforms.

Pay: $110,000.00-$120,000.00 per year

Benefits:

• Employee assistance program
• Extended health care
• Paid time off
• RRSP match
• Work from home

Ability to commute/relocate:

• Vancouver, BC V6C 3P6: reliably commute or plan to relocate before starting work (preferred)

Application question(s):

• What is your salary expectation?
• If you are not Canadian permanent resident or Citizen what is your current status in Canada and when is going to expire your current visa?

Education:

• Bachelor's Degree (required)

Experience:

• Data Engineer – Streaming & Data Platforms: 5 years (required)

Work Location: Hybrid remote in Vancouver, BC V6C 3P6