Remote Senior Data Engineer

Summary

Join Charlie Health in making a tangible impact on the mental health landscape by sourcing, curating, and activating internally and externally sourced datasets as a software engineer on the data team.

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

Responsibilities

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

Benefits

• Health insurance
• Retirement benefits
• Paid time off