Data Engineer

Data Engineer

Full-time, Los Angeles, Boston, or Remote

Heyday Health is hiring a Data Engineer to join our start-up team. We're building a platform to help seniors access world-class primary care through home and virtual visits, and we're passionate about providing exceptional patient experiences and care.

About the role:

As a Data Engineer at Heyday Health, you will be instrumental in building and maintaining our data infrastructure using advanced technologies like Snowflake, DBT, Looker, and Fivetran. You will ensure robust data management systems that support our remote patient care and telehealth applications, along with data-driven primary care coordination. This role requires a blend of technical prowess and collaborative energy to support business-critical analytics and reporting.

What makes you uniquely suited to this role?

You understand how clean, timely data is the oxygen of value based care, and you are passionate about using data to improve the lives of clinicians and patient outcomes. You have a knack for anticipating data needs and understanding the data questions of the organization, then envisioning the right model and implementing a data solution. You can span from business questions to optimal data models to fast SQL code. You can balance the needs of technical perfection and being scrappy to give the organization what it needs when it needs it.

Key Responsibilities

• Oversee the design and architecture of the Heyday data warehouse, providing a reliable data presentation used by the data analysis team. This includes designing and implementing transformations, creating the analytics data model and administering the data warehouse environment.
• ETL Infrastructure Management: Manage data integration using Fivetran, oversee permissions and runtime settings, set up and maintain data ingestion pipelines, and ensure secure data storage solutions in AWS.
• ETL Job Design and Optimization: Develop and optimize ETL jobs to improve data handling efficiency, monitor performance, and adjust processes to support the scalability of healthcare data operations.
• Data-lake Administration and Optimization: Oversee performance in Snowflake environments, focusing on query optimization, indexing, and tuning to enhance data access and processing.
• Data Modeling and Regulatory Compliance: Update and maintain data models for healthcare encounters and claims, ensure compliance with regulatory standards, and execute data migrations and schema updates using DBT.
• Collaboration with Data Analysts: Work closely with data analysts to support workflows for business-critical analysis and reporting, enhancing data accessibility and utility across the organization.
• Collaboration with the rest of the engineering team - providing data modeling and performance best-practices and act as a go-to person for data questions.
• Stakeholder Collaboration: Partner with stakeholders across various departments to gather insights and translate business needs into data-driven solutions that support operational and strategic goals.
• Support for Machine Learning Workflows: Provide data infrastructure and processing support for machine learning projects, ensuring data quality and availability for advanced analytics.

What you bring:

• Bachelor's degree in Computer Science, Data Science, Engineering, or a related field.
• Minimum 3 years of experience as a Data Engineer with expertise in Snowflake, DBT, Looker, and Fivetran.
• Proficient in SQL and experienced with large-scale database management.
• Demonstrable experience in cloud-based ETL processes, particularly in AWS.
• Strong understanding of healthcare data sets, and some experience modeling around healthcare claims and clinical data (EHRs) to support healthcare utilization and economics analyses. Familiarity with healthcare data compliance and HIPAA regulations.
• Strong collaborative skills and ability to communicate effectively with technical and non-technical stakeholders.

COVID-19 considerations:

As a company policy and for the safety of our patients and staff, we require that all employees be fully vaccinated against COVID-19 unless granted a medical or religious exemption.

Salary Range: $120,000-$150,000 (with potential for performance-based bonus)