Senior Data Modeller (Only W2)

Ampstek
Raleigh, NC

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

// // //