Senior Data Modeler: 3NF & Data Vault Architect

Tricascade Tech; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Tricascade Tech is seeking a Senior Data Modeler to design and govern the Silver layer of the enterprise data lakehouse. You will model using 3NF, Data Vault 2.0, and related patterns, ensuring accurate, scalable, and analytics-ready enterprise entities.

You will partner with Data Architects, Engineers, BAs, and governance teams to ensure traceability and implementation readiness, supporting downstream Gold-layer reporting.

Qualifications

• Bachelor's degree in information systems, computer science, or a related field.
• 5–10 years in data modeling, data architecture, or data engineering.
• 2–3 years hands-on with Medallion Architecture (Bronze/Silver/Gold).
• Strong expertise in 3NF and normalized relational modeling.
• Strong working knowledge of Data Vault 2.0.
• Advanced SQL skills and profiling large datasets.

Responsibilities

• Design, develop, and maintain Silver layer data models.
• Apply 3NF and Data Vault 2.0 patterns.
• Profile source data and map to target schemas.
• Define surrogate keys, historization, and key behavior.
• Ensure governance, lineage, and data quality.

Skills

3NF Modeling

Data Vault 2.0

Medallion Architecture

Advanced SQL

Canonical Modeling

Documentation

Education

Bachelor's degree (Information Systems/CS or related)

Tools

SQLDBM

ERwin

ER/Studio

Databricks

Delta Lake

Spark SQL

Unity Catalog

Job description

Tricascade Tech is seeking a Senior Data Modeler to design and govern the Silver layer of the enterprise data lakehouse. You will model using 3NF, Data Vault 2.0, and related patterns, ensuring accurate, scalable, and analytics-ready enterprise entities.

You will partner with Data Architects, Engineers, BAs, and governance teams to ensure traceability and implementation readiness, supporting downstream Gold-layer reporting.