Data Modeling Consultant - Raleigh, NC - Onsite - 68252

Data Modeling Consultant

• Raleigh, NC
• Onsite
• 68252 (Raleigh, NC, 27612) | 04/30/2026 Easy Apply

Job Code :

JPC

• 68252 Job Description Data Modeling Consultant
• Data Vault, DWH & SQL
• 68252

Pay Rate:

$40

• $45/hr W2 We have an immediate need for a Data Modeling Consultant in Raleigh, NC 27603 to support enterprise data architecture and modeling initiatives in a dynamic analytics environment.

In this role, you will be responsible for designing and implementing scalable data models using Data Vault 2.0 methodologies. You will build Hubs, Links, and Satellites based on business keys and relationships, while translating complex business requirements into robust data warehouse solutions. The role involves analyzing source systems to identify keys, grain, and change patterns, and ensuring proper historical tracking, auditability, and lineage. You will define naming standards, hash keys, and metadata rules, while supporting both Raw Vault and Business Vault patterns including PIT tables, bridges, and effectivity models. You will collaborate closely with data engineering teams to align physical design and loading strategies, ensure performance optimization, and support downstream analytics and data marts. The ideal candidate should have strong expertise in data modeling, data warehousing, and SQL, along with hands-on experience in Data Vault 2.0 modeling techniques. Familiarity with ETL processes, DB2, and modeling tools such as erwin Data Modeler or similar is preferred. Candidates should have a solid understanding of data quality, lineage, and governance concepts, along with the ability to design scalable and extensible data models. Strong analytical thinking, problem-solving skills, and the ability to collaborate with cross-functional teams are essential. Interested candidates are encouraged to connect with our recruiter Mahalakshmi PRIMUS Global Services Desk

• (972) 753-6500 Ext.

216

Email:

jobs@primusglobal.com