Position Title: Data Modeler with ErwinExperience: 5 to 10 YrsShift Schedule: 2 pm to 11 pmDuration Required: 6 months Project (Extendable)Mode: RemoteLocation: Hyderabad OR PuneEmployment Type: Contract 2 HireRole 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.
Job Title
Data Modeler