Key
Responsibilities

Data
Modeling & Design

• Design,
build, and maintain conceptual, logical, and physical data models for data
warehouses, data lakes, and operational data stores.

• Apply
dimensional modeling techniques (Kimball star/snowflake schemas, slowly
changing dimensions, conformed dimensions) and Inmon -style normalized
enterprise models as appropriate.

• Define
naming conventions, modeling standards, and reusable design patterns; review
peers’ models and provide constructive feedback.

• Partner
with data engineers to translate models into performant physical
implementations and ELT/ETL pipelines.

Requirements
Gathering & Stakeholder Engagement

• Lead
workshops with business stakeholders, product owners, and SMEs to elicit data
requirements and translate them into clear modeling artifacts.

• Document
business definitions, source -to -target mappings, lineage, and data quality
rules.

• Act
as a trusted advisor to analytics and engineering teams on the right modeling
approach for a given use case.

Data
Governance & Metadata

• Curate
and maintain metadata, business glossary terms, and data classifications in the
enterprise governance platform (e.g., Collibra).

• Support




regulatory and compliance initiatives by ensuring sensitive data is properly
classified, documented, and modeled.

Required
Qualifications

• 6–10
years of professional experience in data modelling or a closely related data
discipline.

• Proficiency
with at least one industry -standard data modeling tool (e.g., erwin Data
Modeler, ER/Studio, SAP PowerDesigner, SqlDBM).

• Excellent
communication skills with the ability to explain complex data concepts to both
technical and non -technical audiences.

Preferred
Qualifications

• CDVP2
(Certified Data Vault 2.0 Practitioner) or equivalent Data Vault certification.

• CDMP
(Certified Data Management Qualified) or DAMA -DMBOK familiarity.

• Experience
modeling for cloud data platforms (Snowflake, Databricks, BigQuery) and
lakehouse architectures.

• Experience
with dbt, Airflow, or similar transformation/orchestration tooling.

• Exposure
to industry data models (e.g., FSLDM) relevant to the organization’s domain.

• Familiarity
with master data management (MDM), reference data, and data product / data mesh
concepts.

• Experience
supporting regulatory frameworks such as CCPA, HIPAA, or SOX.