Full-Time

Analytics Engineer

Posted on 8/23/2024

Hazel Health

Hazel Health

201-500 employees

Provides healthcare services for students

Compensation Overview

$100k - $120k/yr

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 from both school and home, ensuring that students can receive care without any out-of-pocket costs, regardless of their insurance status. This approach allows Hazel Health to reach a wider range of students and families. The company employs a team of healthcare professionals, including doctors and therapists, who deliver immediate care and support to students, helping them address their health needs effectively. By focusing on reducing absenteeism and increasing instructional time, Hazel Health aims to keep students engaged in their learning. Their unique partnership model with schools and emphasis on culturally sensitive care sets them apart from other healthcare providers in the education sector.

Company Size

201-500

Company Stage

Late Stage VC

Total Funding

$86.5M

Headquarters

San Francisco, California

Founded

2015

Simplify Jobs

Simplify's Take

What believers are saying

  • Partnership with UnitedHealthcare expands mental health services to 1 million students.
  • Marianna Spanos' appointment as COO enhances operational efficiency and service delivery.
  • Collaboration with large districts like Chicago Public Schools increases reach and impact.

What critics are saying

  • Increased competition from other telehealth providers may impact market share.
  • Scaling operations for new partnerships could strain resources and affect service quality.
  • Reliance on school district partnerships poses financial risks if not renewed.

What makes Hazel Health unique

  • Hazel Health partners with schools to provide healthcare at no out-of-pocket cost.
  • The company offers culturally sensitive care accessible from both school and home.
  • Hazel Health's services are not dependent on the student's insurance status.

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

3%

1 year growth

2%

2 year growth

4%
Iredell Free News
Mar 26th, 2025
NCDHHS partnering with Hazel Health to provide virtual mental health services for K-12 students

NCDHHS partnering with Hazel Health to provide virtual mental health services for K-12 students.

PR Newswire
Mar 26th, 2025
Ncdhhs Partners With Hazel Health To Provide Virtual Mental Health Services For K-12 Students In North Carolina

RALEIGH, N.C., March 26, 2025 /PRNewswire/ -- The North Carolina Department of Health and Human Services today announced students across North Carolina will soon have access to high-quality, virtual mental health care through Hazel Health. This initiative, supported through an investment by UnitedHealthcare, is part of a broader effort announced last year to provide virtual school-centered mental health care for up to one million students across select states nationwide

Hazel
Mar 20th, 2025
Chicago Public Schools Partners With Hazel Health

Chicago Public Schools partners with Hazel Health.

Edison Wildcats
Mar 18th, 2025
Edison Local School District Partners with Hazel Health to Provide Free Online Therapy for Students

Edison Local School District partners with Hazel Health to provide free online therapy for students.

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

INACTIVE