Analytics Engineer

Full-time - Mid Level

San Francisco Bay Area, CA

Professional, Scientific, and Technical Services

About the position

Join us in tackling healthcare for rural America! We're seeking an Analytics Engineer who is passionate about having positive societal impact starting at the local level, solving issues of health inequity for communities that have been perennially underserved.

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.

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.

Nice-to-haves

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

Benefits

• Competitive salary, equity grant, generous paid time off
• Comprehensive benefits package including medical, dental & vision insurance with 100% of monthly premium covered for employees
• Company-sponsored 401k plan
• Flexible working arrangement