Data Engineer

Hazel Health, the national leader in school-based telehealth, was founded in 2015 to address systemic inequities in healthcare access, and ensure all children can get the quality care they need and deserve. We leverage digital health technology to provide on-demand physical and mental health care services to over 2 million students in school districts across the country.

Physical and mental telehealth has become more relevant in the lives of children than ever before. Hazel is experiencing tremendous company growth as we respond to our nation’s call for equitable, affordable, and safe virtual access to healthcare.

We are a mission-driven team of healthcare and business leaders, educators, and tech innovators, bringing together our unique skills in a meaningful way to do good in the world. Please consider joining us to share your gifts and talents with a growing and diverse organization, working to make healthcare available to all students.

The Role: Data Engineer

Location: Remote

About This Role:

As a Data Engineer at Hazel Health, you will play a crucial role in our growth strategy by expanding partnerships through the efficient and reliable integration of new data sources. You will work closely with cross-functional teams to design, implement, and maintain data pipelines and infrastructure that enable seamless data integration, analysis, and reporting.

What You’ll Do:

• Proactively and independently design, develop, and maintain scalable, efficient, reliable, and automated data pipelines using AWS services such as AWS Glue, Data Pipeline, and Lambda to ingest, process, and transform data from internal databases, SaaS applications, and external partners.
• Implement data quality checks and monitoring to ensure the accuracy, completeness, and reliability of integrated data.
• Optimize performance and scalability of data infrastructure to support growing volumes of data and evolving business needs.
• Work closely with Data Analysts and Analytics Engineers to facilitate access to integrated data for data modeling and analysis purposes while mentoring them on analytics engineering best practices.
• Collaborate with other functions to ensure data needs are addressed.
• Stay current with emerging technologies and best practices in data engineering, and recommend improvements to enhance data integration processes and capabilities.

About You:

• 5+ years hands-on experience deploying production quality code.
• Professional experience using Python or Java for data processing (Python preferred).
• Advanced SQL skills, including schema design, management  and migration. Familiar with standard data types, variant types (json, xml) and Snowflake-flavored syntax and features (stages, external functions, snowpipe, python UDFs, external tables, etc.).
• Advanced hands-on experience building dbt models, maintaining dbt projects and managing dbt workflows. Obtained dbt Cloud Administrator Certification or dbt Analytics Engineering Certification is a plus.
• Hands-on data modeling skills and familiarity with the Kimball methodology.
• Hands-on experience implementing ETL/ELT tools (Fivetran, AWS Services, dbt) and best practices at scale.
• Hands-on experience standing up and operating an orchestration tool (Airflow, Dagster, Prefect, dbt Cloud).
• Hands-on experience creating, maintaining and learning from internal documentation. 
• Hands-on experience improving data quality, security, and performance.
• Desire to continually keep up with advancements in data engineering practices.
• Hands-on experience using GitHub.
• Nice to have familiarity with deploying machine learning and data science models.

We are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role but your past experience doesn’t align with every qualification in the job description, we encourage you to apply anyway. 

Total compensation for this role is market competitive, with a base salary range of $125,000 to $145,000, a management bonus, a 401k match, healthcare coverage, paid-time off, and a broad range of other benefits and perks. Peruse our benefits at Hazel Health Benefits.

Hazel’s Core Values:

• Exceptional Partnership: We seek to understand, align, and then work to exceed the highest expectations of those we serve.

• Always Accountable: We set high standards for ourselves and each other and deliver. We do what we say we are going to do.

• Make it Happen: Every