Data Modeler

AscendionKolkata, IN

2 hours ago

Job description

The Principal Data Modeler / Architect will lead a critical database modernization initiative to reverse engineer, redesign, and normalize our existing OLTP data architecture. This role requires a seasoned data professional who can analyze complex legacy systems, identify architectural debt, and execute a comprehensive schema refactoring strategy while ensuring zero business disruption. The ideal candidate combines deep expertise in data modeling, normalization principles, and large-scale database migration with strong collaboration skills to coordinate cross-functional teams through this transformation.

Experience in the EdTech domain is a plus.

Primary Objective

Reverse engineer our existing large-scale OLTP database, analyze current denormalized structures, and redesign the data model following normalization best practices while optimizing for performance, maintainability, and scalability in a modern SaaS environment.

Key Responsibilities

Database Analysis & Reverse Engineering

Reverse engineer existing OLTP databases to create comprehensive conceptual, logical, and physical data models
Analyze current schema design to identify denormalization patterns, data redundancies, integrity issues, and architectural debt
Profile existing data quality, identify anomalies, inconsistencies, and constraint violations
Document current state architecture, data flows, and integration points

Schema Redesign & Normalization

Redesign database schema by applying normalization principles (1NF through BCNF) to eliminate redundancy and improve data integrity

Create optimized conceptual, logical, and physical data models for the target state architecture

Design migration paths that maintain referential integrity and business rule enforcement

Identify opportunities for strategic denormalization where justified by performance requirements

Migration Strategy & Execution

Develop comprehensive migration strategies with minimal or zero downtime requirements

Design data transformation logic to migrate from denormalized to normalized structures

Create phased migration approaches using patterns such as strangler fig, dual-write, or shadow databases

Implement data validation and reconciliation frameworks to ensure migration accuracy

Develop rollback strategies and contingency plans for migration phases

Coordinate database deployment using CI / CD pipelines and migration tools

Performance Optimization & Tuning

Benchmark existing system performance to establish baselines

Optimize new schema design through indexing strategies, partitioning, and query optimization

Conduct load testing and performance validation pre and post-migration

Fine-tune database configuration, connection pooling, and caching strategies for AWS Aurora PostgreSQL

Ensure normalized design meets or exceeds current performance benchmarks

Data Governance, Security & Compliance

Ensure redesigned data model maintains compliance with relevant standards (GDPR, HIPAA, FERPA for EdTech)

Implement data governance policies, access controls, and security measures in new architecture

Define and enforce data quality standards throughout migration process

Establish data lineage and metadata management for new structures

Documentation & Knowledge Transfer

Create comprehensive documentation including data models, schema specifications, migration procedures, and data dictionaries

Develop data flow diagrams, entity-relationship diagrams, and architecture decision records

Document rationale for normalization decisions and any strategic denormalization

Create runbooks for migration execution and rollback procedures

Provide knowledge transfer sessions to technical teams

Required Skills & Qualifications

Data Modeling & Database Expertise

10+ years of hands-on experience in data modeling and database design

5+ years of experience reverse engineering and refactoring large-scale OLTP databases

Expert-level understanding of database normalization theory and practical application (1NF through 5NF, BCNF)

Deep expertise in both forward and reverse engineering of data models

Proven track record of successful database modernization and schema refactoring projects

In-depth knowledge of relational database design principles, patterns, and anti-patterns

Technical Proficiency

Expert-level SQL skills and extensive experience with PostgreSQL (required)

Proficiency with additional RDBMS platforms (SQL Server, Oracle, MySQL)

Hands-on experience with AWS Aurora PostgreSQL or similar cloud-based database platforms

Strong expertise in data modeling tools ( erwin, SqlDBM, ER / Studio, or similar )

Experience with database migration and version control tools

Familiarity with database comparison and schema diff tools

Knowledge of database DevOps practices and CI / CD pipeline integration

Experience with cloud platforms (AWS, Azure, GCP) and cloud-native database services

Relevant certifications (AWS Certified Database Specialty, PostgreSQL certifications) are advantageous

Create a job alert for this search

Data Modeler • Kolkata, IN

Related jobs

Promoted
New!

Data Modeler

People Prime WorldwideKolkata, IN

Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris, France. Founded in 1967, It has been a leader in business transformation for...Show moreLast updated: 2 hours ago

Promoted

Coastal Modeler | ISIR.AI

ISIR AIKolkata, IN

Turn Simulations into Impact — Join ISIR.AI is advancing coastal and marine analytics across Asia, and we’re looking for a driven Coastal Modeler. This is not a routine modeling job — it’s an opport...Show moreLast updated: 19 days ago

Promoted

BIM Modeler

PLAN SWIFT ARCHITECTUREKolkata, West Bengal, India

Company Description Plan Swift Architecture is a Kolkata-based civil engineering consultancy with proven experience across residential, commercial and institutional building projects.We combine pr...Show moreLast updated: 6 days ago

Promoted

Senior Data Modeler

Neutrino Advisory, an Inc 5000 CompanyKolkata, IN

The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse.The ideal ca...Show moreLast updated: 27 days ago

Promoted

Data Modeler

Tata Consultancy ServicesKolkata, IN

TCS has been a great pioneer in feeding the fire of Young techies like you.We are global leaders in the technology arena and there's nothing that can stop us from growing together.Dimensional Data ...Show moreLast updated: 5 days ago

Promoted

Data Modeler

ConfidentialKolkata, Mumbai

Understand and work with conceptual, logical, and physical data models to support enterprise data architecture.Leverage the inventory of data sources and ensure accurate alignment with the overall ...Show moreLast updated: 10 days ago

Promoted
New!

[11 / 11 / 2025] Data Modeler

Tata Consultancy ServicesKolkata, West Bengal, India

We are hiring for Senior Data Modeler.Role : Senior Data Modeler Experience : 8 years to 14 years Location : Kolkata Technical skill- Kimball, Inmon, Data Vault and Dimensional Modelling Intereste...Show moreLast updated: 11 hours ago

Promoted

DS with Python : LLM Model training

DeepLLMDatakolkata, west bengal, in

DeepLLMData focuses on coding SFT, RLHF, STEM, PhD, Maths, Image and Video data annotators and provisioning.This is a Part-time remote role for LLM Model training. The task needs LLM Trainers to cre...Show moreLast updated: 3 days ago

Promoted

Python Developer

LTIMindtreekolkata, west bengal, in

Experience : 5 years to 12 years.Notice : Immediate to 30 Days only.Mandatory skills : Python Data Engineer, AWS and services. Strong programming skills in Python, including libraries like Pandas, NumP...Show moreLast updated: 3 days ago

Promoted

Senior Data Modeler

Tata Consultancy Serviceswest bengal, west bengal, in

Required Technical Skill Set • •Kimball, Inmon, Data Vault and Dimensional Modelling.Desired Competencies (Technical / Behavioral Competency). Proficient in designing conceptual, logical and physical da...Show moreLast updated: 23 days ago

Promoted
New!

Data Architect

Iris Software Inc.Kolkata, IN

You will lead data architecture, engineering, and analytics initiatives, ensuring data quality, governance, and accessibility across the organization. Design and maintain cloud-based data architectu...Show moreLast updated: 2 hours ago

Promoted

Data Architect

Tata Consultancy Serviceswest bengal, west bengal, in

Required Technical Skill Set • •Databricks, AWS ,RedshiftEDW DB to Databricks Lakehouse Platform on AWS.Desired Experience Range • •12+ years with 4-5+ years in Cloud Data Architecture, Databricks and ...Show moreLast updated: 23 days ago

Promoted

GCP Data Architect

Tata Consultancy Serviceskolkata, west bengal, in

Design and Implement Data Architectures : Architect and build scalable, end-to-end data solutions on GCP, encompassing data ingestion, transformation, storage, and consumption.Develop Data Pipelines...Show moreLast updated: 27 days ago

Promoted
New!

EY - GDS Consulting - AI And DATA -Data Modeller - Senior

ConfidentialKolkata, India

At EY, we're all in to shape your future with confidence.We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help ...Show moreLast updated: 1 hour ago

Promoted

Senior Tableau Developer (with Strong Power BI Experience)

Dataplatr Inc.kolkata, India

Job Title : Senior Tableau Developer (with Strong Power BI Experience).Immediate joiners or candidates with a notice period of one week or less only may apply • • •. The ideal candidate will have hands-...Show moreLast updated: 3 days ago

Promoted

Data Modeler

RecroKolkata, IN

NoSQL) to support enterprise information management, BI, analytics, machine learning, and other business use cases.They drive data strategies, build models (conceptual, logical, physical), ensure p...Show moreLast updated: 27 days ago

Promoted

Senior Principal Consultant - Data Modeller

ConfidentialKolkata

Inviting applications for the role of Senior Principal Consultant-.The ideal candidate will have extensive experience in designing. Develop conceptual, logical, and physical data models to support c...Show moreLast updated: 10 days ago

Promoted

ML Ops

EXLkolkata, west bengal, in

Deploy, monitor, and scale ML models on.GCP (Vertex AI, GKE, Cloud Functions).GitHub Actions / Jenkins / cloud-native tools. Containerize and orchestrate workloads with.MLflow, Feast, Prometheus / Gra...Show moreLast updated: 30+ days ago