- Singapore
- Hybrid
- Full-time · Senior
- 5+ years
The Senior Data Engineer builds and runs the data layer behind Health Catalyst Ignite for healthcare clients in Asia Pacific. Ignite runs on Azure Databricks. You'll design the data marts, pipelines and dashboards that clinical, operational and finance teams report from, and you'll move large reporting estates off legacy Oracle and SQL Server warehouses onto Databricks.
Responsibilities
- Design dimensional data marts (star schemas, conformed dimensions, slowly changing dimensions) on Health Catalyst's healthcare data model, for areas like pharmacy, quality, finance and operational KPIs.
- Extend the core model by clinical domain, so each hospital or institution adds its own columns instead of maintaining a separate copy.
- Build, tune and maintain pipelines on Azure Databricks with PySpark, Spark SQL, Delta Lake and Lakeflow Jobs, through bronze, silver and gold layers, with an eye on compute cost.
- Migrate legacy reports and ETL to Databricks. Translate the SQL and PL/SQL, rebuild the logic, and reconcile outputs against the old system until the numbers match.
- Ingest new sources such as EHR extracts, ERP data and flat files. Design incremental loads that don't drop late-arriving or frequently updated records.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, Health Informatics or a related field
- Nice to have: Snowflake
- Nice to have: Microsoft Fabric
- Nice to have: Power BI
- Nice to have: Tableau