Sr Analytics Engineer

About the position

We are looking for an Analytics Engineer to build and scale the data infrastructure that powers decision-making at Charlie Health. This person will play a key role in transforming raw data into actionable insights, ensuring that our therapists, clinical teams, and business stakeholders have access to high-quality, reliable data. They will work closely with product, engineering, and analytics teams to design scalable data models, optimize data workflows, and drive a culture of experimentation and data-driven decision-making. This role is foundational to making Charlie Health’s data more accessible, accurate, and impactful—helping us improve outcomes for the teens and young adults we serve. 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

• Build, maintain, and optimize data models that transform raw data into structured, actionable insights in Snowflake using dbt.
• Partner with data engineers to ensure data pipelines are efficient, reliable, and well-documented.
• Build and maintain dashboards, reports, and self-serve analytics tools in Hex and Tableau, ensuring teams can easily access the right data.
• Implement best practices for A/B testing, cohort analysis, and impact measurement, ensuring insights drive real-world improvements in patient care and clinician experience.
• Continuously refine queries and data transformations to reduce latency, improve efficiency, and manage Snowflake costs effectively.
• Work cross-functionally with clinical, product, and operations teams to ensure they can trust and leverage data to improve business and patient outcomes.

Requirements

• Advanced SQL expertise (Snowflake, Redshift, or BigQuery), with the ability to write and optimize complex queries.
• Proficiency with dbt (or equivalent transformation tools) for building scalable data models.
• Experience with BI & reporting tools (Hex, Tableau) to develop dashboards and reports.
• Understanding of data warehouse architecture, governance, and best practices to ensure data is structured, reliable, and easy to access.
• Ability to thrive in a fast-paced, high-impact environment, balancing technical rigor with business needs.
• Strong problem-solving skills and a collaborative mindset to work across teams and functions.

Benefits

• Comprehensive benefits to all full-time, exempt employees.
• Total target cash compensation between $140,000 and $180,000 per year.
• Potential for stock options and other Charlie Health-sponsored benefits.