Data Engineer

Job description

We're looking for a Data Engineer to join our growing data team. You'll work alongside senior data engineers to build and maintain the pipelines, dbt models, and infrastructure that power Talkiatry's analytics, operations, and clinical reporting. This is a role for someone who has hit their stride past their first DE job — comfortable shipping reliably, breaking down ambiguous asks, and willing to mentor a teammate when needed. You'll work independently within your scope (ingestion jobs, dbt model areas, internal tooling), partner with our BI / Analytics Engineering team who depend on your work, and take operational responsibility through on-call coverage. ABOUT TALKIATRY Talkiatry is transforming mental health care by making high-quality psychiatry more accessible, human, and sustainable for both patients and clinicians. Co-founded by a patient and a triple-board-certified psychiatrist, we were built to solve one of healthcare’s most urgent challenges: millions of people struggle to access mental health care, while clinicians face growing administrative burden and burnout. Through our technology-powered, in-network platform, we’re changing that, creating a better experience for patients and empowering clinicians to focus on delivering exceptional care. Today, Talkiatry is the largest dedicated psychiatry practice in the U.S., with 750+ psychiatrists, 250+ therapists, and more than two million patient visits delivered nationwide. At our scale, every innovation has real impact. Every workflow we improve, every technology solution we build, and every patient experience we redesign helps thousands of clinicians provide better care to hundreds of thousands of patients. We’re not just growing quickly — we’re redefining how behavioral healthcare is delivered in America. Joining Talkiatry means joining a mission-driven team that is solving complex problems at scale, driving meaningful change in healthcare, and building the future of mental health care with compassion, innovation, and purpose. 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 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. At Talkiatry, we are an equal opportunity employer committed to a diverse, inclusive, and equitable workplace and candidate experience. We strive to create an environment where everyone has a sense of belonging and purpose, and where we learn from the unique experiences of those around us. We encourage all qualified candidates to apply regardless of race, color, ancestry, religion, national origin, sexual orientation, age, citizenship, marital or family status, disability, gender, gender identity or expression, pregnancy or caregiver status, veteran status, or any other legally protected status.