Senior Data Engineer

Talkiatry transforms psychiatry with accessible, human, and responsible care. We’re a national mental health practice co-founded by a patient and a triple-board-certified psychiatrist to solve the problems both groups face in accessing and providing the highest quality treatment.      60% of adults in the U.S. with a diagnosable mental illness go untreated every year because care is inaccessible, while 45% of clinicians are out of network with insurers because reimbursement rates are low and paperwork is unduly burdensome.   With innovative technology and a human-centered philosophy, we provide patients with the care they need—and allow psychiatrists to focus on why they got into medicine.     About the role:   As a Senior Data Engineer, your main goal is to help build and maintain our data infrastructure (Data Pipelines, Data Warehouse, Data Integrations) as well as contributing to Architectural Decisions and Building new data products and Services to serve our business. You will also help contribute to the continuous improvement of our development workflows and processes and collaborate with cross-functional stakeholders, including, Product, Infrastructure and Operations teams to deliver clear outcomes.  You will:  

• Architect and build new innovative data solutions that will interact with both internal and external APIs and our Data Warehouse 
• Contribute to the monitoring of the overall health and integrity of Data Pipelines and data systems 
• Support and maintain our existing DBT Data Models and Snowflake Data Warehouse 
• Maintain and build CI/CD Pipelines using GitHub Actions 
• Work closely with the infrastructure team, be able to anticipate our infrastructure needs based on planned work for new data products and be able to articulate those needs (and potentially write some High level IaC in Terraform) 
• Create custom data products for production-grade system integrations as needed 
• Ingest new data sources into the data warehouse and create Reverse ETL solutions as needed 
• Migrate independently scheduled tasks and pipelines into Airflow DAGs 

 You Possess: 

• Technical Excellence – You know that expertise in technology is a journey, not a destination. You know industry best-practices, and you’re learning how they change over time. You build on your hands-on experience by learning how and where the field is advancing. 
• “Strong Opinions, Loosely Held” – You look at solutions in terms of their trade-offs, and you recognize when to apply common design and architectural patterns, but you’re always learning how different contexts can demand different solutions. 
• Collaborative approach – You believe that teams can be greater than the sum of their parts when everyone is invited to the table. You know that inclusion is proactive, and you support your teammates to help them do their best work. 
• Outcomes Over Outputs mindset – You believe that the technology is a means to an end, and you keep an eye out for the simplest solution to the problem. 

 You have: 

• Bachelor’s degree in computer science or similar is preferred but not required 
• 3+ years' experience working as a Data Engineer (some Backend Engineering experience also fine) 
• 3+ years’ experience as a developer, Python Preferred but other language (Java, Scala) are fine too. Please note, the technical assessment will include Python. 
• 2+ years' experience working with cloud data warehouses (Snowflake, Redshift, etc.) 
• Experience with architecture, design patterns, testing frameworks and coding for maintainability 
• Experience working with APIs and Message Queues to fetch and post data at scale 
• Experience using CI/CD tools such as: GitHub Actions, Jenkins or CircleCI 
• Familiarity working within cloud computing environments such as AWS, Azure, Google Cloud 
• Advanced SQL experience 
• Experience writing Infrastructure as code in Terraform or AWS CFT is useful but not required 
• Experience working with an orchestration tool like Airflow is a plus, but not required 
• Experience with Data Modeling and DBT is a plus, but not required 
• Experience working with ETL tools (e.g. Fivetran, Rivery, Stitch, etc.), is a plus but not required 

 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   
• Flexible location: work where you want to, either remotely across the U.S. or from our HQ in NYC   
• 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: