Key skills
PythonSQLETLAnalyticsBISnowflakeBigQueryRedshiftAirflowdbtFivetranAWSTerraformGitHub ActionsECSLambdaGitHubCI/CDMentoring
About this role
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