Job description

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 Analytics & Data Engineering team owns all post-transactional data operations that turn raw data into insights. We design and operate ETL pipelines, Kafka Topics, data warehouses, transformations, agentic skills, and analytics tooling that power reporting, experimentation, and decision-making across Charlie Health. Our focus is on reliability, scalability, and making data accessible and actionable for the entire organization. As a Staff Data Engineer on this team, you'll be a key technical contributor and mentor across the team. You will build and own significant parts of our data infrastructure, driving pipeline reliability and warehouse quality. You'll work across a modern data stack to ensure that Charlie Health's data is timely, accurate, performant, secure, and trusted. If you're energized by the opportunity to expand access to mental healthcare and make a meaningful impact on millions of lives from the data and pipelines you support, we'd love to hear from you. Responsibilities Build, release, and maintain high-quality ELT & streaming pipelines with a strong emphasis on correctness, observability, and performance Orchestrate complex data workflows using Dagster/Airflow and DBT, ensuring reliable and well-monitored execution and quality assessments Own meaningful areas of our data warehouse, Snowflake, designing well-modeled, performant schemas, and maintaining clear documentation of data definitions and lineage Resolve critical data issues independently and proactively identify and address bottlenecks before they impact downstream consumers Contribute to architectural decisions and technical design discussions, bringing well-reasoned, data-driven recommendations to the team Support analytics delivery through Hex and AI Agents, collaborating with stakeholders to ensure data is accessible, governed, and actionable Help the team level up by authoring documentation, sharing learnings, and contributing to a culture of craft and continuous improvement Participate in our on-call rotation to ensure data availability and pipeline health Requirements Bachelor's degree in Computer Science, Mathematics, or a related technical discipline, or equivalent practical experience 5+ years of experience in Data, with at least 4 years in a Data Engineering role Deep expertise in analytical use cases of SQL, including CTEs, window functions, aggregation patterns, and performance tuning techniques such as partitioning and clustering Strong proficiency in Python, including experience with common data engineering libraries Hands-on experience with a modern data stack Demonstrated ability to take ownership of loosely-defined problems, breaking them into well-scoped tasks, driving them to completion, and communicating tradeoffs clearly Experience working with sensitive data in a regulated environment 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 Nice to Haves Previous Experience in Healthcare Previous Experience in Airflow & Migrations Previous Experience with Kafka Streams Experience leveraging AI tools for development 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 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. #LI-HYBRID Our Values Connection: Care deeply & inspire hope. Congruence: Stay curious & heed the evidence. Commitment: Act with urgency & don’t give up. 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: [application link] 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. By clicking "Submit application" below, you agree to Charlie Health's Privacy Policy and Terms of Service. By submitting your application, you agree to receive SMS messages from Charlie Health regarding your application. Message and data rates may apply. Message frequency varies. You can reply STOP to opt out at any time. For help, reply HELP.

Requirements

Must-haves

Why Charlie Health?
Build, release, and maintain high-quality ELT & streaming pipelines with a strong emphasis on correctness, observability, and performance
Orchestrate complex data workflows using Dagster/Airflow and DBT, ensuring reliable and well-monitored execution and quality assessments
Own meaningful areas of our data warehouse, Snowflake, designing well-modeled, performant schemas, and maintaining clear documentation of data definitions and lineage
Resolve critical data issues independently and proactively identify and address bottlenecks before they impact downstream consumers
Contribute to architectural decisions and technical design discussions, bringing well-reasoned, data-driven recommendations to the team
Support analytics delivery through Hex and AI Agents, collaborating with stakeholders to ensure data is accessible, governed, and actionable
Help the team level up by authoring documentation, sharing learnings, and contributing to a culture of craft and continuous improvement
Participate in our on-call rotation to ensure data availability and pipeline health
Bachelor's degree in Computer Science, Mathematics, or a related technical discipline, or equivalent practical experience
5+ years of experience in Data, with at least 4 years in a Data Engineering role
Deep expertise in analytical use cases of SQL, including CTEs, window functions, aggregation patterns, and performance tuning techniques such as partitioning and clustering
Strong proficiency in Python, including experience with common data engineering libraries
Hands-on experience with a modern data stack
Demonstrated ability to take ownership of loosely-defined problems, breaking them into well-scoped tasks, driving them to completion, and communicating tradeoffs clearly
Experience working with sensitive data in a regulated environment
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

Nice-to-haves

Previous Experience in Healthcare
Previous Experience in Airflow & Migrations
Previous Experience with Kafka Streams
Experience leveraging AI tools for development

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aisqlpythongo

Platform: greenhouse
Effort: quick