Senior Healthcare Data Modeler Job at Techvilla Solutions, Eden Prairie, MN

  • Techvilla Solutions
  • Eden Prairie, MN

Job Description

Primary Responsibilities
  • Design and implement enterprise data models and data architecture for large, complex healthcare systems.
  • Translate business and technical requirements into scalable data models and end-to-end data solutions.
  • Develop data strategies, roadmaps, and data management solutions supporting analytics and enterprise reporting.
  • Design normalized OLTP, OLAP, MDM, and dimensional models, including Star schemas, SCDs, role-playing dimensions, hierarchies, and data classification.
  • Develop and review complex SQL queries, stored procedures, DDL, DML, and DCL using ANSI standards.
  • Optimize SQL queries and analyze database performance.
  • Define and implement data quality, profiling, governance, security, metadata management, MDM, archival, and migration strategies.
  • Ensure compliance with healthcare data security and privacy requirements, including HIPAA, PHI, and PII.
  • Collaborate with Data Managers, Data Integration Leads, Data Engineers, and business stakeholders.
  • Provide technical leadership, problem-solving, presentations, and recommendations for complex data initiatives.
Required Skills & Qualifications
  • 8+ years of experience in Data Modeling, Data Architecture, or Data Management.
  • 5+ years of hands-on experience with Erwin Data Modeler.
  • 5+ years of experience working with healthcare data and healthcare information systems.
  • Strong experience with Medicaid, Medicare, and Commercial healthcare datasets; Medicaid experience is highly preferred.
  • 7+ years of advanced SQL experience, including complex queries, stored procedures, DDL, DML, DCL, and query optimization.
  • Strong expertise in OLTP, OLAP, MDM, and dimensional data modeling.
  • Experience with Star schemas, Slowly Changing Dimensions (SCD), role-playing dimensions, dimensional hierarchies, and data classification.
  • Strong knowledge of Data Governance, Data Quality, Data Profiling, Data Security, Metadata Management, MDM, Data Archival, and Data Migration.
  • Strong understanding of HIPAA, PHI, PII, and healthcare data privacy/security requirements.
  • Excellent problem-solving, communication, influencing, presentation, and stakeholder management skills.
  • Ability to work independently and take ownership of complex data initiatives.
Preferred Skills
  • Experience with Microsoft Azure data services, including Azure Data Lake Storage, Azure Data Factory, Microsoft Purview, and Azure Maps.
  • Experience with Snowflake.
  • Experience with Power BI or Tableau.
  • Experience designing and implementing large-scale healthcare data warehouse and analytics solutions.

Job Tags

Contract work

Similar Jobs

Cox Communications

Senior Instructional Designer Job at Cox Communications

 ...:Are you a highly creative and innovative designer of learning? Do you love to imagine how learning can be more interactive and exciting...  ...discipline (Instructional Design, Learning Technology, Curriculum Development, Education) and 4 years' experience in a related field... 

Coffman Engineers, Inc.

Energy Engineer (4+ years) Job at Coffman Engineers, Inc.

 ...At Coffman Engineers, we serve as both prime consultant and sub consultant on projects large and small, including commercial, retail...  ...work. Job Description Coffman Engineers is seeking an Energy Engineer to join our Anchorage office. We are looking for a self... 

Bennett Automotive Group

Automotive Technician - High-Level A Tech / Strong B Tech Job at Bennett Automotive Group

 ...Automotive Technician High-Level A Tech / Strong B Tech in 18103 Automotive Technician High-Level A Tech / Strong B Tech Land...  ...time. We are a well-established luxury automotive service operation in the Lehigh Valley looking for a strong A-level technician... 

Georgetown Hill Early School

Infant & Toddler Preschool Teachers Job at Georgetown Hill Early School

 ...been doing it for over 45 years, and we're just getting started.Why You'll Love Working HereSpoiler alert: we're not your average daycareHere, you get real creative freedom in the classroom, backed by our proven PLAN curriculum . Think structure and spontaneity - a... 

FOREMAN SALES AND SERVICE

Mini School Bus Driver (No CDL Required)... Job at FOREMAN SALES AND SERVICE

 ...Job Description Mini School Bus Driver (No CDL Required) - SIGN ON BONUS Foreman Sales & Service is seeking to IMMEDIATELY hire a Non-CDL Mini School Bus Driver for the Dell Rapids School District (Dell Rapids, SD) during the 2026-2027 school year to safely transport...