Data Modeling Consultant - Raleigh, NC - Onsite
Role details
Job location
Tech stack
Job description
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.
Requirements
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., 119216-1 Pay Rate Range: $ 48.22 - 49.64/hr on W2 Job Details: Must Have Skills: Data Modelling, DWH, SQL Nice to have skills: DB2, Knowledge on ETL, Erwin or equivalent…
- 1 day ago, Must Have Technical/Functional Skills Proven experience in data migration from On perm to Cloud Good understanding in Version control deployment, DB performance tuning. Strong p…
