Note: The job is a remote job and is open to candidates in USA. KTek Resourcing is seeking an experienced Clinical Data Modeler with expertise in healthcare claims data and clinical data models. The role focuses on designing and maintaining conceptual, logical, and physical data models, translating healthcare requirements into scalable solutions, and supporting analytics, reporting, integration, governance, and data quality initiatives.
Responsibilities
- Design and develop Conceptual, Logical, and Physical Data Models for healthcare and clinical data
- Work extensively with healthcare claims data, including medical, pharmacy, member, provider, eligibility, and encounter data
- Develop and maintain clinical data models supporting healthcare analytics and reporting
- Analyze business and clinical requirements and translate them into scalable data models
- Define relationships, entities, attributes, keys, constraints, and data definitions
- Create ER diagrams, data dictionaries, mapping specifications, and model documentation
- Collaborate with Data Architects, Data Engineers, Business Analysts, Clinical SMEs, and Analytics teams
- Perform source-to-target data mapping and identify data quality and data lineage requirements
- Support integration of data from multiple healthcare and clinical sources
- Ensure data models follow healthcare industry standards and enterprise data-modeling best practices
- Optimize data structures for analytical workloads, reporting, and downstream data applications
- Participate in data governance, metadata management, and data quality initiatives
Skills
- Strong hands-on experience as a Data Modeler / Data Architect
- Strong experience with Healthcare Claims Data
- Strong understanding of Clinical Data and Clinical Data Models
- Experience with Medical Claims, Pharmacy Claims, Eligibility, Provider, Member, Encounter, Diagnosis, and Procedure data
- Strong knowledge of Conceptual, Logical, and Physical Data Modeling
- Excellent SQL skills and understanding of relational databases
- Experience with ER modeling, dimensional modeling, normalization, and denormalization
- Experience creating data dictionaries, source-to-target mappings, and data lineage documentation
- Strong understanding of healthcare data relationships and terminology
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field
- 5+ years of experience in Data Modeling/Data Architecture
- Strong healthcare domain experience, particularly Claims and Clinical Data, is highly preferred
- Excellent analytical, communication, and stakeholder-management skills
- Experience with healthcare data standards such as FHIR, HL7, ICD-10, CPT, HCPCS, and NDC
- Knowledge of healthcare analytics and clinical reporting
- Experience with EDW / Data Warehouse / Data Lake environments
- Experience with tools such as Erwin, ER/Studio, SAP PowerDesigner, or similar data-modeling tools
- Exposure to Snowflake, Databricks, AWS, Azure, or other cloud data platforms
- Experience with metadata, data governance, and data quality tools
Company Overview
Company H1B Sponsorship