Data Engineer

Garner Health; New York (NY); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Flexible PTO

Hybrid and remote work

401(k) plan with company match

Parental leave (12 weeks)

Mortgage assistance

Job summary

Garner Health seeks a Data Engineer III to join our Engineering team with a high sense of ownership. You will build, optimize, and maintain data pipelines powering our business, and define reusable datasets for BI, Marketing, and Data Science research.

You will design a federated data validation framework and champion data privacy and security within AWS-based systems, working across the data stack.

Qualifications

• Experience with a modern data stack and implementations of data pipelines using Python and SQL in AWS.
• 2+ years of software/data engineering experience across distributed data processing, data warehousing, governance, privacy, and quality.
• Ability to work on high-urgency, mission-driven teams with authentic feedback.
• Experience with orchestration tools and core databases/warehouses like Airflow and Snowflake.

Responsibilities

• Build, optimize, and maintain data pipelines powering the business.
• Define and build abstracted reusable datasets for BI, Marketing, and Data Science research.
• Design and evangelize a federated data validation framework to monitor data quality.
• Protect users’ privacy and security through best practices.

Skills

Data engineering

Python

SQL

Distributed processing

Data warehousing

Data governance

HIPAA familiarity

Tools

Airflow

PostgreSQL

Snowflake

Terraform

Airbyte

Spark

Job description

• We are seeking an exceptional Data Engineer III to join our Engineering team, with a high sense of ownership who is excited about our mission, eager to learn and teach others, and can deliver across the tech stack
• Build, optimize, and maintain data pipelines that power our business
• Define and build out abstracted reusable data sets to be used for Business Intelligence, Marketing, and Data Science Research
• Design, build, and evangelize a federated data validation framework to be used to monitor potential data inconsistencies
• Protect our users’ privacy and security through best practices
• What you’ll get here:
• You’ll work on problems that matter, at a company working to change healthcare at scale
• You’ll work at the intersection of AI and systemic healthcare reform, where the problems we solve are as interesting and compelling as the mission
• At Garner, you’ll take on real, ambitious problems with real ownership and autonomy, alongside exceptional, principles-based people who genuinely want you to win. It’s demanding by design
• . You’ll be challenged to stretch beyond what you thought possible and receive consistent coaching to help you grow and do the best work of your career
• This isn’t the right fit for everyone, and that’s intentional
• The people here are driven by what’s at stake for real people, and that’s what gives our intensity its purpose
• Technologies we use:
• Postgres/SQL, Snowflake, Python, AWS, Terraform, Argo, Airflow, Spark, DuckDB, Iceberg, Airbyte, DBT, ElasticSearch (aka OpenSearch), OpenTelemetry, Looker
• This is a unique opportunity to join a fast-growing company in a transformative role, helping shape the future of healthcare

Benefits

• Flexible PTO
• Garner for Garner (employees enrolled in a Garner medical plan gain access to the Garner benefit to find Top Providers and get reimbursed for eligible expenses)
• Hybrid and remote work
• Team meets twice each year to spark innovation and foster belonging
• Variety of social programs beyond work hours
• Equal paid parental leave (12 weeks) following the birth, adoption or placement of a child
• 401(k) plan with a 2% company match and immediate vesting
• Other financial benefits such as Flexible Spending Accounts and mortgage assistance

The ideal candidate should have experience with a modern data stack and implementations of data pipelines using Python and SQL in AWSExpertise in SQL and Python2+ years of software/data engineering experience (distributed data processing, data warehousing, data governance, Big Data, data variance, data privacy, and data quality)A desire to be a part of a high-performing, mission-driven team that operates with intense urgency, a strong sense of individual accountability, and a commitment to authentic feedbackExperience working with orchestration tools (especially Airflow), databases (especially PostgreSQL), data warehouses (especially Snowflake)Expertise in building scalable data pipelines, query optimization, data modeling, and defining reusable datasetsFamiliarity with healthcare or insuranceFamiliarity with SQL tuning, medallion/event-driven architectures, and telemetryFamiliarity with data security and HIPPA compliance