Apply on Employer Site

Coforge · 4 hours ago

Sr. Data Modeler with Data Vault & Insurance domain

Raleigh, NC

Full-time

Hybrid

Senior Level, Lead/Staff

9+ years exp

Coforge is hiring a Sr. Data Modeler with expertise in Data Vault and experience in the insurance domain. The role involves designing and maintaining data models, collaborating with stakeholders, and ensuring compliance with data governance policies.

Artificial Intelligence (AI)Software

H1B Sponsor Likely

Hiring Manager

Ravi Kumar Singh

Responsibilities

Design, develop, and maintain conceptual, logical, and physical data models to support business needs and objectives across various domains

Expertise in Data Vault modelling

Insurance Domain experience is required ( please look for someone who has worked with insurance company. ). Nice to have Mortgage industry experience

Implement best practices for data modelling, including normalization, de-normalization, and dimensional modelling, to support efficient data storage and retrieval

Collaborate with stakeholders, including business analysts, data architects, and application developers, to gather and define data requirements

Create and optimize database schemas and data structures to ensure data consistency, accuracy, and integrity

Lead the design and implementation of complex data architectures for enterprise-level systems, ensuring scalability and performance

Develop and maintain data dictionaries, data lineage documentation, and metadata repositories to support data governance and standardization efforts

Perform data mapping and data profiling to ensure data quality and consistency across systems and environments

Work closely with ETL developers to design data integration strategies, ensuring seamless data flow between source and target systems

Utilize data modeling tools such as Erwin, PowerDesigner, or similar to create, modify, and maintain data models and data flow diagrams

Provide guidance and mentorship to junior data modelers and data engineers, promoting best practices and methodologies

Ensure compliance with data governance policies, industry standards, and regulatory requirements for data management and privacy

Support data migration efforts by creating detailed data mapping and transformation rules between legacy and target systems

Experience in modelling for various databases, including relational (SQL Server, Oracle, MySQL) and NoSQL (MongoDB, Cassandra) systems

Collaborate with BI and reporting teams to ensure data models support advanced analytics, reporting, and visualization needs

Analyse and optimize existing data models and database performance, identifying bottlenecks and making recommendations for improvement

Qualification

Data VaultSQLETLErwinInsurance Domain

Required

9+ years of experience

Design, develop, and maintain conceptual, logical, and physical data models to support business needs and objectives across various domains

Expertise in Data Vault modelling

Insurance Domain experience is required (please look for someone who has worked with insurance company)