Data Modeler
Core
Design and maintain enterprise data architecture, logical/physical models, and data strategies for large healthcare organizations, ensuring compliance with regulations like HIPAA and supporting analytics for Medicaid, Medicare, and commercial datasets.
Role type
Senior Health Data Modeler (Data Strategy & Architecture)
Builds
Scalable, standards-compliant data structures, data warehouses, and modernized cloud data platforms (Azure Synapse, Databricks, Snowflake) for public and private sector clients.
Domain
Healthcare / Data Engineering & Architecture
Deliverable
production ML models
Required skills
Data modeling (normalized, dimensional, Data Vault), SQL (advanced, optimization), Data governance & quality, Regulatory compliance (HIPAA, PHI, PII), ERD creation, Metadata management, Cloud data platforms (Azure, Snowflake, Databricks), ETL strategies, Legacy system modernization.
Preferred skills
Azure services, Snowflake, Power BI/Tableau, State Medicaid EDW/MMIS, Teradata Vantage 20, Delta Lake, Microsoft Fabric, AI/ML/GenAI tools, Python/R scripting, Informatica/Azure Data Factory.
Technologies
Azure, Databricks, Snowflake, Informatica, Power BI, Tableau, Python, SQL, GitHub, Microsoft 365, Teradata, Delta Lake, Parquet, Fabric, Copilot.
Responsibilities
Develop long-term data architecture goals and standards; Lead architecture and modeling initiatives for healthcare analytics warehouses; Translate business needs into solution models and define data flows; Design conceptual, logical, and physical models across data layers; Define keys, indexes, partitioning, and constraints for data quality; Create and maintain ERDs, data dictionaries, and lineage records; Ensure data strategies comply with regulations; Oversee source mapping and data movement; Advise stakeholders on solution architecture; Resolve data integration issues; Support migration of legacy models to cloud platforms; Design target-state models using medallion architecture.
Seniority
Senior, hands-on IC
