[Remote] Data Engineer

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.ResponsibilitiesBuild 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 documentationTake operational responsibility — participate in the on-call rotation, triage pipeline failures, contribute to post-mortemsPartner with our BI / Analytics Engineering team to translate their needs into reliable DE workMigrate independently-scheduled tasks and pipelines into Airflow DAGs as we standardize orchestrationContribute to our CI/CD pipelines (GitHub Actions) and team standardsMentor newer team members and review their workSkills2+ 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 patternsAdvanced SQL — you've written non-trivial queries against a cloud warehouse, you understand window functions, joins, and how to write SQL that performsConceptual understanding of CI/CD pipelines — you don't need to have built one yourself, but you understand what they do and why they matterExperience with a cloud data warehouse (Snowflake, Redshift, BigQuery, etc.); Snowflake preferredComfortable in a cloud computing environment, ideally AWSBachelor's degree in computer science or similar is preferred but not requiredExperience with dbt (we use it heavily)Experience with Airflow or another orchestration toolExperience with ETL tools (Fivetran, Rivery, Stitch, etc.) — we use FivetranFamiliarity with Terraform or other IaC (our DevOps team owns most of this, but exposure is useful)Domain experience in healthcareBenefitsMedical, dental, vision, effective day 1 of employment401K with matchGenerous PTO plus paid holidaysPaid parental leaveGrow your career with us: hone your skills and build new ones with our Learning team as Talkiatry expandsCompany OverviewTalkiatry 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.