Data Modeler

Versant Media
New York, United States
1 day ago
Apply on startup.jobs
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Data Analysis Business Intelligence Development Data Architecture Information Engineering Data Governance Data Sharing Data Vault Modeling Dimensional Modeling Interoperability Metadata Reference Data
+7 more
Cloud Services Snowflake Data Layers Data Management Physical Data Models Domain Model Databricks

Job description

The Senior Data Modeler will work with Product, domain experts, Data Engineering, Analytics, Architecture, Governance, and Security to translate business concepts into a shared enterprise data language and practical models that teams can implement across the Bronze, Silver, and Gold layers of our data platform.

This is not a role focused only on designing tables for individual projects. It owns the connective tissue between domain models: the common entities, identifiers, relationships, definitions, metadata, and standards that allow trusted data products to work together across the enterprise.

What you will do

  • Establish the enterprise North Star Data Model
  • Define and maintain enterprise conceptual, logical, and physical data models across core business domains.
  • Establish canonical business entities, shared dimensions, reference data, identifiers, relationships, and lifecycle states.
  • Create a pragmatic model that supports domain autonomy while enabling cross-domain analysis and data sharing.
  • Maintain an enterprise ontology, business glossary, and semantic definitions so that important terms and metrics mean the same thing across products and teams.
  • Design for reuse, extensibility, regional variation, and future use cases while avoiding unnecessary centralization.
  • Model the Bronze, Silver, and Gold data layers
  • Define modeling principles and required artifacts for each layer:
  • Bronze: Preserve source fidelity, source lineage, ingestion metadata, auditability, and raw-data contracts.
  • Silver: Standardize and validate data; apply common identifiers, canonical entities, conformed dimensions, data-quality rules, and cross-domain integration patterns.
  • Gold: Deliver governed, business-ready data products, semantic models, certified metrics, and analytics-ready structures for dashboards, self-service analysis, and AI.
  • Ensure traceability from Gold metrics and business concepts back through Silver transformations to authoritative Bronze sources.
  • Define clear rules for when a concept belongs in a domain model, the shared enterprise model, a semantic layer, or a product-specific analytical model.
  • Review and guide physical implementations for performance, maintainability, cost, privacy, and scale.

Enable data products and delivery teams

  • Partner with Product Managers and domain leaders to turn business outcomes and use cases into clear data-modeling requirements.
  • Partner with Data Engineers to define schemas, transformations, mappings, data contracts, and implementation patterns.
  • Partner with BI developers to create governed semantic models, reusable measures, and self-service-ready datasets.
  • Facilitate architecture and design reviews; identify duplication, inconsistent definitions, broken lineage, and integration risk early.
  • Provide model patterns, templates, and coaching that enable teams to deliver independently while following enterprise standards.
  • Govern for trust, security, and global scale
  • Embed data quality, lineage, ownership, retention, security classification, privacy-by-design, and access-control requirements into data-model designs.
  • Model regional, regulatory, language, currency, and local-business variations without fragmenting global reporting or shared concepts.
  • Define stewardship and decision rights for enterprise entities, metrics, and reference data.
  • Maintain model documentation and metadata in the organization’s data catalog and modeling tools.
  • Measure adoption, reuse, quality, coverage, and exceptions to drive continual improvement of the North Star model.

What success looks like

  • Teams use the same definitions for shared business concepts and key metrics.
  • New data products can be delivered faster because common models, dimensions, identifiers, and patterns are reusable.
  • Cross-domain reporting is reliable, explainable, and traceable to authoritative sources.
  • Data consumers can discover what data exists, what it means, who owns it, and whether it is fit for use.
  • Regional expansion is supported through intentional extensions rather than isolated local models.
  • Gold-layer analytics and AI experiences use certified semantic definitions rather than reconstructing logic independently.

Requirements

  • 7+ years of experience in data modeling, data architecture, data engineering, analytics engineering, or related disciplines.
  • Demonstrated experience designing conceptual, logical, and physical models for complex, multi-domain data platforms.
  • Experience defining or evolving an enterprise data model, canonical model, semantic layer, ontology, or common data model.
  • Strong understanding of dimensional modeling, normalized modeling, data vault or equivalent integration patterns, and lakehouse/warehouse design.
  • Experience designing models for raw, standardized, and consumption-ready data layers in a modern cloud data platform.
  • Proven ability to translate business concepts into unambiguous data definitions, models, mappings, and implementation guidance.
  • Practical expertise in metadata, lineage, data quality, data governance, master/reference data, and data privacy.
  • Strong facilitation and communication skills; able to influence senior stakeholders and delivery teams without relying on direct authority., * Experience with Databricks, Delta Lake, Unity Catalog, Snowflake, or comparable cloud data platforms.
  • Experience with a data catalog, modeling tool, and metadata-management platform.
  • Experience supporting global products and multi-region data, regulatory, or data-residency requirements.
  • Experience designing semantic models and governed metrics for BI, natural-language data experiences, or AI applications.
  • Experience in a regulated, high-scale, or operationally sensitive environment., VERSANT Media is not accepting unsolicited assistance from search firms for this employment opportunity. All resumes submitted by search firms to any employee at VERSANT via-email, the Internet, or in any form and/or method without a valid written Statement of Work in place for this position from VERSANT’s Talent Acquisition team will be deemed the sole property of VERSANT. No fee will be paid in the event the candidate is hired by VERSANT as a result of the referral or through other means.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on startup.jobs
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

1:47 min

Comparing Egeria to alternative open metadata solutions

Ferd Scheepers · World Congress 2022

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · World Congress 2026 Europe

2:27 min

Managing traffic and tracking costs with Databricks Unity Catalog

Viktoria Semaan Viktoria Semaan · World Congress 2026 Europe

2:50 min

Executing LoRA fine-tuning using serverless Databricks AI runtimes

Viktoria Semaan Viktoria Semaan · World Congress 2026 Europe

2:08 min

Creating standard APIs via the Egeria open metadata project

Ferd Scheepers · World Congress 2022

Videos

See all

Related articles

See all