Lead Data Engineer

The company

Since 2012, the company has sold practice management software to dental and veterinary clinics in Canada. Founded in 2012, the business writes the billing, metering and customer portal software that small water and electric utilities run on. We keep recurring meetings to Tuesdays and Thursdays where we can.

Job summary

We are backfilling a position after an internal move. Tremblay Data needs someone who writes solid SQL and Python and treats pipelines like production software. Our team is spread across 6 countries. Headquarters is in Montreal. You will be employed through our employer-of-record partner in Pakistan, with a local contract and salary paid in Pakistani rupees. Core hours are 9:00 AM to 1:00 PM US Eastern. You need a reliable internet connection and somewhere quiet to work.

Your responsibilities

• Model data in dbt using staging, intermediate and mart layers
• Maintain CI for data code and review pull requests
• Tune slow queries and expensive jobs
• Handle PII according to retention, masking and access policies
• Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python
• Document datasets and lineage in a catalogue such as DataHub or Atlan
• Work with analysts to define metrics and fix discrepancies between reports
• Build batch and streaming pipelines with Airflow, Dagster or Prefect

Qualifications

• 8+ years of data engineering, or backend work with data at volume
• Strong Python for data processing
• Working knowledge of AWS, GCP or Azure data services
• Patience with messy source data and the habit of documenting assumptions
• Expert SQL, including window functions and query tuning
• Familiarity with Git, CI/CD and testing practices for data code

Compensation and benefits

Compensation: PKR 670,000 - PKR 870,000 per month

• Monthly internet allowance
• Stock options
• Home office setup budget
• 24 days paid time off

Due to the number of applications, only shortlisted candidates will be contacted.

Start: Flexible.

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