Data Modeler – Healthcare Payer (Erwin)
About The Position
Concord is seeking a hands-on Data Modeler to design and maintain data models for a healthcare payer client. The role covers core payer domains such as claims, premiums, and membership, and works with data engineers, analysts, and business stakeholders to translate business requirements into structured models on a modern cloud data platform. The Data Modeler owns model design from the conceptual stage through physical implementation. The position involves designing conceptual, logical, and physical models; building transactional and dimensional models for operational and analytical use cases; and creating, managing, and versioning models in Erwin Data Modeler. The role also partners with engineering teams implementing models in Snowflake and/or Databricks, maintains data dictionaries and modeling documentation, and reviews existing models for performance, consistency, and scalability. The position is remote and open to candidates in the United States. Candidates must be legally authorized to work in the US without sponsorship now or in the future. Compensation is up to $80 per hour W2 or up to $100 per hour C2C, based on relevant experience, skills, and qualifications.
Requirements
- At least 7 years of data modeling experience across transactional and dimensional modeling.
- Hands-on experience with Erwin Data Modeler.
- Exposure to Snowflake and/or Databricks.
- Strong understanding of normalization, star and snowflake schemas, slowly changing dimensions, and fact/dimension design.
- Experience modeling data for a health insurance payer organization.
- Strong SQL skills.
- Ability to work directly with business stakeholders to define requirements.
- Must be authorized to work legally in the United States without sponsorship, now or in the future.
Nice To Haves
- Functional knowledge of claims and/or premium data.
Responsibilities
- Design conceptual, logical, and physical data models for payer domains, including claims, premiums, and membership.
- Build and maintain transactional (OLTP/3NF) and dimensional (star/snowflake schema) models for operational and analytical use cases.
- Create, manage, and version data models in Erwin Data Modeler, including forward and reverse engineering.
- Translate business requirements from claims, finance, and operations stakeholders into model designs and data definitions.
- Partner with data engineering teams to implement models in Snowflake and/or Databricks.
- Maintain data dictionaries, mapping documents, and modeling standards.
- Review existing models and recommend improvements for performance, consistency, and scalability.
Benefits
- Health insurance
- Dental insurance
- Vision insurance
- Employer contributions to Health Savings Accounts (HSA)
- Flexible Spending Accounts (FSA) for healthcare and dependent care expenses
- $200 Lifestyle Spending Account (LSA)
- Fully employer-paid short- and long-term disability insurance
- Employer-provided life and AD&D insurance, with options for additional voluntary coverage
- Employee Assistance Program (EAP)
- Career growth opportunities and skill development
- Team-building events and company-sponsored activities
- Paid time off and company holidays for W2 employees
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
