Senior Data Engineer

Job Description

Job Description

Why Charlie Health?

Young people across the nation are grappling with a mental health crisis characterized by escalating rates of depression, anxiety, trauma, substance use disorders, and suicide.

Individuals who seek support are met by geographical and financial barriers, driving increased urgency for a new approach to behavioral health treatment.

At Charlie Health, our mission is to connect the world to life-saving mental health treatment. Our treatment programs combine curated peer groups, individual therapy, and family therapy into personalized, evidence-based treatment plans to provide long-term healing from home.

By prioritizing connections among young people with shared mental health experiences and goals, Charlie Health fosters sustainable healing and achieves industry-leading clinical outcomes, with over 90% of our clients seeing improvement in their most severe mental health symptoms.

Every member of the Charlie Health team is fueled by an unwavering passion for our mission. If you share this commitment, we invite you to join us in making a tangible impact on the mental health landscape.

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.

Our team is comprised 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.

We are looking for a candidate who is inspired by our mission and excited by the opportunity to build a business that will impact millions of lives in a profound way.

Duties & Essential Job Functions

• 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
• Collaborate with data architects and feature development teams to produce db designs suitable for analytics use cases
• 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 Information Systems, Computer Science, Data Science, Analytics, Mathematics, or equivalent practical experience
• 8+ years experience as a software engineer, with at least 4 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
• Proficiency in database design; both warehouse (Kimball, Inman), and transactional systems (3NF)
• 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 #LI-Remote
• Please note : candidates located within 75 minutes' commuting distance of our NYC office are expected to come to office 1 day / week

Charlie Health does not provide visa sponsorship.

Benefits

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

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

Our Values

• Connection
• Care deeply
• We care personally about every single person in the Charlie Health ecosystem : our clients, providers, and team members alike.
• Inspire hope
• We inspire hope with every interaction, reminding our clients that we truly and unconditionally believe in them.
• Congruence
• Stay curious
• 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.
• Heed the evidence
• 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
• We work as swiftly as possible. The mental health crisis is relentless, and so are we.
• Don't give up
• 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.