Data Engineer

<p style="min-height:1.5em">We're looking for a <strong>Data Engineer</strong> 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.</p><p style="min-height:1.5em"></p><p style="min-height:1.5em">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.</p><p style="min-height:1.5em"></p><h2><strong>About Talkiatry</strong></h2><p style="min-height:1.5em">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.</p><p style="min-height:1.5em"></p><p style="min-height:1.5em">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.</p><p style="min-height:1.5em"></p><p style="min-height:1.5em">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.</p><div style="min-height:1.2em;margin-top:0;margin-bottom:0"> </div><h2><strong>You Will:</strong></h2><ul style="min-height:1.5em"><li><p style="min-height:1.5em">Build and maintain ingestion pipelines and Python services running on AWS (Lambda, ECS)</p></li><li><p style="min-height:1.5em">Develop and maintain dbt models in our Snowflake warehouse, with thoughtful tests and documentation</p></li><li><p style="min-height:1.5em">Take operational responsibility — participate in the on-call rotation, triage pipeline failures, contribute to post-mortems</p></li><li><p style="min-height:1.5em">Partner with our BI / Analytics Engineering team to translate their needs into reliable DE work</p></li><li><p style="min-height:1.5em">Migrate independently-scheduled tasks and pipelines into Airflow DAGs as we standardize orchestration</p></li><li><p style="min-height:1.5em">Contribute to our CI/CD pipelines (GitHub Actions) and team standards</p></li><li><p style="min-height:1.5em">Mentor newer team members and review their work</p><p style="min-height:1.5em"></p></li></ul><h2><strong>You Have:</strong></h2><ul style="min-height:1.5em"><li><p style="min-height:1.5em"><strong>2+ years</strong> working as a Data Engineer (or in a closely-related role: backend engineering with substantial data work, analytics engineering, etc.)</p></li><li><p style="min-height:1.5em"><strong>Strong Python</strong> — you're a programmer, not just someone who can write SQL. You can write clear, testable Python and understand idiomatic patterns.</p></li><li><p style="min-height:1.5em"><strong>Advanced SQL</strong> — you've written non-trivial queries against a cloud warehouse, you understand window functions, joins, and how to write SQL that performs.</p></li><li><p style="min-height:1.5em"><strong>Conceptual understanding of CI/CD pipelines</strong> — you don't need to have built one yourself, but you understand what they do and why they matter.</p></li><li><p style="min-height:1.5em"><strong>Experience with a cloud data warehouse</strong> (Snowflake, Redshift, BigQuery, etc.); Snowflake preferred.</p></li><li><p style="min-height:1.5em"><strong>Comfortable in a cloud computing environment</strong>, ideally AWS.</p></li><li><p style="min-height:1.5em">Bachelor's degree in computer science or similar is preferred but not required.</p></li></ul><p style="min-height:1.5em"></p><h2><strong>Nice to Have</strong></h2><ul style="min-height:1.5em"><li><p style="min-height:1.5em">Experience with <strong>dbt</strong> (we use it heavily)</p></li><li><p style="min-height:1.5em">Experience with <strong>Airflow</strong> or another orchestration tool</p></li><li><p style="min-height:1.5em">Experience with <strong>ETL tools</strong> (Fivetran, Rivery, Stitch, etc.) — we use Fivetran</p></li><li><p style="min-height:1.5em">Familiarity with <strong>Terraform</strong> or other IaC (our DevOps team owns most of this, but exposure is useful)</p></li><li><p style="min-height:1.5em">Domain experience in <strong>healthcare</strong></p></li></ul><p style="min-height:1.5em"></p><h2><strong>Why Talkiatry:</strong></h2><ul style="min-height:1.5em"><li><p style="min-height:1.5em">Top-notch team: we're a diverse, experienced group motivated to make a difference in mental health care</p></li><li><p style="min-height:1.5em">Collaborative environment: be part of building something from the ground up at a fast-paced startup</p></li><li><p style="min-height:1.5em">Excellent benefits: medical, dental, vision, effective day 1 of employment, 401K with match, generous PTO plus paid holidays, paid parental leave, and more!</p></li><li><p style="min-height:1.5em">Grow your career with us: hone your skills and build new ones with our Learning team as Talkiatry expands</p></li><li><p style="min-height:1.5em">It all comes back to care: we’re a mental health company, and we put our team’s well-being first</p></li></ul><p style="min-height:1.5em"></p><p style="min-height:1.5em"><em>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: </em><a target="_blank" rel="noopener noreferrer nofollow" href="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"><em>EVerify Participation</em></a><em> & </em><a target="_blank" rel="noopener noreferrer nofollow" href="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"><em>IER Right to Work</em></a><em>.</em></p><p style="min-height:1.5em"></p><p style="min-height:1.5em"><em>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.</em></p><p style="min-height:1.5em"></p><p style="min-height:1.5em"><em>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.</em></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...