Sr. Data Modeler with Data Vault & Insurance domain

Job Title: Sr. Data Modeler with Data Vault & Insurance domain

Skills: Erwin, ETL, SQL, Data Vault
Location: Raleigh, NC (Hybrid)

• 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 scalability.

Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.