Data modeler
3 days ago
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 Ed Tech domain is a plus.Primary ObjectiveReverse 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 Saa S environment.Key ResponsibilitiesDatabase Analysis & Reverse EngineeringReverse engineer existing OLTP databases to create comprehensive conceptual, logical, and physical data modelsAnalyze current schema design to identify denormalization patterns, data redundancies, integrity issues, and architectural debtProfile existing data quality, identify anomalies, inconsistencies, and constraint violationsDocument current state architecture, data flows, and integration pointsSchema Redesign & NormalizationRedesign database schema by applying normalization principles (1 NF through BCNF) to eliminate redundancy and improve data integrityCreate optimized conceptual, logical, and physical data models for the target state architectureDesign migration paths that maintain referential integrity and business rule enforcementIdentify opportunities for strategic denormalization where justified by performance requirementsMigration Strategy & ExecutionDevelop comprehensive migration strategies with minimal or zero downtime requirementsDesign data transformation logic to migrate from denormalized to normalized structuresCreate phased migration approaches using patterns such as strangler fig, dual-write, or shadow databasesImplement data validation and reconciliation frameworks to ensure migration accuracyDevelop rollback strategies and contingency plans for migration phasesCoordinate database deployment using CI/CD pipelines and migration toolsPerformance Optimization & TuningBenchmark existing system performance to establish baselinesOptimize new schema design through indexing strategies, partitioning, and query optimizationConduct load testing and performance validation pre and post-migrationFine-tune database configuration, connection pooling, and caching strategies for AWS Aurora Postgre SQLEnsure normalized design meets or exceeds current performance benchmarksData Governance, Security & ComplianceEnsure redesigned data model maintains compliance with relevant standards (GDPR, HIPAA, FERPA for Ed Tech)Implement data governance policies, access controls, and security measures in new architectureDefine and enforce data quality standards throughout migration processEstablish data lineage and metadata management for new structuresDocumentation & Knowledge
-
Data Modeler
22 hours ago
pune, India Abacus Insights Full timeAbout UsAbacus Insights is changing the way healthcare works for you. We're on a mission to unlock the power of data so health plans can enable the right care at the right time—making life better for millions of people. No more data silos, no more inefficiencies. Just smarter care, lower costs, and better experiences.Backed by $100M from top VCs, we're...
-
Data Modeler
3 weeks ago
Pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO) Job Title: Data Modeler Job Type: Full-Time Location: Pune /Bangalore (Hybrid , 3 Days WFO) Shift Timing: 2:30 PM to 10:30 PM Experience: 10-14 Years Job Description: • Creation and management of business data models in all their forms, including conceptual models, logical data models and...
-
Data Modeler
18 hours ago
pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO) Job Title: Data Modeler Job Type: Full-Time Location: Pune /Bangalore (Hybrid , 3 Days WFO) Shift Timing: 2:30 PM to 10:30 PM Experience: 10-14 Years Job Description: • Creation and management of business data models in all their forms, including conceptual models, logical data models and...
-
Data Modeler
2 weeks ago
Pune, Maharashtra, India Growel Softech Pvt. Ltd. Full time ₹ 5,00,000 - ₹ 10,00,000 per yearPosition OverviewWe are seeking a skilled Data Modeler to join our team. The Data Modeler will be responsible for designing, implementing, and maintaining data models that support business requirements and enable efficient data storage, retrieval, and analysis. The ideal candidate will have a strong understanding of data modeling principles, database...
-
Data Modeler
3 weeks ago
Pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...
-
Data Modeler
4 weeks ago
Pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...
-
Data Modeler
2 weeks ago
Pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...
-
Data Modeler
4 days ago
pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...
-
Data modeler
3 days ago
Pune, India Best Infosystems Ltd. Full timeData Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...
-
Data Modeler
22 minutes ago
Pune, Maharashtra, India Abacus Insights Full time ₹ 6,00,000 - ₹ 18,00,000 per yearAbout UsAbacus Insights is changing the way healthcare works for you. We're on a mission to unlock the power of data so health plans can enable the right care at the right time—making life better for millions of people. No more data silos, no more inefficiencies. Just smarter care, lower costs, and better experiences.Backed by $100M from top VCs, we're...
