No longer accepting applications
Data Modeler
AscendionNagpur, IN7 hours ago
Job descriptionRedesign 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 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 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 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 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 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 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
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
Migration Strategy & Execution
Performance Optimization & Tuning
Data Governance, Security & Compliance
Documentation & Knowledge Transfer
Required Skills & Qualifications
Data Modeling & Database Expertise
Technical Proficiency
Create a job alert for this search
Data Modeler • Nagpur, IN
Related jobs
)
- Promoted
- New!
Data Modeler
Ascendionnagpur, maharashtra, in 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 sea...Show moreLast updated: 3 hours ago
- Promoted
Data Modeler
RecroNagpur, 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
Data Modeling Architect
Persistent SystemsPune, Republic Of India, IN We are looking for an experienced Data Modeller to join our growing team.The ideal candidate will have a strong background in working with Data Modeller (Power BI, Tabular Models, old MDX backgroun...Show moreLast updated: 25 days ago
- Promoted
Looker Developer
RiDiK (a Subsidiary of CLPS. Nasdaq : CLPS)Nagpur, IN We are looking for a skilled BI Developer to support a large client in the Healthcare domain.The role will involve enhancing and maintaining reports using Looker / LookML, developing dimensional data...Show moreLast updated: 6 days ago
- Promoted
Dimensional Data Modeler
Tata Consultancy ServicesRepublic Of India, IN Greetings from Tata Consultancy Services!!.We are hiring for Data Modeler.Required Skillset : Dimensional Modeling.Dimensional Data Modeling experience.
Strong analytical skills with the ability to c...Show moreLast updated: 19 days ago
- Promoted
Data Modeller
Persistent SystemsPune, Republic Of India, IN We are looking for an experienced Data Modeller to join our growing team.The ideal candidate will have a strong background in working with Data Modeller (Power BI, Tabular Models, old MDX backgroun...Show moreLast updated: 30+ days ago
- Promoted
Data Modeler
Tata Consultancy Servicesnagpur, maharashtra, 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: 6 days ago
- Promoted
Coastal Modeler | ISIR.AI
ISIR AInagpur, maharashtra, 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
Data Modeler
VOISPune, Republic Of India, IN VOIS (Vodafone Intelligent Solutions) is a strategic arm of Vodafone Group Plc, creating value for customers by delivering intelligent solutions through Talent, Technology & Transformation.As the l...Show moreLast updated: 30+ days ago
- Promoted
- New!
Data Modeler
People Prime Worldwidenagpur, maharashtra, 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: 3 hours ago
- Promoted
Senior Data Modeler
Neutrino Advisory, an Inc 5000 CompanyNagpur, 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
Lead Data Modeler
Optimum Solutions Pte LtdPune, Republic Of India, IN We are looking for an experienced.The ideal candidate will have hands-on experience in.Medallion architecture (Bronze, Silver, Gold layers).
Work closely with stakeholders to understand business req...Show moreLast updated: 27 days ago
- Promoted
Data Modeller
Art Technology and SoftwareCochin, Republic Of India, IN We are looking for an experienced Data Modeller specialising in the payments space for issuer processors.In this critical role, you will design and implement data models to support the processing o...Show moreLast updated: 2 days ago
- Promoted
Data Architect & Modeler
Best Infosystems Ltd.Pune, Republic Of India, IN Data Modeler_Full-Time_Pune / Bangalore (Hybrid, 3 Days WFO).Pune / Bangalore (Hybrid, 3 Days WFO).Creation and management of business data models in all their forms, including conceptual models, log...Show moreLast updated: 30+ days ago
- Promoted
Lead Data Modeler
InfoCeptsPune, Republic Of India, IN Key Result Areas and Activities : .Develop machine learning models for classification, regression, and forecasting tasks using Python and relevant libraries.
Data Preparation & Feature Engineering : .Cl...Show moreLast updated: 1 day ago
- Promoted
Data Modeler
Optimum Solutions Pte LtdPune, Republic Of India, IN We are looking for an experienced.The ideal candidate will have hands-on experience in.Medallion architecture (Bronze, Silver, Gold layers).
Work closely with stakeholders to understand business req...Show moreLast updated: 27 days ago
- Promoted
Data Modeling Specialist
VOISPune, Republic Of India, IN VOIS (Vodafone Intelligent Solutions) is a strategic arm of Vodafone Group Plc, creating value and enhancing quality and efficiency across 28 countries, and operating from 7 locations : Albania, Egy...Show moreLast updated: 27 days ago
- Promoted
Data Modeler
Best Infosystems Ltd.Pune, Republic Of India, IN Data Modeler_Full-Time_Pune / Bangalore (Hybrid, 3 Days WFO).Pune / Bangalore (Hybrid, 3 Days WFO).Creation and management of business data models in all their forms, including conceptual models, log...Show moreLast updated: 30+ days ago