

Ampstek
Senior Data Modeller (Only W2)
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Modeller in Raleigh, NC, on a W2 contract for 10 years of experience. Key skills required include Data Modelling, DWH, and SQL, with nice-to-have knowledge in DB2 and ETL tools.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
Unknown
-
ποΈ - Date
April 22, 2026
π - Duration
Unknown
-
ποΈ - Location
On-site
-
π - Contract
W2 Contractor
-
π - Security
Unknown
-
π - Location detailed
Raleigh, NC
-
π§ - Skills detailed
#ERWin #Metadata #Vault #Data Engineering #Data Vault #"ETL (Extract #Transform #Load)" #Data Quality #Data Lineage #SQL (Structured Query Language) #Data Mart #Scala
Role description
Hi ,
I Hope youβre doing well.
Job Title: Data modeler
Location : Raleigh, NC
Employment Type: Contract
Minimum years of experience: 10 years
If you are interested, please share your resume
β’
β’
β’ sophia@ampstek.com
β’
β’
β’ 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
Thank You
Sophia
sophia@ampstek.com
Hi ,
I Hope youβre doing well.
Job Title: Data modeler
Location : Raleigh, NC
Employment Type: Contract
Minimum years of experience: 10 years
If you are interested, please share your resume
β’
β’
β’ sophia@ampstek.com
β’
β’
β’ 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
Thank You
Sophia
sophia@ampstek.com






