IT Senior Consultant | Database | Data Modeling
Job Location:
Job Location:
Raleigh, WV - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
3 hours ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Job Title: Senior Consultant Database Data Modeling
Work Location : RaleighNC27603
Vendor Rate: 67.52
Contract duration: 6
Target Start Date: 15 May 2026
Does this position require Visa independent candidates only Yes
Job Details:
Must Have Skills
Data Modelling DWH SQL
Nice to have skills
DB2 Knowledge on ETL Erwin or equivalent tool working experience
Detailed Job Description
5-8 Year of relevant experience
Design Hubs Links and Satellites based on business keys and relationships
Translate business requirements into scalable Data Vault 2.0 models
Analyze source systems to identify keys grain and change patterns
Define and enforce naming standards hash keys and metadata rules
Ensure historical tracking auditability and data lineage
Support Raw Vault and Business Vault modeling patterns (PIT bridges effectivity)
Collaborate with Data Engineers on physical design and loading strategies
Identify and address data quality and modeling impacts early
Design models for performance scalability and future extensibility
Align Data Vault models with downstream data marts and analytics needs
Minimum years of experience
5-8 years
Certifications Needed :No
Top 3 responsibilities you would expect the Subcon to shoulder and execute
Collaborate with Data Engineers on physical design and loading strategies
Identify and address data quality and modeling impacts early
Align Data Vault models with downstream data marts and analytics needs
Interview Process (Is face to face required)
No
Any additional information you would like to share about the project specs/ nature of work Project Code :The DMC framework has been created to i
Work Location : RaleighNC27603
Vendor Rate: 67.52
Contract duration: 6
Target Start Date: 15 May 2026
Does this position require Visa independent candidates only Yes
Job Details:
Must Have Skills
Data Modelling DWH SQL
Nice to have skills
DB2 Knowledge on ETL Erwin or equivalent tool working experience
Detailed Job Description
5-8 Year of relevant experience
Design Hubs Links and Satellites based on business keys and relationships
Translate business requirements into scalable Data Vault 2.0 models
Analyze source systems to identify keys grain and change patterns
Define and enforce naming standards hash keys and metadata rules
Ensure historical tracking auditability and data lineage
Support Raw Vault and Business Vault modeling patterns (PIT bridges effectivity)
Collaborate with Data Engineers on physical design and loading strategies
Identify and address data quality and modeling impacts early
Design models for performance scalability and future extensibility
Align Data Vault models with downstream data marts and analytics needs
Minimum years of experience
5-8 years
Certifications Needed :No
Top 3 responsibilities you would expect the Subcon to shoulder and execute
Collaborate with Data Engineers on physical design and loading strategies
Identify and address data quality and modeling impacts early
Align Data Vault models with downstream data marts and analytics needs
Interview Process (Is face to face required)
No
Any additional information you would like to share about the project specs/ nature of work Project Code :The DMC framework has been created to i
