NEWPosted 5 hours ago

Job ID: JOB_ID_4709

Job Description: Sr. Data Modeler (Insurance Domain)

We are seeking a Sr. Data Modeler with expertise in Data Vault and the Insurance domain for a hybrid role in Raleigh, NC. This is a 6-month contract-to-hire position.

Key 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 is required.
  • Insurance Domain experience is mandatory (experience working with an insurance company is essential). Mortgage industry experience is a plus.
  • 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.
  • Analyze 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 reference.

Required Skills:

  • Erwin
  • ETL
  • SQL
  • Data Vault
  • Insurance Domain experience

Nice to Have:

  • Mortgage industry experience

Special Requirements

Visa Constraints: None specified. Screening Steps: Not specified. Interview Modes: Not specified. Domain Restrictions: Insurance Domain required. Employment Type: 6 month C2H (Contract to Hire). Location: Raleigh, NC (Hybrid).

Compensation & Location

Salary: $70,000 – $100,000 per year (Estimated)

Location: Raleigh, NC

Recruiter / Company – Contact Information

Email: h.tek2@gmail.com

Interested in this position?
Apply via Email

Recruiter Notice:
To remove this job posting, please send an email from
h.tek2@gmail.com with the subject:

DELETE_JOB_ID_4709

to delete@join-this.com.