Data Modeling Advisor

2 days ago


Hyderabad, Telangana, India Evernorth Full time

About Evernorth:

Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention, and treatment of illness and disease more accessible to millions of people.

Data Modeling Advisor
Position Summary:

The Health Services Data Design and Metadata Management team is hiring an Architecture Senior Advisor to work across all projects. The work involves understanding and driving data design best practices, including data modeling, mapping, and analysis, and helping others to apply them across strategic data assets. The data models are wide-ranging and must include the appropriate metadata to support and improve our data intelligence. Data design centers around standard health care data (eligibility, claim, clinical, and provider data) across structured and unstructured data platforms.

Job Description & Responsibilities:

  • Perform data analysis, data modeling, and data mapping following industry and Evernorth data design standards for analytics/data warehouses and operational data stores across various DBMS types, including Teradata, Oracle, Cloud, and Hadoop, Databricks and datalake.
  • Perform data analysis, profiling and validation, contributing to data quality efforts to understand data characteristics and ensure data correctness/condition for use.
  • Participate in and coordinate data model metadata development processes to support ongoing development efforts (data dictionary, NSM, and FET files), maintenance of data model/data mapping metadata, and linking of our data design metadata to business terms, data models, mapping documents, ETL jobs, and data model governance operations (policies, standards, best practices).
  • Facilitate and actively participate in data model/data mapping reviews and audits, fostering collaborative working relationships and partnerships with multidisciplinary teams.
  • Provide guidance, mentoring, and training as needed in data modeling, data lineage, ddl code, and the associated toolsets (Erwin Data Modeler, Erwin Web Portal, Erwin model mart, Erwin Data Intelligence Suite, Alation). Assist with the creation, documentation, and maintenance of Evernorth data design standards and best practices involving data modeling, data mapping, and metadata capture including data sensitivity, data quality rules, and reference data usage. Develop and facilitate strong partnerships and working relationships with Data Governance, delivery, and other data partners. Continuously improve operational processes for data design metadata management for global and strategic data.
  • Interact with Business stakeholders and IT in defining and managing data design. Coordination, collaboration, and innovation with Solution Verticals, Data Lake teams, IT & Business Portfolios to ensure alignment of data design metadata and related information with ongoing programs (cyber risk and security) and development efforts.

Experience Required:

  • 11 to 13 years' experience with data modeling (logical / physical data model, canonical structures, etc.) and SQL code;

Experience Desired:

  • Subject matter expertise level experience preferred
  • Experience executing data model / data lineage governance across business and technical data.
  • Experience utilizing data model / lineage / mapping / analysis management tools for business, technical and operational metadata (Erwin Data Modeler, Erwin Web Portal, Erwin Model Mart, Erwin Data Intelligence Suite, Alation
  • Experience working in an Agile delivery environment (Jira, Confluence, SharePoint, Git, etc.)

Education and Training Required:

  • Advanced degree in Computer Science or a related discipline and at least six, typically eight or more years experience in all phases of data modeling, data warehousing, data mining, data entity analysis, logical data base design and relational data base definition, or an equivalent combination of education and work experience.

Primary Skills:

  • Physical Data Modeling, Data Warehousing, Metadata, Reference Data, Data Mapping
  • Data Mining, Teradata, Data Quality, Excellent Communication Skills, Data Analysis, Oracle
  • Data Governance, Database Management System, Jira, DDL, Data Integration, Microsoft, SharePoint, Database Modeling, Confluence, Agile, Marketing Analysis, SharePoint, Operations, Topo, Data Lineage, Data Warehouses, Documentation
  • Big Data, Web Portal, Maintenance, Erwin, SQL, Unstructured Data, Audit, Git, Pharmacy
  • DBMS, Databricks, AWS


  • Hyderabad, Telangana, India NTT DATA Full time

    Req ID 297943NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Data Backup Data Protection and Recovery-RubrikSystems Integration Advisor to join our team in hyderabad Telangana ...

  • Data Modeler

    3 weeks ago


    Hyderabad, Telangana, India LLP S3BGLOBAL TECHNOLOGIES Full time

    Job Title - Data ModelerLocation - (Onsite)Interview Mode- Video Duration: 6 Months Contract to hirePosition Overview:Key Responsibilities:- Understand conceptual, logical, and physical data models.- Leverage's inventory of data sources and ensure its map is correctly aligned with the Data Model- Understand data and prepare data transformation logics and...

  • Data Modeler

    3 weeks ago


    Hyderabad, Telangana, India Anblicks Full time

    Job DescriptionJob Title: Data ModelerExperience Required: 7+ YearsLocation: [Specify Location]Job Summary:We are looking for a highly skilled Data Modeler with strong experience in data integration tools such as IBM Datastage and Talend. The ideal candidate will be responsible for designing and implementing scalable data models that support enterprise data...

  • Data Modeler

    3 weeks ago


    Hyderabad, Telangana, India Anblicks Full time

    Job Title: Data ModelerExperience Required: 7+ YearsLocation: [Specify Location]Job Summary:We are looking for a highly skilled Data Modeler with strong experience in data integration tools such as IBM Datastage and Talend. The ideal candidate will be responsible for designing and implementing scalable data models that support enterprise data architecture,...

  • Data Modeler

    3 days ago


    Hyderabad, Telangana, India beBeeDataModeling Full time ₹ 9,00,000 - ₹ 12,00,000

    Data Modeler Position Overview">">Job Title: Data SpecialistThis role involves working with a team to design, develop, and maintain data models for the SAP HANA environment. The position requires strong expertise in data modeling and experience with Power BI.Key Responsibilities:To create reports and dashboards in Power BI using data models and CDS views.To...

  • Data Modeler

    2 weeks ago


    Hyderabad, Telangana, India Anblicks Full time

    Job Title: Data Modeler Experience Required: 7+ Years Location: (Specify Location) Job Summary: We are looking for a highly skilled Data Modeler with strong experience in data integration tools such as IBM Datastage and Talend. The ideal candidate will be responsible for designing and implementing scalable data models that support enterprise data...

  • Data Modeler

    4 days ago


    Hyderabad, Telangana, India Anblicks Full time

    Key Responsibilities:· Design and develop enterprise-grade data models (3NF, Dimensional, and Semantic) to support analytics and operational use cases· Collaborate with business and engineering teams to define data products aligned to business domains· Translate complex mortgage banking concepts into scalable and extensible models· Ensure alignment...

  • Data Modeler

    4 weeks ago


    Hyderabad, Telangana, India Prudent Technologies and Consulting, Inc. Full time

    We are seeking an experienced Data Modeler with a strong background in real estate, investment management, and master data management. The ideal candidate will be responsible for designing, implementing, and maintaining data models that support our business objectives. This role requires a deep understanding of data architecture, data integration, and...

  • Data Modeler

    2 days ago


    Hyderabad, Telangana, India beBeeDataModeling Full time US$ 8,00,000 - US$ 12,50,000

    Data Modeling ExpertWe are seeking an accomplished Data Modeling Expert to join our team.Design and develop robust data models to support business intelligence and operational use cases.Collaborate with cross-functional teams to define data products aligned to business domains.

  • Data Modeler

    2 weeks ago


    Hyderabad, Telangana, India Anblicks Full time

    Key Responsibilities: · Design and develop enterprise-grade data models (3NF, Dimensional, and Semantic) to support analytics and operational use cases · Collaborate with business and engineering teams to define data products aligned to business domains · Translate complex mortgage banking concepts into scalable and extensible models · Ensure...