Sr.Data Modeler

Silver Layer Data Modeling

The Senior Data Modeler will design, develop, and maintain conceptual, logical, and physical data models for the Silver layer of the enterprise data lakehouse built on Medallion Architecture.

Normalized (3NF) Entity Design

Design 3NF entities for master, reference, transactional, association, episode, and event-history data.

Data Vault 2.0 Design

Apply hubs, links, satellites, business keys, and historization where appropriate.

Source Data Profiling

Profile source data to confirm grain, keys, relationships, cardinality, completeness, code domains, and data-quality issues.

Source-to-Target Mapping

Create attribute-level mappings covering transformations, data types, nullability, key behavior, historization, DQ rules, and PII classification.

Key Design

Define surrogate keys, alternate keys, source-system crosswalks, and unresolved foreign-key handling.

Historization

Recommend appropriate patterns, including SCD Type 1, selective SCD Type 2, lifecycle episodes, and append-only events.

Canonical Modeling

Design reusable canonical models capable of integrating multiple source systems without major redesign.

Standards & Governance

Define and enforce standards for naming, reference data, lineage, audit, retention, deletion, and data quality.

Implementation Review

Review implementation SQL and pipelines to ensure alignment with approved models.

Model Management

Maintain models, definitions, relationships, and documentation in the enterprise modeling tool.

Gold Layer Support

Support downstream dimensional models and KPI reporting without embedding report-specific logic in Silver.

Cross-Functional Collaboration

Partner with data architects, data engineers, business analysts, governance teams, and source-system SMEs.