Lead Data Engineer

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.