Description

Core Skills

• 5+ years of data modeling experience in complex enterprise or multi-domain environments
• Strong proficiency in logical and physical data modeling — ER modeling, normalization, dimensional modeling
• Experience modeling for multiple implementation patterns: OLTP relational, dimensional warehouse, and lakehouse or medallion architectures
• Hands-on with relational databases — PostgreSQL, SQL Server, or Oracle
• Proficiency in SQL — writing, reviewing, and optimizing queries and DDL scripts
• Experience with data modeling tools: ERwin, draw.io, dbt, or equivalent
• Familiarity with event-driven data design and schema registries (Confluent, AWS Glue, or similar)

Collaboration and Communication

• Ability to work directly with domain SMEs and engineers to gather requirements and validate models
• Clear communicator — comfortable explaining model decisions and trade-offs in design reviews
• Detail-oriented — consistent in naming, documentation, and standards application

Preferred

• Experience in government healthcare programs such as Medicaid, CHIP, or Medicare
• Familiarity with healthcare transaction data: claims (professional, institutional, pharmacy), eligibility, provider, or enrollment
• Knowledge of healthcare data standards: X12 EDI, NCPDP, FHIR R4, or HL7
• Background in MMIS, claims processing systems, or health plan administration is a strong advantage but not required
• Experience with Python for data profiling, validation scripts, or pipeline support

Key Skills

Education

Bachelor's degree