Talent.com
Data Modeler

Data Modeler

AscendionKalyan-Dombivli, IN
5 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 • Kalyan-Dombivli, IN

    Related jobs
    • Promoted
    ML Ops

    ML Ops

    EXLdombivli, 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
    Python Developer

    Python Developer

    LTIMindtreemumbai, 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: 30+ days ago
    • Promoted
    Collection Analytics and Modeling

    Collection Analytics and Modeling

    KisshtMumbai, Maharashtra, India
    Job Overview : The role involves developing and optimizing scorecards, early warning models, and segmentation frameworks to improve recovery rates and reduce delinquencies.You will collaborate w...Show moreLast updated: 25 days ago
    • Promoted
    BIM Modeler

    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

    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
    Data Modeler

    Data Modeler

    RecroKalyan-Dombivli, 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 Modeler

    Data Modeler

    Tata Consultancy ServicesMumbai, 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
    JP Morgan Chase - Associate - Data Modeler

    JP Morgan Chase - Associate - Data Modeler

    JP Morgan ChaseMumbai, India
    Data Modeler - Associate Description : You are a strategic thinker passionate about driving solutions in Data Modelling. As a Data Modeler within our ...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Looker Developer

    Looker Developer

    Quess Corp LimitedMumbai, IN
    Hands-on experience (3+ years) developing, deploying, and managing solutions within the Looker ecosystem.Proficiency in LookML for building models, derived tables, and reusable views.Strong SQL exp...Show moreLast updated: 4 hours ago
    • Promoted
    Data Modeler

    Data Modeler

    ConfidentialMumbai, Delhi
    We are seeking a highly skilled and analytical.This pivotal role is responsible for designing and developing robust data models by engaging directly with business stakeholders and performing in-dep...Show moreLast updated: 30+ days ago
    Data Modeler

    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
    Senior Data Modeler

    Senior Data Modeler

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

    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
    Teradata Data Modeler

    Teradata Data Modeler

    ConfidentialMumbai, India
    Our technology services client is seeking multiple.These positions offer a strong potential for conversion to full-time employment upon completion of the initial contract period.Below are further d...Show moreLast updated: 10 days ago
    • Promoted
    • New!
    Data Modeler

    Data Modeler

    People Prime WorldwideMumbai, 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: 5 hours ago
    • Promoted
    Looker Developer

    Looker Developer

    RiDiK (a Subsidiary of CLPS. Nasdaq : CLPS)Kalyan-Dombivli, 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
    Coastal Modeler | ISIR.AI

    Coastal Modeler | ISIR.AI

    ISIR AIKalyan-Dombivli, 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
    PHI - Lead- Data Modeler

    PHI - Lead- Data Modeler

    ConfidentialMumbai
    Technical Skills & work experience : .MH : Proven hands-on experience in data modeling, with a strong understanding of data modeling principles, methodologies, and tools. MH : Demonstrated ability to un...Show moreLast updated: 30+ days ago