Data ModelerAscendion • Pune (division)

Data Modeler

Ascendion • Pune (division)

14 days 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 • Pune (division)

Related jobs

Data Science & AI / ML Lead

ACL Digital • Pune (division)

Need a lead level resource in GenAI team.Operating Systems - MS Windows, Linux Languages - Python, SQL Deep Learning - TensorFlow, Keras Machine Learning - Pandas, NumPy, Scikit Learn DL Models - L...Show more

Last updated: 13 days ago • Promoted

Azure Data Engineer / Data Visualization Lead (Tableau)

PROADSW3 Relations pvt. ltd. • Pune (division)

Azure Data Engineer / Data Visualization Lead (Tableau) – AM / DM | 5–8 Years | Budget : 1.Mandate : Databricks Experience. We are seeking a highly skilled Azure Data Engineer – Data Visualization Lead ...Show more

Last updated: 1 day ago • Promoted

Lead Data Engineer

Persistent Systems • Pune (division)

We’re looking for a Lead Technical Engineer who can bridge data engineering depth with FinOps insight.You’ll design and implement scalable data solutions across Databricks and Snowflake, drive perf...Show more

Last updated: 9 days ago • Promoted

Data Engineer

Persistent Systems • Pune (division)

We are looking for a Data Engineer with Python AWS experience.Job Type : Full Time Employment.Understand the domain for which the entities are being created. Understand the entity creation process fr...Show more

Last updated: 29 days ago • Promoted

Lead Data Engineer

Searce Inc • Pune (division)

Searce means ‘a fine sieve’ & indicates ‘to refine, to analyze, to improve’.It signifies our way of working : To improve to the finest degree of excellence, ‘solving for better’ every time.Searcians...Show more

Last updated: 7 days ago • Promoted

AI and Databricks

Quantum Integrators • Pune (division)

Role : AI and Databricks Engineer.Strong experience developing industry grade LLM and Gen-AI applications using OpenAI, Anthropic (Claude), or other major providers. Spark, Delta Lake, MLflow, Databr...Show more

Last updated: 7 days ago • Promoted

Bim Modeler - MEP

ALEMCO • Pune (division)

Are you a hands-on professional with a passion for precision and performance? Join us in delivering high-quality MEP systems for landmark projects in the UAE. This role is based on-site in the UAE a...Show more

Last updated: 6 days ago • Promoted

Data Engineer-SAC

Orbia Pune • Pune (division)

If you have strong background in.Note : This is a full time role, 5 Days on-site role based at Orbia Global Capability Center in Pune. A minimum of 6 years' experience in data warehousing, data model...Show more

Last updated: 6 days ago • Promoted

Data Reporting Engineer (PowerBI)

AkzoNobel • Pune (division)

AkzoNobel has a passion for paint.We're experts in the proud craft of making paints and coatings, setting the standard in color and protection since 1792. Our world class portfolio of brands - inclu...Show more

Last updated: 14 days ago • Promoted

Data Architect

Accenture • Pune (division)

Accenture is a global professional services company with leading capabilities in digital, cloud and security.Combining unmatched experience and specialized skills across more than 40 industries, we...Show more

Last updated: 7 days ago • Promoted

Data Science

Persistent Systems • Pune (division)

We are seeking a Data Science to design and build intelligent systems using state-of-the-art generative models.You will work on developing applications powered by large language models (LLMs), diff...Show more

Last updated: 14 days ago • Promoted

Data Engineer

Synechron • Pune (division)

We have immediate opportunity for.Notice Period : Immediate to 30 Days.At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines cre...Show more

Last updated: 20 days ago • Promoted

Data Architect

Persistent Systems • Pune (division)

As an Architect Product Owner we need combination of deep technical expertise with strong product management skills.You will own the vision, strategy, and roadmap for the Data Fabric platform, ensu...Show more

Last updated: 20 days ago • Promoted

PowerBi Developer (SQL)

Aptino, Inc. • Pune (division)

Pune or Gurgaon (complete onsite).Power BI Developer with strong SQL skills.The ideal candidate will have experience in developing business intelligence (BI) solutions, creating data models, and bu...Show more

Last updated: 1 day ago • Promoted

Big Data Developer

airtel • Pune (division)

Big Data Developer (Senior Manager).We are seeking a highly skilled.The ideal candidate will have extensive experience in building and leading end-to-end big data pipelines, with deep expertise in ...Show more

Last updated: 20 days ago • Promoted

6221 Azure Data Engineer

EXL • Pune (division)

Key Role and Responsibilities : .Design and develop ETL / ELT pipelines using Azure Data Factory, Snowflake, and DBT.Build and maintain data integration workflows from various data sources to Snowflake...Show more

Last updated: 6 days ago • Promoted

5676 - Data Engineer

EXL • Pune (division)

Location - Pune, Bangalore, Noida, Gurgaon, Hyderabad.The ideal candidate will have strong expertise in Snowflake, Hadoop ecosystem, PySpark, and SQL, and will play a key role in enabling data-driv...Show more

Last updated: 20 days ago • Promoted

Data Architect

ACL Digital • Pune (division)

Technical skills and core competencies.Strong understanding of Data Architecture and models and leading data driven projects. Solid expertise and strong opinions on Data Modelling paradigms such as ...Show more

Last updated: 17 days ago • Promoted