Lead Data Engineer, Revenue Engine

Why Charlie Health? Millions of people across the country are navigating mental health conditions, substance use disorders, and eating disorders, but too often, they’re met with barriers to care. From limited local options and long wait times to treatment that lacks personalization, behavioral healthcare can leave people feeling unseen and unsupported. Charlie Health exists to change that. Our mission is to connect the world to life-saving behavioral health treatment. We deliver personalized, virtual care rooted in connection—between clients and clinicians, care teams, loved ones, and the communities that support them. By focusing on people with complex needs, we’re expanding access to meaningful care and driving better outcomes from the comfort of home. As a rapidly growing organization, we're reaching more communities every day and building a team that’s redefining what behavioral health treatment can look like. If you're ready to use your skills to drive lasting change and help more people access the care they deserve, we’d love to meet you. About the Role The Revenue Engine team at Charlie Health services all parts of our business related to revenue collection, financial reporting, and the patient financial experience by sourcing, curating, and activating internally and externally sourced datasets, and building user-facing products. As a data engineer on the Revenue Engine team, you will be responsible for building ELT pipelines, developing custom DAGs, transforming and warehousing data with DBT, and building integrations between our systems. We’re a team of passionate, forward-thinking professionals eager to take on the challenge of the mental health crisis and play a formative role in providing life-saving solutions. If you’re inspired by our mission and energized by the opportunity to increase access to mental healthcare and impact millions of lives in a profound way, apply today. Responsibilities Develop, release, and maintain high quality data pipelines using Python, FiveTran, DBT, and Snowflake. Own and guide the development of our data infrastructure. Orchestrate complex data workflows using Dagster. Identify bottlenecks and implement improvements to our data engineering processes, tools, and procedures. Everyone on our team shares responsibility for continuously improving how we work. Promote a culture of collaboration and learning across the technology team via mentoring, documentation, presentations, or other knowledge-sharing methods. Ensure our data is always available by participating in our on-call rotation. Requirements Bachelor’s degree in Computer Science, Mathematics, or other technical discipline, or equivalent practical experience 7+ years experience in engineering, with at least 5 years of experience in a data engineering role Deep expertise in SQL. You understand CTEs, aggregation functions, window functions, partitioning and clustering approaches to run correct and highly-performant queries High proficiency in Python and experience using common data engineering libraries such as Pandas, Numpy, and Great Expectations Experience with a modern data stack. Experience with our tools - FiveTran, Snowflake, DBT, Dagster, and Tableau - is a big plus Experience with data exploration, profiling, governance, visualization, and activation Proven ability to thrive in an ambiguous and rapidly changing environment Experience working with sensitive data in a regulated environment Expertise in healthcare and/or revenue cycle management is a plus You live within a 75 minute commute of our NYC office (near Union Square) and are able to work in-office 4 days per week. Benefits Charlie Health is pleased to offer comprehensive benefits to all full-time, exempt employees. Read more about our benefits here . The total target base compensation for this role will be between $175,000 and $255,000 per year at the commencement of employment. Please note, pay will be determined on an individualized basis and will be impacted by l