Job Description

###

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.###

About Receptive

Our fast-growing, remote-first startup is revolutionizing mental health care with the support of significant seed funding. We're not only dedicated to providing accessible and effective services, but we're also committed to healthcare compliance - so you can feel good about what you're working on. With a relentless focus on patient wellness, we're on track to become a leading provider of mental health care through our cutting-edge digital product.