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.
• 7+ 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.