Position Title: Data Modeler with Erwin
Experience: 5 to 10 Yrs
Shift Schedule: 2 pm to 11 pm
Duration Required: 6 months Project (Extendable)
Mode: Remote
Location: Hyderabad OR Pune
Employment Type: Contract 2 Hire
Role Overview:
We are looking for a detail-oriented Data Modeler to support the consolidation of multiple data marts into a unified enterprise data warehouse for a healthcare payer organization. The role involves working across teams to model core insurance domains such as membership, product, coverage, and claims, using Oracle 21c and Erwin Data Modeler. This is a great opportunity to grow in a collaborative, data-driven environment focused on improving healthcare analytics and operational efficiency.
Key Responsibilities:
- Assist in designing and maintaining conceptual, logical, and physical data models for healthcare payer domains.
- Minimum 5+ years of experience in Data Modeling, hands-on experience with Kimball, Medallion architecture modelling.
- Should have handled 50+ TB implementation using data warehouse concepts along with Data Partitioning techniques.
- Familiarity with healthcare payer data, especially membership, product, coverage, and claims.
- Hands-on experience with Erwin Data Modeler.
- Strong SQL skills and understanding of Oracle 21c database concepts.
- Strong analytical and communication skills.
- Ability to work collaboratively in a team-oriented environment.
- Support the integration and consolidation of data marts related to:
- Membership (enrollment, eligibility, demographics)
- Product (insurance plans, benefit packages)
- Coverage (policy details, coverage tiers, network rules)
- Claims (medical, pharmacy, dental claims, adjudication)
- Collaborate with business analysts, data architects, and ETL developers to gather requirements and translate them into scalable data models.
- Use Erwin Data Modeler/Any other Modelling tool to build and manage models aligned with enterprise standards.
- Work with Oracle to implement and optimize data structures for performance and scalability.
- Ensure models support reporting, analytics, and regulatory compliance.
- Participate in data governance, metadata management, and documentation efforts using tools like Collibra, Alation etc.
- Bachelor's degree in Computer Science, Information Systems, or related field.
Preferred Qualifications
- Exposure to data warehousing concepts and dimensional modeling.
- Experience with data integration tools (e.g., Informatica, Talend).
- Understanding of HIPAA and PHI data handling requirements.
- Knowledge of cloud data platforms (e.g., Snowflake, Databricks) is a plus.
