Senior Data Modeler

Job Summary

We are seeking an experienced Senior Data Modeler with 10+ years of experience in Data Modeling, Databricks, Erwin, Data Warehousing, and AI/BI Data Architecture. The ideal candidate will design scalable logical and physical data models, optimize schemas for analytics and AI workloads, and establish enterprise data standards.

Required Skills

  • Data Modeling
  • Data Architecture
  • Erwin Data Modeler
  • Databricks
  • SQL
  • Data Warehousing
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Metadata Management
  • Data Governance
  • OLAP
  • AI Data Pipelines
  • Data Validation
  • Schema Design
  • Performance Optimization

Responsibilities

  • Design logical and physical data models for enterprise applications.
  • Define entities, relationships, primary/foreign keys, and table grain.
  • Create dimension and fact tables for analytics and reporting.
  • Standardize naming conventions, data types, and metadata.
  • Implement data validation, referential integrity, and quality checks.
  • Optimize models for AI, BI, and OLAP workloads.
  • Manage schema versioning and downstream dependencies.
  • Collaborate with engineering and business teams on data architecture.

 

To apply for this job email your details to bala@realtekconsulting.net