Data Engineer I (Remote)

Trestlespring HQ runs an online marketplace where homeowners book local handymen, cleaners and movers. We ship small changes daily rather than big quarterly releases.

Job summary:

We are adding a Data Engineer I (Remote) to our Analytics team. The Analytics team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. Remote within Canada. The team meets in Vancouver once a quarter, travel covered. Most of our work is async, and meetings are kept short.

Day to day:

• Work with analysts to define metrics and fix discrepancies between reports
• Maintain CI for data code and review pull requests
• Process large datasets with Spark on Databricks or EMR
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python
• Design table layouts and partitioning for Parquet, Delta Lake or Iceberg

Skills and experience:

• 0-2 years of data engineering, or backend work with data at volume
• Familiarity with Git, CI/CD and testing practices for data code
• Hands-on with an orchestration tool such as Airflow
• Understanding of dimensional modeling and slowly changing dimensions
• Patience with messy source data and the habit of documenting assumptions
• Working knowledge of AWS, GCP or Azure data services

Pluses:

• Dbt Certified Developer or Databricks certification
• Reverse ETL tools like Hightouch or Census

What we offer:

• Extended health and dental benefits
• Group RRSP with employer matching
• Paid vacation
• Professional development budget
• Home office allowance

Accommodations are available on request for candidates taking part in all aspects of the selection process.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Trestlespring HQ Inc..