Mid-Senior Data Modeler

Remote • Posted 1 hour ago • Updated 19 minutes ago
Contract W2
Remote
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • SQL Server
  • Azure SQL

Summary

Job Title: Mid-Senior Data Modeler
Location: Remote
About the Role:
Client is seeking a skilled Data Modeler with deep Erwin expertise to support a Medicaid Reporting Modernization initiative. You will model complex business rules from large spreadsheets and build a rigorous enterprise data model on Microsoft Azure - transitioning clients from manual, spreadsheet-driven processes to an automated, AI-enabled analytics pipeline.
Key Responsibilities:
  • Lead design of Conceptual, Logical (ERD KB FA), and Physical data models across all business domains
  • Translate complex, formula-driven spreadsheets into formal entity-relationship models
  • Extract and formalize business rules, validation logic, and calculation hierarchies from Excel build files
  • Design physical models with DDL generation for SQL Server, Azure SQL, and Synapse Analytics
  • Use Erwin end-to-end: schema generation, forward/reverse engineering, subject area management, model validation
  • Facilitate data modeling sessions with business SMEs, BAs, data engineers, and architects
  • Produce data dictionaries, ER diagram exports, and data lineage maps as formal deliverables
Required Skills:
  • Mastery of data modeling concepts: ERDs, cardinality, normalization (1NF 3NF), keys, and relationships
  • Proficiency in IDEF1X and Information Engineering (IE) modeling methodologies
  • Hands-on Erwin Data Modeler expertise (mandatory) - mart collaboration, compare/merge, version control
  • Strong database & schema design: primary/surrogate/foreign keys, referential integrity, indexing strategies
  • Ability to reverse-engineer complex spreadsheet structures into Erwin models
  • Business rule & metadata definition: domains, validation rules, business glossary, synonyms/homonyms
  • Experience with Azure SQL, Azure Data Factory, or Synapse Analytics (a plus)
Preferred Qualifications:
  • Erwin certification or formal Erwin training credentials
  • Familiarity with Power BI data model and DAX-layer design
  • Exposure to healthcare, government, or financial reporting data domains
  • Agile/Scrum delivery experience with iterative model versioning
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10106248
  • Position Id: 2026-4081/108688
  • Posted 1 hour ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Remote

Today

Easy Apply

Contract, Third Party

Depends on Experience

Remote

Today

Easy Apply

Contract, Third Party

Depends on Experience

Remote

27d ago

Easy Apply

Contract

Depends on Experience

Remote

13d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs