Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Medical, dental, vision, effective day 1 of employment
- 401K with match
- Generous PTO plus paid holidays
- Paid parental leave
- Grow your career with us: hone your skills and build new ones with our Learning team as Talkiatry expands
Company Overview
Talkiatry provides virtual mental healthcare services covered by insurance, connecting patients with licensed psychiatrists. It was founded in 2019, and is headquartered in New York, New York, USA, with a workforce of 501-1000 employees. Its website is http://www.talkiatry.com.