Data Engineer

Trella Health is a company dedicated to empowering meaningful change in healthcare through innovative solutions. They are seeking a skilled Data Engineer to design, build, manage, and operate the infrastructure for their healthcare data platform, focusing on diverse healthcare datasets and supporting analytics products.

Responsibilities:

• Design, implement, and maintain data models, pipelines, and architecture to support current and future product needs – focusing on healthcare datasets such as claims, EHR, BCDA, and CCLF
• Design processes to consolidate data from multiple sources into a single source of truth
• Contribute to data governance policies, standards, and procedures to ensure data quality, security, HIPAA and other regulatory compliance
• Identify and optimize performance bottlenecks in ETL/ELT pipelines – ensuring the long term scalability of pipelines
• Work closely with Data Scientists, Engineers, and business stakeholders to understand requirements and translate them into high-value, technical solutions

Requirements:

• 2+ years of engineering experience
• Core Competencies: Python
• Core Competencies: SQL
• Core Competencies: Apache Spark and PySpark
• Data Modeling & Warehousing Concepts
• OLAP vs OLTP
• Normalized vs Denormalized data, one big table
• SCDs
• Medallion Architecture
• Experience working with dbt or SQLMesh
• Experience with at least one major data platform and warehousing tool such as Databricks or Snowflake
• Awareness of Data Governance and Security concepts
• Discoverability Role Based Access Control
• Tokenization
• Prior experience working with PHI/PII and experience working in audited environments
• HIPAA, SOC2, and HITRUST compliance requirements and implementation
• Healthcare interoperability standards (FHIR, HL7)
• EHR operational data and claims data processing experience