No longer accepting applications

Data Modeler

Ascendiondombivli, maharashtra, in

11 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 • dombivli, maharashtra, in

Related jobs

Promoted

Data Modeler

Tata Consultancy Servicesmumbai, maharashtra, in

Job Title : Senior Data Modeler.Required skill : Kimball, Inmon, Data Vault and Dimensional Modelling.Proficient in designing conceptual, logical and physical data models. Skilled in methodologies suc...Show moreLast updated: 30+ days ago

Promoted

BIM Modeler

Anlage Infotech (India) P LtdMumbai, Maharashtra, India

About the Company : Leading Data Center Company.The BIM Modeler – AI Data Center will be responsible for developing, managing, and coordinating Building Information Models (BIM) across Mechanical, E...Show moreLast updated: 4 days ago

Promoted

Data Modeler- Associate

ConfidentialMumbai, India

You are a strategic thinker passionate about driving solutions in Data Modelling.As a Data Modeler within our team, you will be responsible for designing, developing, and optimizing data models to ...Show moreLast updated: 10 days ago

Promoted

Python Developer

LTIMindtreenavi mumbai, maharashtra, 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: 4 days ago

Promoted

GCP Data Architect

Tata Consultancy Servicesnavi mumbai, maharashtra, 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: 28 days ago

Promoted

AI / ML & Data Engineer

Mindfire SolutionsThane, IN

We are looking for an experienced AI / ML & Data Engineer to design, develop, and deploy scalable machine learning models and data infrastructure on AWS. You will work closely with cross-functional te...Show moreLast updated: 19 days ago

Promoted

ML Ops

EXLmumbai city, maharashtra, 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

Promoted

AIML Engineer

Tata Consultancy Servicesdombivli, maharashtra, in

Competencies (Technical / Behavioral Competency).AI / ML, Azure ML Studio, AI / ML On Databricks, Python & CICD Devops.Supervised and unsupervised ML and Predictive Analytics using Python • Feature gener...Show moreLast updated: 6 days ago

Promoted

Collection Analytics and Modeling

KisshtMumbai, Maharashtra, India

The role involves developing and optimizing scorecards, early warning models, and segmentation frameworks to improve recovery rates and reduce delinquencies. You will collaborate with risk, operatio...Show moreLast updated: 16 days ago

Promoted

AI / ML Developer

Viionn Labsthane, maharashtra, in

Derive and design use cases from structured and unstructured data.Provide LLM expertise to solve AI problems using state-of-the-art language models and off-the-shelf LLM services such as OpenAI mod...Show moreLast updated: 6 days ago

Promoted

Data Integration Developer (Level 2)

Bluticdombivli, maharashtra, in

Data Integration Developer (Level 2).ETL processes, reports, and database solutions using.This role requires solid technical skills to implement solutions, optimize code, and collaborate effectivel...Show moreLast updated: 6 days ago

Data Modeler

Saaki Argus & Averil ConsultingMumbai, Maharashtra, India

Quick Apply

Chennai, Bangalore, Mumbai, Pune, Noida.Conduct data analysis and capture data requirements.Perform data mapping based on data source schemas and reverse engineering of existing transformations fro...Show moreLast updated: 30+ days ago

Promoted

AI / ML Engineer

Chargebeenavi mumbai, maharashtra, in

Chargebee’s GBT AI team builds internal AI agents and workflows that power smarter, faster operations across Finance, HR, Legal , Marketing, RevOps and GTM. We’re looking for an AI Engineer who can ...Show moreLast updated: 27 days ago

Promoted

Data Modeler - Planning

ConfidentialMumbai

Work in close partnership with the business leadership team to execute the analytics agenda.Identify and incubate best-in-class external partners to drive delivery on strategic projects.Develop cus...Show moreLast updated: 30+ days ago

Promoted

Coastal Modeler | ISIR.AI

ISIR AIThane, 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

Lead Data Modeler

SystechcorpMumbai

Role : Lead Data Modeler.Notice period : Only 15-30days.Location : Mumbai / Pune Youll Do : - Develop conce...Show moreLast updated: 30+ days ago

Promoted

Data Modeler

RecroThane, 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: 28 days ago

Promoted

Senior Data Modeler

Neutrino Advisory, an Inc 5000 CompanyKalyan-Dombivli, 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