Zenotis Group
Sr. Data Modeler with Insurance Domain
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr. Data Modeler with a 6-month C2H contract in Raleigh, NC (Hybrid). Requires expertise in Erwin, ETL, SQL, Data Vault, and insurance domain experience. Strong data modeling, architecture, and governance skills are essential.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 19, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Raleigh, NC
-
🧠 - Skills detailed
#Data Storage #ERWin #Compliance #Migration #MongoDB #Data Quality #Data Mapping #SQL Server #Normalization #Scala #Metadata #Data Migration #Data Vault #Data Modeling #Database Schema #Oracle #NoSQL #Data Governance #Dimensional Modelling #"ETL (Extract #Transform #Load)" #Data Profiling #Data Lineage #Documentation #Data Management #BI (Business Intelligence) #Visualization #Business Analysis #Databases #Data Integration #Storage #Data Architecture #Data Engineering #SQL (Structured Query Language) #Vault #Physical Data Model #MySQL #Database Performance
Role description
Job Title: Sr. Data Modeler with Data Vault & Insurance domain
Location: Raleigh, NC (Hybrid)
Duration: 6 month C2H
Skills: Erwin, ETL, SQL, Data Vault
• 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.
• Maintain detailed documentation of data models, schemas, and changes to ensure transparency and future
Job Title: Sr. Data Modeler with Data Vault & Insurance domain
Location: Raleigh, NC (Hybrid)
Duration: 6 month C2H
Skills: Erwin, ETL, SQL, Data Vault
• 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.
• Maintain detailed documentation of data models, schemas, and changes to ensure transparency and future
