Data ModelerAscendion • Pālghāt, Republic Of India, IN

No longer accepting applications

Data Modeler

Ascendion • Pālghāt, Republic Of India, IN

7 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 • Pālghāt, Republic Of India, IN

Related jobs

Data Architect

Tredence Inc. • Thrissur, IN

IT experience and 7+ years' experience in SQL Server, SSIS, SQL, Python / C#, ETL, Streaming.Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL p...Show more

Last updated: 8 hours ago • Promoted • New!

Data Architect

R Systems • Palakkad, IN

Experience of more than 10 years in Data and architecture with Snowflake and other ETL tools, Lead the comprehensive design and implementation of enterprise data architecture utilizing Snowflake an...Show more

Last updated: 8 hours ago • Promoted • New!

Data Integration Developer (Level 2)

Blutic • Palakkad, 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 more

Last updated: 14 days ago • Promoted

Data Engineer with SQL / ETL / Pyspark

Infosys Finacle • Palakkad, IN

Mandate Skills - SQL, ETL ,hadoop, pyspark,.Pipeline / ETL (Extract, Transform, Load) processes, API integration, scripting languages (Python), and big data technologies (Trio, Iceberg, DuckDB / Parque...Show more

Last updated: 8 hours ago • Promoted • New!

Data Scientist

Recro • Coimbatore, IN

Modeling & ML Frameworks : Python, scikit-learn, PyTorch, TensorFlow — spanning classical.ML, deep learning, and transformer-based architectures. Includes modern ensemble methods.XGBoost, LightGBM) fo...Show more

Last updated: 30+ days ago • Promoted

Enterprise Data Architect

DBiz.ai • Palakkad, IN

You will ensure that data is modeled, structured and integrated across the organization to support analytics and AI / ML initiatives at scale. You will work closely with business stakeholders and tech...Show more

Last updated: 25 days ago • Promoted

Databricks Data Engineer Lead – Sustainability Project

Blue Cloud Softech Solutions Limited • Thrissur, IN

BCSS is seeking a Databricks Data Engineer to support its enterprise-wide Sustainability initiative.The engineer will be responsible for building data pipelines and models to support product-level ...Show more

Last updated: 8 hours ago • Promoted • New!

BIM Modeler

FUSION ARCHITECTURE URBAN • Palakkad, IN

Minimum 5–10 years in BIM modeling.We deliver major administrative, residential, commercial, industrial, and urban developments across Africa and beyond. To strengthen our digital production team, w...Show more

Last updated: 8 hours ago • Promoted • New!

Data Labeler

Innodata Inc. • Palakkad, IN

AI and Machine Learning talent network.Data Annotators and Content Moderators (Review & Labeling).If you enjoy working with data, pay close attention to detail, and want to contribute to real-world...Show more

Last updated: 5 days ago • Promoted

Data Integration Developer (Level 1)

Blutic • Thrissur, IN

Data Integration Developer (Level 1).ETL processes and reports using.This entry-level role is ideal for developers looking to grow their skills in enterprise data solutions while contributing to cr...Show more

Last updated: 5 days ago • Promoted

Data Architect

Andela • Coimbatore, IN

Andela exists to connect brilliance and opportunity.Since 2014, we have been dedicated to breaking down global barriers and accelerating the future of work for both technologists and organizations ...Show more

Last updated: 8 hours ago • Promoted • New!

Model Validation

Tata Consultancy Services • Palakkad, IN

Year of Experience- 6 to 15 Years.Location-Bangalore, Hyderabad, Chennai, Pune, Kolkata.As a Senior Quantitative Analytics Associate, you will be responsible for leading independent validations and...Show more

Last updated: 8 hours ago • Promoted • New!

Looker Developer

RiDiK (a Subsidiary of CLPS. Nasdaq : CLPS) • Coimbatore, 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 more

Last updated: 14 days ago • Promoted

Data Modeler

Stratus • Thrissur, IN

Lead a team of data engineers to develop data analytic solutions such as data warehouse and data marts on Azure Databricks. Experience with Agile development methodologies and tools, such as Jira, t...Show more

Last updated: 6 days ago • Promoted

ML Data Scientist

Worko • Palakkad, IN

We are hiring for one of India’s most popular and fast-growing e-commerce companies.Bachelor's / Master's degree in computer science or similar degrees. Data Scientist in a fast-paced organization, pr...Show more

Last updated: 8 hours ago • Promoted • New!

Fashion Model

Zia Models • Coimbatore, IN

Virtual Fashion Model (Remote) at Zia Models.Part / Full Time | Work From Home.Starting from USD $4,900 per project (based on portfolio & experience). Zia Models strictly adheres to ethical hiring p...Show more

Last updated: 30+ days ago • Promoted

ML Ops

EXL • Coimbatore, 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 more

Last updated: 30+ days ago • Promoted

LLM Research Data Scientist

Innodata Inc. • Thrissur, IN

Location- Remote Job(Full Time).Master's degree in Data Science, computer Science or a related field.High proficiency with AI tools (e. Copilots, GenAI platforms) and applying them to complex real-w...Show more

Last updated: 30+ days ago • Promoted