Data Engineer

Talkiatry is transforming mental health care by making high-quality psychiatry more accessible. They are seeking a Data Engineer to build and maintain data pipelines and infrastructure that support analytics and reporting, while also mentoring team members and ensuring operational reliability.

Responsibilities:

• Build and maintain ingestion pipelines and Python services running on AWS (Lambda, ECS)
• Develop and maintain dbt models in our Snowflake warehouse, with thoughtful tests and documentation
• Take operational responsibility — participate in the on-call rotation, triage pipeline failures, contribute to post-mortems
• Partner with our BI / Analytics Engineering team to translate their needs into reliable DE work
• Migrate independently-scheduled tasks and pipelines into Airflow DAGs as we standardize orchestration
• Contribute to our CI/CD pipelines (GitHub Actions) and team standards
• Mentor newer team members and review their work

Requirements:

• 2+ years working as a Data Engineer (or in a closely-related role: backend engineering with substantial data work, analytics engineering, etc.)
• Strong Python — you're a programmer, not just someone who can write SQL. You can write clear, testable Python and understand idiomatic patterns
• Advanced SQL — you've written non-trivial queries against a cloud warehouse, you understand window functions, joins, and how to write SQL that performs
• Conceptual understanding of CI/CD pipelines — you don't need to have built one yourself, but you understand what they do and why they matter
• Experience with a cloud data warehouse (Snowflake, Redshift, BigQuery, etc.); Snowflake preferred
• Comfortable in a cloud computing environment, ideally AWS
• Bachelor's degree in computer science or similar is preferred but not required
• Experience with dbt (we use it heavily)
• Experience with Airflow or another orchestration tool
• Experience with ETL tools (Fivetran, Rivery, Stitch, etc.) — we use Fivetran
• Familiarity with Terraform or other IaC (our DevOps team owns most of this, but exposure is useful)
• Domain experience in healthcare