Analytics Engineer
Hazel Health
Salary
Total compensation for this role is market competitive, with a base salary range of $100,000 to $120,000.
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.
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