Posted in

Analytics Engineer

Analytics Engineer

CompanyHomeward Health
LocationSan Mateo, CA, USA
Salary$120000 – $160000
TypeFull-Time
Degrees
Experience LevelMid Level, Senior

Requirements

  • 3-5 years in data engineering roles, preferably within healthcare technology companies or health tech startups.
  • 1-3 years experience with dbt Cloud (or Core) for building and managing data models preferably in a medallion architecture.
  • Experience working with medical data (e.g., claims, EHR data, HCCs, or quality measures) preferably in a value-based care setting.
  • Proficiency in SQL and experience working with Snowflake or other modern cloud data warehouses like Redshift or BigQuery.
  • Proficiency in Python and experience building tools and scripts for data orchestration and transformation.
  • Familiarity with tools like Airbyte, Fivetran, or equivalent for extracting and loading data from a variety of sources.
  • Familiarity with BI solutions like Metabase, Tableau, or PowerBI to support our analytics teams.
  • Ability to collaborate effectively with everyone from engineers and analysts to marketing and sales stakeholders.
  • A genuine passion for leveraging technology to improve healthcare accessibility, equity, and outcomes.

Responsibilities

  • Develop and maintain dbt models in our medallion layers in Snowflake focusing on datasets optimized for reporting and operational use cases.
  • Provide foundational datasets optimized for visualization tools like Tableau and Metabase, enabling downstream teams to build efficient and insightful reports.
  • Design and implement DAGs in Airflow for moving transformed data back into operational tools or external business applications to enhance decision-making.
  • Leverage knowledge of medical and healthcare data (e.g., eligibility, claims, clinical data, risk adjustment) to create meaningful datasets and drive insights.
  • Work with analytics, data science, clinical, and operational teams to understand their reporting and data warehousing needs.
  • Develop and maintain clear documentation for data models, processes, and workflows in dbt and Confluence to ensure transparency and ease of use for other teams.
  • Establish robust data quality checks and monitoring systems to ensure accuracy and reliability of business-ready datasets.
  • Troubleshoot and resolve data discrepancies in collaboration with operational, analytics, or other engineering teams.

Preferred Qualifications

  • Experience building and maintaining data pipelines using Apache Airflow.
  • Experience integrating products with EHR systems, utilizing interoperability standards such as HL7, FHIR, and experience with major EHR platforms like Epic or Cerner.
  • Familiarity with Medicare Advantage, Medicaid, and experience in value-based care settings.
  • Previous experience in high-growth startup environments, navigating rapid scaling and change.