Simplify Logo

Full-Time

Analytics Engineer

Confirmed live in the last 24 hours

Hazel Health

Hazel Health

201-500 employees

Provides student health services through schools

Hardware
Biotechnology
Education
Healthcare

Compensation Overview

$100k - $120kAnnually

+ 401k Match + Healthcare Coverage + Paid Time Off + Other Benefits and Perks

Mid, Senior

San Francisco, CA, USA + 1 more

Category
Data Analysis
Data Engineering
Data & Analytics
Required Skills
Python
Git
SQL
Data Analysis
Snowflake
Requirements
  • 2-5 years of experience in an analytics focused role - analytics engineer, data engineer or analyst / consultant with a strong engineering background.
  • 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 creating, maintaining and learning from internal documentation.
  • Hands-on experience improving data quality, security, and performance.
  • Desire to continually keep up with advancements in analytics engineering practices.
  • Hands-on experience using GitHub.
Responsibilities
  • Proactively design, build, and maintain data transformations using dbt for analytics and empower end users to do self-service reporting and data exploration.
  • Leverage software engineering best practices and technical knowledge to optimize performance of our ELT process and automate analytic workflows.
  • Collaborate with data analysts, data engineers, and business stakeholders to determine data requirements for downstream analyses and projects.
  • Support company-wide efforts to improve data quality, accessibility, and governance.
  • Implement data quality checks and monitoring to ensure the accuracy, completeness, and reliability of integrated data.
  • Contribute to the improvement of data team best practices, workflows, and documentation to ensure we are building a sustainable and scalable data function.
  • Troubleshoot and communicate data issues and processes to internal stakeholders.
  • Optimize performance and scalability of data infrastructure to support growing volumes of data and evolving business needs.

Hazel Health provides physical and mental health care services specifically for K-12 students and their families. The company collaborates with schools to offer these services at no out-of-pocket cost, ensuring that care is accessible both at school and home. This approach allows students to receive necessary health support without being limited by their insurance status. Hazel Health's team includes healthcare professionals who deliver immediate care and assist families in understanding treatment plans. The company also connects students with licensed therapists for mental health support. Unlike many competitors, Hazel Health focuses on culturally sensitive care and aims to reduce absenteeism by helping students return to class more quickly. The ultimate goal is to enhance students' academic engagement and success by addressing their health needs.

Company Stage

Series C

Total Funding

$94M

Headquarters

San Francisco, California

Founded

2015

Growth & Insights
Headcount

6 month growth

6%

1 year growth

15%

2 year growth

69%
Simplify Jobs

Simplify's Take

What believers are saying

  • Hazel Health's services have helped students regain over 70,000 hours of instructional time, demonstrating a significant positive impact on education.
  • Partnerships with major organizations and school districts, such as UnitedHealthcare and UCISD, provide financial stability and growth opportunities.
  • Third-party analyses, like the one from Clemson University, validate the clinical effectiveness of Hazel Health's teletherapy programs, boosting its credibility and appeal.

What critics are saying

  • Dependence on partnerships and external funding could pose financial risks if these relationships change or dissolve.
  • The need to continuously integrate culturally sensitive care and mental health services may strain resources and operational capacity.

What makes Hazel Health unique

  • Hazel Health offers culturally sensitive care at no out-of-pocket cost, making healthcare accessible regardless of insurance status, unlike many competitors.
  • The company's focus on reducing absenteeism by providing immediate healthcare services directly in schools and homes sets it apart from traditional healthcare providers.
  • Hazel Health's partnerships with school districts and organizations like UnitedHealthcare and Superior HealthPlan enhance its ability to deliver comprehensive care to a broad student population.