Role: Senior Data Modeler
Location:ย Remote (Prefer PST, 2ndย Preference CST) USA
Experience: Minimum 10+ years
As aย Senior Data Modelerย youย will lead data modeling initiatives, support migration to Azure Databricks Lakehouse architecture, establish data governance standards, and partner with business and technical stakeholders to deliver scalable analytics and reporting solutions.
Duties:
- Develop and maintainย Conceptual, Logical, and Physical Data Models.
- Design scalable healthcare payer data models for analytics and reporting.
- Establish enterprise data standards, metadata, naming conventions, and business glossaries.
- Design Lakehouse-based solutions usingย Azure Databricks, Delta Lake, and Medallion Architecture.
- Lead data discovery, source-to-target mapping, and EDW modernization initiatives.
- Support migration from legacy platforms such asย Teradata, Netezza, Oracle, SQL Server, and Hadoop.
- Collaborate with ETL and Data Engineering teams on data ingestion, orchestration, and transformation frameworks.
- Design and optimizeย Power BI semantic models, data marts, star schemas, and snowflake schemas.
- Define KPIs, measures, dimensions, and reporting hierarchies with business stakeholders.
- Implement data governance, lineage, metadata management, and data quality frameworks.
- Ensure compliance withย HIPAA, CMS, PHI/PII, and enterprise governance standards.
- Facilitate client workshops, requirements discussions, architecture reviews, and governance meetings.
- Mentor junior team members and coordinate work across data modeling and engineering teams.
Required:
- Strong experience inย Healthcare Payer domain.
- Expertise inย Conceptual, Logical, and Physical Data Modeling.
- Hands-on experience withย Azure Databricksย and Lakehouse Architecture.
- Experience inย EDW modernization and migration projects.
- Strong knowledge ofย Power BI Semantic Layer Modeling.
- Experience with:ย Star Schema,ย Snowflake Schema,ย Dimensional Modeling,ย Data Marts.
- Knowledge ofย Delta Lakeย andย Medallion Architecture (Bronze, Silver, Gold).
- Experience withย Azure Data Factory (ADF).
- Strong stakeholder management and client-facing communication skills.
- Experience implementing data governance, lineage, and data quality practices.
- Understanding of healthcare compliance standards includingย HIPAA, CMS, and PHI/PII.
VeeRteq Solutions is an Equal Opportunity Employer