🔔 FCM Loaded

Senior Data Modeler

Brace Infotech Private Ltd

5 - 10 years

Chennai

Posted: 28/02/2026

Getting a referral is 5x more effective than applying directly

Job Description

Senior Data Modeler (Hands-on)

Enterprise Data Modeling | ODS | Data Warehouse | Financial Systems

1015+ years of hands-on data modeling experience.

10+ years experience using Erwin (conceptual/logical/physical modeling).


Role Overview

We are seeking a Senior Data Modeler with deep expertise in conceptual, logical, and physical data modeling for enterprise financial systems. This role focuses heavily on ER modeling, ODS/DW design, performance optimization, and source-to-target mappings.

This position is more execution-focused and hands-on in detailed modeling work.

Key Responsibilities

Data Modeling & Design

  • Create conceptual, logical, and physical data models.
  • Develop dimensional models (star/snowflake schemas).
  • Design highly performant Operational Data Stores (ODS).
  • Develop near real-time Data Warehouse models.
  • Conduct reverse and forward engineering.
  • Create source-to-target mappings and lineage documentation.

Modeling Methodologies

  • Apply Kimball, Inmon, Data Vault principles.
  • Develop reusable canonical models.
  • Maintain modeling standards and documentation.

Database & SQL Expertise

  • Build optimized physical data structures.
  • Write advanced SQL queries and stored procedures.
  • Perform indexing, partitioning, and performance tuning.

ETL / ELT Collaboration

  • Work with Matillion, DBT, SnapLogic, Informatica teams.
  • Support ingestion, transformation, and curation layers.
  • Optimize high-volume pipelines.

Analytics & Data Preparation

  • Prepare curated datasets for Risk, Fraud, and Analytics teams.
  • Support ML-ready datasets (Python knowledge preferred).

Required Experience

  • 1015+ years of hands-on data modeling experience.
  • 10+ years experience using Erwin (conceptual/logical/physical modeling).
  • Strong ODS & Data Warehouse modeling experience.
  • Expert SQL skills (Oracle, Snowflake).
  • Experience in Financial Services (Banking / Cards / Payments).
  • Experience with metadata, lineage, and data quality.

Services you might be interested in

Improve Your Resume Today

Boost your chances with professional resume services!

Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.