Analytics Engineer

Hazel Health is the nation's largest virtual provider of school-based healthcare services, and has been recognized by Fast Company as “one of the world’s most innovative places to work” in 2023. 

By partnering with districts and health plans across the country, Hazel transforms schools into the most accessible front door to physical and mental healthcare. Today, Hazel's diverse team of licensed providers deliver therapy and medical services virtually (in school or at home) to over four million K-12 students — regardless of their insurance status or ability to pay. Hazel aims to remove all barriers to the mental and physical health care that children need to thrive: in school, at home, and in life.

Helping students and their families feel better takes a team of smart, dedicated people. As an integral member of the Hazel team, you will…

• Make an Impact: Work with a team that is increasing equitable access of quality health care experiences for students and their families
• Enable Scale: Work with a team that is building and professionalizing a high growth high impact social enterprise
• Feel Valued: Work with a team that is being compensated competitively, developed professionally, and celebrated frequently for making a meaningful difference

Check us out at Hazel Health Careers.

The Role

As an Analytics Engineer at Hazel Health, you will play a role in our data-driven growth strategy helping to model our business processes and key metrics to be used by our analysts, data scientists, and business partners to improve decision-making. You will work closely with cross-functional teams to design, implement, and maintain data models that enable seamless workflow automation, analysis, and reporting.

Location: Remote

What You’ll Do:

• 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.

Minimum 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

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 $100,000 to $120,000, a 401k match, healthcare coverage, paid time off, and a broad range of other benefits and perks. Review our benefits at Hazel Health Benefits.

We believe talent is everywhere, and so is opportunity. While we have physical offices in San Francisco and Dallas, we have embraced working remotely throughout the United States. While some roles may require proximity to our San Francisco or Dallas offices, 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 and WI. Please only apply if you live and work full-time in one of the states listed above or plan to relocate to one of these states before starting your employment with Hazel. State locations and specifics are subject to change as our hiring requirements shift.

We are committed to creating a diverse, inclusive and equitable workplace. Hazel Health values the minds, experiences and perspectives of people from all walks of life. We are proud to value diversity and be an equal opportunity employer. Hazel will consider qualified applicants with an arrest or conviction record for employment in accordance with state and local laws and "fair chance" ordinances. For all Hazel positions, a criminal background check is required following a contingent offer of employment. Learn more about working with us at Hazel Health Life.