Sr. Data Engineer

Who we are  

Transcarent is the One Place for Health and Care. We cut through complexity, making it easy for people to access high-quality, affordable health and care. We create a personalized experience tailored for each Member, including an on-demand care team, and a connected ecosystem of high-quality, in-person care and virtual point solutions. Transcarent eliminates the guesswork and empowers Members to make better decisions about their health and care.

Transcarent is aligned with those who pay for healthcare and takes accountability for results – offering at-risk pricing models and transparent impact reporting to ensure incentives support a measurably better experience, better health, and lower costs. 

At Transcarent, you will be part of a world-class team, supported by top tier investors like 7wireVentures and General Catalyst, and founded by a mission-driven team committed to transforming the health and care experience for all. In May 2024, we closed our Series D with $126 million, propelling our total funding to $450 million and fueling accelerated AI capabilities and strategic growth opportunities. 

We are looking for teammates to join us in building our company, culture, and Member experience who:  

• Put people first, and make decisions with the Member’s best interests in mind 
• Are active learners, constantly looking to improve and grow 
• Are driven by our mission to measurably improve health and care each day 
• Bring the energy needed to transform health and care, and move and adapt rapidly 
• Are laser focused on delivering results for Members, and proactively problem solving to get there 

About this role 

We are looking for data engineers excited to create a single source of truth that will power the decisions for the company for other developers, products, clinical teams, data analysts, data scientists, member experience, and more. They will need to be able to ingest various sorts of application and health data, leverage our Snowflake data warehouse to load it, and transform the data into various data sets to offer it self-serve in a secure, compliant manner. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives. 
 
What you’ll do  

• Be a data champion and seek to empower others to leverage the data to its full potential. 
• Create and maintain optimal data pipeline architecture with high observability and robust operational characteristics. 
• Assemble large, complex data sets that meet functional / non-functional business requirements. 
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. 
• Build the infrastructure required for optimal data extraction, transformation, and loading using SQL, python, and dbt from various sources. 
• Work with stakeholders, including the Executive, Product, Clinical, Data, and Design teams, to assist with data-related technical issues and support their data infrastructure needs. 
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader. 

What we’re looking for  

• You are entrepreneurial and mission-driven and can present your ideas with clarity and confidence. 
• You are a high-agency person. You refuse to accept undue constraints and the status quo and will not rest until you figure things out. 
• Advanced expertise in python and dbt for data pipelines   
• Advanced working SQL knowledge and experience working with relational databases. 
• Experience building and optimizing big