What you'll own in this role
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.
Build Databricks AI/BI dashboards and help users move off pivot tables and legacy BI tools.
Build and validate clinical registries and cohort logic using ICD-10, SNOMED CT, LOINC and local code sets.
Implement access controls in Unity Catalog, including row-level security and attribute-based policies tied to identity groups.
Ship through Git-based CI/CD with Declarative Automation Bundles (DABs). Write unit and regression tests, and review other engineers' code.
Use AI coding agents to automate source mapping, code generation and testing, and check their output before it ships.
Work directly with client engineers, analysts and clinicians. Run requirements sessions, explain data issues in plain language, and own fixes to closure.
Mentor junior engineers and interns.
Maintain compliance with security and privacy regulations, including HIPAA, Singapore's PDPA and client data residency requirements.
What you bring to the role
5+ years in data engineering, analytics engineering or data warehousing.
2+ years building on Databricks in production: Delta Lake, Unity Catalog, Lakeflow Jobs. Deep experience on a comparable cloud data platform, such as Snowflake or Microsoft Fabric, will also be considered.
Strong SQL, PySpark and Python.
Dimensional modeling you can defend. You've designed star schemas and marts that analysts actually use, and you can explain the tradeoffs to non-technical people.
At least one legacy warehouse or reporting migration to the cloud, including reconciliation and validation.
Dashboard development in Databricks AI/BI, Power BI or Tableau.
Healthcare data experience with EHR sources (Epic Clarity/Caboodle, Oracle Health/Cerner or similar): encounters, diagnoses, procedures, orders and pharmacy.
Git, code review and CI/CD as daily practice.
Microsoft Azure.
Comfort with clients and ambiguity. You can turn an unclear request into a spec and then a working build.
You may also bring this
Databricks Certified Data Engineer Professional or Associate.
Experience with Health Catalyst Ignite or DOS, or a similar healthcare analytics platform.
Oracle PL/SQL and OBIEE, or SQL Server with T-SQL and SSIS.
Immuta or similar attribute-based access control, plus Okta or Microsoft Entra ID.
HL7 v2, FHIR, JSON/XML and REST API integration.
Clinical registries, quality measures or population health analytics.
Building data workflows with LLMs or AI agents.
Public healthcare experience in Singapore or elsewhere in APAC.
Agile/Scrum.
Preferred Experience & Education
Bachelor's degree in Computer Science, Information Systems, Engineering, Health Informatics or a related field.
3+ years working with healthcare data.
Information Security and Compliance Responsibilities
Maintain compliance with training directives required by the organization pertaining to Information Security, Acceptable Use Policy and HIPAA Privacy and Security.
Adhere to and comply with the organizations Acceptable Use Policy.
Safeguard information system assets by identifying and reporting potential and actual security events to the organization Security and Compliance Officers.
The above statements describe the general nature and level of work being performed in this job function. They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.
Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position. If you feel you may be a good fit for the role, even if you don’t meet all of the qualifications, we hope you will apply. If you feel you are lacking the core requirements for this position, we encourage you to continue exploring our careers page for other roles for which you may be a better fit.
At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.