Data Modeler

Data Modeler

Snowflake,Dremio, and Databricks

Responsibilities:

• Develop conceptual, logical, and physical data models aligned with enterprise architecture standards.
• Engage with Business Stakeholders:Collaborate with business teams,businessanalystsandSMEsto understand business processes, data lifecycles, and key metrics that drive value and outcomes.
• Value Chain Understanding:Analyzeend-to-end customer and product value chains toidentifycritical data entities, relationships, and dependencies that should be represented in the data model.
• Conceptual and LogicalModeling:Translate business concepts and data requirements into conceptual and logical data models that capture enterprise semantics and support analytical and operational needs.
• Physical DataModeling:Design and implementphysical data modelsoptimizedfor performanceandscalability
• Semantic Layer Design:Create semantic models that enable business access to data via BI tools and data discovery platforms.
• Data Standards and Governance:Ensure modelscomply withenterprise data standards, naming conventions, lineage tracking, and governance practices.
• Implement naming conventions, data standards, and metadata definitions across all models.
• Collaboration with Data Engineering:Work closely with data engineers to align data pipelines with the logical and physical models, ensuring consistency and accuracy from ingestion to consumption.
• Manage version control, lineage tracking, and change documentation for models.
• Participate in

  data quality and governance

  initiatives to ensure trusted and consistent data definitions across domains.
• Create andmaintaina

  business glossary

  in collaboration with the governance team.

Requirements:

• Bachelor's orMaster's in Computer Science, Information Systems, or related field.

• 8+ years

  in datamodelingor enterprise data architecture.
• Strong experience withmodelingtools such as

  Erwin, ER/Studio,PowerDesigner, or SQLDBM

  .
• Deep understanding of

  dimensionalmodeling(Kimball/Inmon)

  , normalization, and schema design for modern warehouses.
• Experience designing models for

  Snowflake,Dremio, Redshift, or Databricks

  environments.
• Strong SQL and schema design skills, with ability tovalidatemodel implementations.
• Familiarity with

  data governance, metadata management, and business glossary tools

  (e.g., Collibra, Alation, Purview).
• Excellent communication skills able to work with both technical and non-technical stakeholders.

Preferred:

• Experience in high-tech or manufacturing data domains (Customer, Product, Supply Chain).
• Familiarity with

  Medallion or Data Vault architectures

  and how they translate into dimensional models.
• Exposure to data integration pipelines and ETL frameworks (Informatica, DBT, Airflow).
• Understanding of master data and reference data management principles.