Senior Data Engineer

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.

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.   

• Create custom data products for production-grade system integrations as needed
• Contribute to the monitoring of the overall health and integrity of Data Pipelines and data systems
• Support, maintain and extend our existing DBT Data Models and Snowflake Data Warehouse, (including, making performance optimizations)
• 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)
• Ingest new data sources into the data warehouse and create Reverse ETL solutions as needed
• Migrate independently scheduled tasks and pipelines into Airflow DAGs
• Join the rest of the Data Engineering team in the On-Call Rotation
• Architect and build new innovative data solutions that will interact with both internal and external APIs and our Data Warehouse

• Bachelor’s degree in computer science or similar is preferred but not required
• 3+ years' experience working as a Data Engineer
• Advanced SQL experience
• 3+ years’ experience as a developer, Python Preferred but other language (Java, Scala)
• 2+ years' experience working with cloud data warehouses (Snowflake preferred including Snowflake performance optimization through warehouse sizing, and caching strategies)
• Experience with Data Modeling in DBT, including DBT performance optimization (e.g. materializations, incremental models, macros) to optimize data processing speed and minimize cloud costs while preserving data accuracy and reliability).
• Experience using CI/CD tools such as: GitHub Actions, Jenkins or CircleCI
• Familiarity working within cloud computing environments such as AWS, Azure, Google Cloud
• 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 working with other ETL tools (e.g. Fivetran, Rivery, Stitch, etc.), is a plus
• Experience working with APIs and Message Queues

• 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: 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 & IER Right to Work.  

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.