Full-Time

Analytics Engineer

Posted on 8/23/2024

Hazel Health

Hazel Health

201-500 employees

Provides student health services through schools

Education
Healthcare

Compensation Overview

$100k - $120kAnnually

Mid

Remote in USA

Remote roles can sit in any of the following states: AZ, CA, CO, DC, DE, FL, GA, HI, IL, ME, MD, MA, MI, MO, NE, NV, NJ, NM, NY, NC, OR, PA, SC, RI, TN, TX, VT, VA, WA, WI. Must live or plan to relocate to one of these states.

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.
  • Preference for healthcare operations and revenue cycle management analytics experience.
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 by collaborating with schools and families. Their services are designed to be accessible at no out-of-pocket cost, ensuring that students can receive care regardless of their insurance status. This approach allows students to access healthcare from both school and home, making it convenient for families. Hazel Health's team includes healthcare professionals who deliver immediate care and support families in managing their child's health needs. The company aims to reduce absenteeism and increase instructional time by helping students stay engaged in their learning. Unlike many competitors, Hazel Health focuses on culturally sensitive care and has demonstrated success in helping students regain significant instructional hours.

Company Stage

Late Stage VC

Total Funding

$84.1M

Headquarters

San Francisco, California

Founded

2015

Growth & Insights
Headcount

6 month growth

0%

1 year growth

-2%

2 year growth

0%
Simplify Jobs

Simplify's Take

What believers are saying

  • Partnership with UnitedHealthcare expands access to 1 million students in 14 states.
  • Clemson University study shows significant reduction in student depression and anxiety symptoms.
  • Growing demand for telehealth services due to the national mental health crisis.

What critics are saying

  • Increased competition from other telehealth providers targeting school-based services.
  • Potential challenges in maintaining data privacy and security for student health records.
  • Reliance on school district partnerships may pose risks if not renewed or funding is reduced.

What makes Hazel Health unique

  • Hazel Health offers culturally sensitive care at no out-of-pocket cost to families.
  • The company provides both physical and mental health services accessible from school and home.
  • Hazel Health partners with schools to reduce absenteeism and increase instructional time.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

401(k) Company Match

Paid Vacation

Remote Work Options

Performance Bonus

INACTIVE