Data Engineer II

About the company:

Since 2020, the company has sold practice management software to dental and veterinary clinics in Canada. Clients range from single-location retailers to franchise groups with hundreds of stores, all running our point-of-sale and loyalty software. We started in 2020 and have grown to about 130 people. Laptops are MacBook Pros, and you pick your own editor.

The role:

We are creating this position because the workload has grown. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. The Analytics team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. Fully remote. You can work from anywhere in Canada. Few meetings, lots of written updates.

Your responsibilities:

• Tune slow queries and expensive jobs.
• Document datasets and lineage in a catalog such as DataHub or Atlan.
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python.
• Process large datasets with Spark on Databricks or EMR.

What you'll need:

• 2+ years of data engineering, or backend work with data at volume.
• Working knowledge of AWS, GCP or Azure data services.
• Patience with messy source data and the habit of documenting assumptions.

Desirable:

• Terraform for data infrastructure.
• Dbt Certified Developer or Databricks certification.
• Kafka, Flink or Spark Structured Streaming.

What we offer:

• Flexible hours.

If this sounds like a fit, apply with a resume. A cover letter is optional.

Duration: 9 months. Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Pinfold Cloud.