Data Modeler

Senior Data Modeler / Associate Data Architect

You will collaborate with cross-functional business and engineering teams to define robust data architecture, build optimized data processing layers, and guide teams through implementation best practices across OLTP, OLAP, and modern cloud environments.

Key Responsibilities

Data Architecture & Modelling

• Design, develop, and maintain

  conceptual, logical, and physical data models

  for OLTP, OLAP, data warehouses, and cloud platforms.
• Apply

  Medallion architecture

  , ER modeling, dimensional modeling (Star/Snowflake), Data Vault, and advanced data modeling techniques.
• Build reusable intermediary data layers and physical consumable views for data marts.
• Ensure alignment of data models with enterprise architecture and business requirements.

Requirement Gathering & Documentation

• Partner with business/product teams to understand processes, gather requirements, and translate them into high-level specifications.
• Develop

  data mapping

  , source-to-target documents, metadata documentation, and lineage diagrams.

Data Governance & Quality

• Implement and oversee

  data governance frameworks

  , data retention policies, and data quality rules.
• Use data observability tools and automated anomaly detection mechanisms.
• Maintain business glossaries, reference data, and data dictionaries.

Cloud Platforms & Engineering Collaboration

• Work extensively on cloud platforms such as

  Snowflake, BigQuery, and GCP

  ; contribute to cloud solution architecture.
• Guide engineers in ETL/ELT design, Snowflake implementation, and performance optimization.
• Support DevOps, DataOps, and CI/CD data pipelines.

Stakeholder Management & Leadership

• Act as the principal reviewer for all data models and architecture artifacts across projects.
• Mentor and coach junior modelers, analysts, and engineers.
• Communicate insights and recommendations to senior stakeholders.

Migration & Modernization Projects

• Lead data migration initiatives across BFSI, healthcare, or enterprise domains.
• Conduct profiling, lineage analysis, performance tuning, and schema optimization.
• Review stored procedures, database objects, triggers, and business logic.

Required Skills & Expertise

Core Competencies

• Enterprise Data Architecture, Medallion Architecture
• Data Modelling (Conceptual, Logical, Physical)
• OLTP, OLAP, Dimensional Modelling (Star/Snowflake)
• Data Governance, Metadata Management, Master Data
• ETL/ELT & Data Warehousing
• Agile, Scrum, Waterfall SDLC

Technical Skills

• Cloud:

  GCP (BigQuery), Snowflake

• Databases:

  Oracle, SQL Server, NoSQL

• Modeling Tools:

  ER/Studio

• ETL Tools:

  Ab Initio

• Visualization:

  Power BI, Tableau
• Strong SQL expertise—analytical functions, indexing, optimization, partitioning, query tuning
• Knowledge of Snowflake features: Snowpipes, Streams, Tasks, zero-copy cloning

Preferred Qualifications

• Bachelor’s degree in Computer Applications or related field
• Experience in BFSI, healthcare, insurance, or enterprise-scale systems
• Certifications (preferred):
• Cisco Data Analytics Essentials
• Certified Data Management Professional (CDMP)