Description

You will design and implement data architectures for complex healthcare datasets within a multi-tenant environment.

Responsibilities

• Create conceptual, logical, and physical data models for healthcare subject areas.
• Develop physical database objects including indexing strategies, triggers, stored procedures, and UDFs.
• Manage schema migration processes and coordinate implementation with development and SRE teams.
• Profile queries and break down query plans to optimize performance for high-concurrent workloads.
• Advise data engineering teams on high-volume data ingestion and transformation pipelines.

Required Skills

• 2+ years of experience in data modeling and database management.
• Translate healthcare data and Implementation Guides (IG) into Entity Relationship models.
• Strong working knowledge of Healthcare Informatics, specifically HL7 FHIR at all levels.
• Experience with MPP or columnar platforms such as Redshift, Azure, or Snowflake.
• Hands-on expertise with Postgres and MS SQL.
• Experience managing multi-terabyte databases and high-volume migrations from traditional to columnar platforms.
• Knowledge of data partitioning, clustering keys, and distribution concepts in MPP environments.
• Understanding of data governance and CI/CD best practices.

Preferred Skills

• Experience designing storage patterns for LOB data structures.
• Experience working within multi-tenant platforms.

Key Skills

Education

Any Gradute