Full-Time

Analytics Engineer

Posted on 8/23/2024

Hazel Health

Hazel Health

201-500 employees

Provides healthcare services for students

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 designed 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 Size

201-500

Company Stage

Late Stage VC

Total Funding

$84.1M

Headquarters

San Francisco, California

Founded

2015

Simplify Jobs

Simplify's Take

What believers are saying

  • Partnership with UnitedHealthcare expands access to 1 million students in 14 states.
  • Increased demand for telehealth services due to rising mental health awareness.
  • Government funding for school health programs supports Hazel Health's expansion efforts.

What critics are saying

  • Increased competition from other telehealth providers targeting school partnerships.
  • Challenges in scaling operations with large partnerships like UnitedHealthcare.
  • Reliance on school district and insurance partnerships poses financial risks if disrupted.

What makes Hazel Health unique

  • Hazel Health offers culturally sensitive care at no out-of-pocket cost to families.
  • The company partners with schools to provide telehealth services accessible from school and home.
  • Hazel Health's services are not dependent on insurance status, broadening its client base.

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

Growth & Insights and Company News

Headcount

6 month growth

2%

1 year growth

1%

2 year growth

6%
PR Newswire
Feb 19th, 2025
Hazel Health Announces Marianna Spanos As New Chief Operating Officer Welcomes Jeremy Delinsky, Iyah Romm, And Jessie Woolley-Wilson To The Board Of Directors

SAN FRANCISCO, Feb. 19, 2025 /PRNewswire/ -- Hazel Health , the nation's largest school-centered telehealth provider, today welcomed Marianna Spanos as Chief Operating Officer and announced the appointment of three prominent industry leaders to its Board of Directors over the last year: Jeremy Delinsky, former COO of Devoted Health; Iyah Romm, founding CEO of Cityblock Health; and Jessie Woolley-Wilson, a renowned education technology leader and entrepreneur.Marianna Spanos, Chief Operating Officer, Hazel HealthMarianna Spanos is a seasoned healthcare executive with a track record of developing and scaling healthcare technology and services companies, including most recently Oscar Health. She brings deep experience in building highly effective, tech-enabled operations that deliver strong results for patients and clients. In her role, Marianna will oversee the implementation and delivery of Hazel's services for key stakeholders, ensuring that Hazel continues to build deep partnerships, support our families and students, and deliver high-quality, clinically validated care."I've focused my career on using innovative technology and services to improve healthcare. As a mother, Hazel's mission deeply resonates - we have a responsibility to deliver better, more accessible, and more affordable care to our students," said Marianna Spanos, Chief Operating Officer, Hazel Health. "I'm honored to be part of the Hazel team that's been working tirelessly with schools across the country to remove barriers to care for all children.""Marianna Spanos' deep experience building technology-enabled healthcare services has set new industry standards for both patient experience and clinical excellence

KCCI
Dec 23rd, 2024
DMPS offers free telehealth counseling services over winter break - and beyond

Des Moines Public School officials have partnered with Hazel Health to provide telehealth counseling services to DMPS families at no cost.

BH Business
Oct 9th, 2024
How Adding 1M Students Through a Partnership with UnitedHealthcare Will Help Hazel Health

UnitedHealthcare's recent partnership with the digital school-focused health care provider Hazel Health will benefit more than just the health plans' members.

Rama On Healthcare
Sep 23rd, 2024
UnitedHealthcare to add school-based mental health support in 14 states

UnitedHealthcare will provide mental healthcare to 1 million children in schools through a partnership with Hazel Health.

Clark County School District
Aug 27th, 2024
Licensed health care available to all CCSD students at no cost

The Clark County School District (CCSD) is proud to offer medical services to all CCSD students at no cost with or without insurance through an agreement with Hazel Health.

INACTIVE