Data Engineer

Heyday Health is looking for 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. 

We are a virtual-first primary care practice dedicated to improving the primary care experience for seniors as well as our providers. We founded Heyday Health because we saw the health system leaving our elderly loved ones behind and were driven to create a better solution. Our practice is being built from the ground up with the mission of transforming how, where, and when we deliver care to achieve exceptional outcomes.

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. 

The role will include the following responsibilities, but not be limited to:

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

Required Qualifications

• 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.
• Proficiency 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: We are a virtual-first team, however we require all providers and employees to be fully vaccinated, unless granted a religious or medical exemption. Full PPE is provided for any face-to-face interactions.

Benefits Include:

• Monthly wellness stipend
• Flexible and generous PTO
• Health insurance benefits
• Paid parental leave 
• Contingency child care reimbursements 
• 401(k) and 401(k) matching
• Professional development support

Job Type: Full-time, permanent 

Location: Los Angeles, Boston, or Remote in the USA

Salary Range: $120,000-$150,000 per year with potential for performance-based bonus.