Senior Data Engineering Lead
Department: Engineering
Employment Type: Full Time
Location: Remote - Canada
Compensation: $130,000 - $140,000 / year
Description
The Company
Receptive is a modern telehealth platform for emotional wellness and mental clarity. Since our founding, we’ve connected over a million individuals with the right mental health support at the right time. Licensed in all 50 states and serving over 100,000 customers each year, we partner with Pettable for ESA evaluations and ADHD Advisor for comprehensive ADHD care. Grounded in clinical excellence and a people-first mission, we empower licensed professionals with the autonomy and tools they need to make mental health care more accessible and impactful.
The Position
We’re looking for an Analytics Engineer, you’ll turn messy source data into trustworthy, well-modeled datasets and metrics that power dashboards, product decisions, and ops. We run a lean, warehouse-centric ELT stack and care about reliability, clarity, and speed.
Key Responsibilities
Own the warehouse modeling layer (dbt or SQL): build clean, tested marts (star/snowflake schemas), reusable macros, and clear docs.
Run ELT: manage connectors (e.g., Fivetran/Airbyte), handle schema changes, backfills, and historical re-syncs.
Define and enforce data quality: Dbt tests, anomaly checks; triage and fix issues at the source or in transforms.
Create a governed metrics layer: standardize KPIs (definitions, owners, acceptance tests) for analytics and product teams.
Orchestrate & ship: set up CI/CD for transforms (e.g., GitHub Actions) and light orchestration (Prefect/Dagster/Airflow optional).
Partner with stakeholders: translate questions into durable datasets; enable analysts to move faster with less ad-hoc wrangling.
Tune for reliability & cost: materializations, indexes/cluster keys, caching, and sensible scheduling to keep queries fast and bills sane.
Document everything: data contracts, lineage, and playbooks for incidents, backfills, and onboarding.
Skills, Knowledge and Expertise
5+ years relevant industry experience in a data engineering role and graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
Proficiency in writing SQL queries and knowledge of cloud-based databases like Snowflake, Redshift, BigQuery or other big data solutions.
Experience in data modelling, ETL processes, and data warehousing.
Experience with Python and data pipeline tools such as Airflow.
Experience with version control systems like GitHub / GitLab.
Logistics
Time Commitment
This role is a full-time contract position and requires overlap with US ET for the majority of the workday. It is an exciting opportunity demanding dedication beyond the standard 9 to 5. We need someone willing to go above and beyond to help us achieve our ambitious goals and eager to make a real impact.
Location
We are fully remote – you can work wherever you’re most productive. We are unable to provide Visa or work permit sponsorship at this time.
Compensation
Our compensation packages are designed to make this your dream job for the short and long term. Each compensation package is tailored to suit your priorities and includes a competitive base salary. Benefits include medical, dental, vision, a wellness and office stipend, and an unlimited time off policy with a two-week minimum.
