talkiatry - Data Engineer
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)
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
Benefits
• 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 • Talkiatry participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. only after a job offer is accepted and Form I-9 is completed. For more information on E-Verify, please visit the following: EVerify Participation https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.e-verify.gov%2Fsites%2Fdefault%2Ffiles%2Feverify%2Fposters%2FEVerifyParticipationPoster.pdf&data=05%7C01%7Cjill.steger%40talkiatry.com%7Cfe829943872e4bc8dc7b08db83d3c99d%7C803a6c90ec724384b2c01a376841a04b%7C0%7C0%7C638248717875458398%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qFgJNzh246Js%2FFqdsb9OZgN55rg5GpsB0wjiTvkPn9w%3D&reserved=0 & IER Right to Work https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.e-verify.gov%2Fsites%2Fdefault%2Ffiles%2Feverify%2Fposters%2FIER_RighttoWorkPoster.pdf&data=05%7C01%7Cjill.steger%40talkiatry.com%7Cfe829943872e4bc8dc7b08db83d3c99d%7C803a6c90ec724384b2c01a376841a04b%7C0%7C0%7C638248717875458398%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ivUqrPtiBjGVkMzpMBSYalwvm2Zxhj%2BScqVUX2OfqUA%3D&reserved=0.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT