Lead Data Engineer

Why Charlie Health?

We are currently facing a nationwide mental health epidemic marked by rising rates of depression, anxiety, trauma, substance use disorders, and suicide. At the same time, those seeking help often encounter barriers—whether geographic, financial, or systemic—that prevent them from receiving timely and effective care. This urgent need calls for a reimagined approach to behavioral health treatment.

At Charlie Health, our mission is to connect the world to life-saving mental health treatment. Our innovative virtual programs combine curated group sessions, individual therapy, and family therapy, delivered through personalized, evidence-based treatment plans designed for sustainable healing from the comfort of home. By connecting individuals with shared experiences and fostering supportive communities, Charlie Health provides a pathway to long-term recovery, with over 90% of our clients seeing improvement in their most challenging mental health symptoms.

Every member of our team shares a deep commitment to this mission. If you’re driven to make a meaningful impact, we invite you to join us in reshaping the future of mental healthcare.

About the Role

The data team at Charlie Health services all parts of our business by sourcing, curating, and activating internally and externally sourced datasets. As a software engineer on the data 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.

Responsiblities

• Develop, release, and maintain high quality data pipelines using Python, FiveTran, DBT, and Snowflake.
• Own and guide the development of our data infrastructure.
• Develop custom integrations using Dagster.
• Configure reverse ETL integrations using Hightouch.
• Identify bottlenecks and implement improvements to our data engineering processes, tools, and procedures. We’re early and the expectation of folks joining at this stage is that you’ll play a huge part in setting and improving how we work.
• Promote a culture of collaboration and learning across engineering, product, and design 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 as a software engineer, 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, Hightouch, 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 is a plus
• Please note that members of this team who live within 45 minutes of a Charlie Health office are expected to adhere to a hybrid work schedule.

Charlie Health does not provide visa sponsorship.

Note to Colorado applicants: applications will be accepted and reviewed on a rolling basis.

Benefits

Charlie Health is pleased to offer comprehensive benefits to all full-time, exempt employees. Read more about our benefits here.#LI-Remote

The total target base compensation for this role will be between $175,000 and $215,000 per year at the commencement of employment. In addition to base compensation, this role also offers a performance bonus. Please note, pay will be determined on an individualized basis and will be impacted by location, experience, expertise, internal pay equity, and other relevant business considerations. Further, cash compensation is only part of the total compensation package, which, depending on the position, may include stock options and other Charlie Health-sponsored benefits.

Our Values

• Connection: Care deeply & inspire hope.
• We care personally about every single person in the Charlie Health ecosystem: our clients, providers, and team members alike.
• We inspire hope with every interaction, reminding our clients that we truly and unconditionally believe in them.
• Congruence: Stay curious & heed the evidence.
• We ask “why” five times before we’re satisfied with the answer. We don’t stick to the status quo; we challenge our assumptions and remain humble.
• Above all, we’re results-oriented. When we find data that calls our original plan into question, we modify or pivot.
• Commitment: Act with urgency & don’t give up.
• We work as swiftly as possible. The mental health crisis is relentless, and so are we.
• Our clients don’t give up and neither do we. Persistence is our superpower.

Please do not call our public clinical admissions line in regard to this or any other job posting.

Please be cautious of potential recruitment fraud. If you are interested in exploring opportunities at Charlie Health, please go directly to our Careers Page: https://www.charliehealth.com/careers/current-openings. Charlie Health will never ask you to pay a fee or download software as part of the interview process with our company. In addition, Charlie Health will not ask for your personal banking information until you have signed an offer of employment and completed onboarding paperwork that is provided by our People Operations team. All communications with Charlie Health Talent and People Operations professionals will only be sent from @charliehealth.com email addresses. Legitimate emails will never originate from gmail.com, yahoo.com, or other commercial email services.

Recruiting agencies, please do not submit unsolicited referrals for this or any open role. We have a roster of agencies with whom we partner, and we will not pay any fee associated with unsolicited referrals.

At Charlie Health, we value being an Equal Opportunity Employer. We strive to cultivate an environment where individuals can be their authentic selves. Being an Equal Opportunity Employer means every member of our team feels as though they are supported and belong. We value diverse perspectives to help us provide essential mental health and substance use disorder treatments to all young people.

Charlie Health applicants are assessed solely on their qualifications for the role, without regard to disability or need for accommodation.