Data Engineer

You Will:

• 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

You Have:

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

Nice to Have

• 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

Why Talkiatry:

• Top-notch team: we're a diverse, experienced group motivated to make a difference in mental health care
• Collaborative environment: be part of building something from the ground up at a fast-paced startup
• Excellent benefits: medical, dental, vision, effective day 1 of employment, 401K with match, generous PTO plus paid holidays, paid parental leave, and more!
• Grow your career with us: hone your skills and build new ones with our Learning team as Talkiatry expands
• It all comes back to care: we’re a mental health company, and we put our team’s well-being first