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