Data Modeler Architect

Ascendion Engineering; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 3,000,000 - 5,500,000; Full time

Job summary

Ascendion is seeking a highly experienced Lead/Architect to steer data architecture assessment, target model design, and modernization of the Client Data platform. The role will support migration to a cloud-native architecture on AWS, working with architects, analysts, SMEs, and developers to define canonical data models and governance standards.

Experience in banking domain is mandatory, with focus on data governance, migration mappings, and enterprise data modeling for Data Lake and Data

Qualifications

• 6+ years in data modeling and data architecture.
• Relational DB design and normalization expertise.
• Experience with PostgreSQL, DynamoDB, SQL Server environments.
• Experience supporting legacy modernization programs.
• Hands-on AWS-based enterprise platforms.
• Experience creating enterprise data dictionaries and governance artifacts.
• Experience in Agile/Scrum delivery environments.

Responsibilities

• Assess current-state data architecture across data platform modules.
• Define data mappings for migration and integration initiatives.
• Create conceptual, logical and physical data models for modules.
• Design data models for enterprise apps and analytics.
• Develop dimensional data models (Star/Snowflake) for BI.
• Collaborate with stakeholders to define data requirements.
• Maintain data dictionaries, metadata repositories and lineage docs.
• Design data models for AWS Data Lake/Warehouse.
• Coordinate with ETL/ELT teams for data integration.
• Ensure performance, scalability and cost efficiency.
• Implement data governance and master data management.

Skills

Data modeling

Data architecture

Relational DB design

PostgreSQL

DynamoDB

SQL Server

Legacy modernization

AWS

Data dictionaries

Agile/Scrum

Tools

ERwin

ER/Studio

PowerDesigner

AWS Data Services

Job description

About Ascendion

Ascendion is a leading provider of AI-Native software engineering services. Our applied AI, software engineering, cloud, data, experience design, and talent transformation capabilities accelerate innovation for Global 2000 clients. Ascendion is headquartered in New Jersey. In addition to our remote/hybrid workforce, we have a presence in 12 countries and 40+ global offices across North America, Europse, and APAC. We are committed to building technology powered by Generative AI with an inclusive workforce, service to our communities, and a vibrant culture. For more information, please go to www.ascendion.com.

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

Job Description:

We are looking for a highly experienced Lead/Architect with strong expertise to lead data architecture assessment, target data model design, legacy data analysis, and modernization of the Client Data platform. The role supports migration of applications to a modern cloud-native architecture hosted on AWS. The Data Modeler will work with architects, business analysts, SMEs, developers, QA teams and modernization specialists to define canonical data models, integration structures, data governance standards, and future-state information architecture.

Please Note: Experience in Banking Domain is Mandatory

Key Responsibilities

• Conduct current-state data architecture assessment across Data Platform modules and data structures.
• Analyse source systems and define data mappings for migration and integration initiatives.
• Create conceptual, logical and physical data models for Disclosure and Work Actions modules.
• Design and maintain conceptual, logical, and physical data models for enterprise applications and analytics platforms.
• Develop dimensional data models (Star Schema, Snowflake Schema) for reporting and business intelligence.
• Collaborate with business stakeholders, architects, and data engineers to define data requirements.
• Create and maintain data dictionaries, metadata repositories, and data lineage documentation.
• Design data models for AWS-based Data Lake and Data Warehouse environments.
• Work closely with ETL/ELT teams to ensure efficient data integration and transformation.
• Optimize data structures for performance, scalability, and cost efficiency.
• Implement data governance, data quality, and master data management best practices.
• Analyse source systems and define data mappings for migration and integration initiatives.
• Support data modernization and cloud migration projects.
• Assist development teams during sprint execution and defect triage.
• Participate in discovery, design reviews, sprint demos and stakeholder workshops.

Required Skills

• 6+years in Data Modeling and Data Architecture.
• Strong expertise in relational database design and normalization.
• Experience with PostgreSQL, Dynamo DB, SQL Server environments.
• Experience supporting legacy modernization programs.
• Hands-on experience with AWS-based enterprise platforms.
• Experience creating enterprise data dictionaries and governance artifacts.
• Experience in Agile/Scrum delivery environments.

Technical Skills

• Data Modeling tools: ERwin, ER/Studio, PowerDesigner or equivalent.
• SQL and database performance concepts.
• DB2, SQL Server, PostgreSQL or equivalent RDBMS knowledge.
• API and integration data modeling.
• Data migration and transformation concepts.
• Metadata management and data lineage practices.
• AWS Data Services awareness.
• UML, ERD and information architecture documentation.

Key Success Factors

• Approved target data model design
• 100% traceability between requirements and data entities
• Support successful modernization of Disclosure and Work Actions modules
• High-quality documentation signoff
• No critical data architecture defects during QA and equivalence testing

Join Ascendion

Be part of a team building next-generation AI solutions and helping enterprises accelerate innovation through Generative AI.