Data Modeler Architect

Ascendion Engineering; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Ascendion is seeking a seasoned Data Architect to lead data architecture assessment, target data model design, and modernization of client data platforms. The role focuses on migration to cloud-native architectures on AWS and working with cross-functional teams to define canonical data models and governance standards.

You will drive current-state analysis, create dimensional models for BI, collaborate with data engineers, and ensure scalable, cost-efficient data solutions across the enterprise.

Qualifications

• 12+ years in Data Modeling and Data Architecture.
• Strong expertise in relational database design and normalization.
• Experience with PostgreSQL, DynamoDB, SQL Server environments.
• Hands-on experience with AWS-based enterprise platforms.
• Experience creating enterprise data dictionaries and governance artifacts.

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.
• Create conceptual, logical and physical data models for Disclosure and Work Actions modules.
• Design and maintain data models for enterprise apps and analytics platforms.
• Develop dimensional data models (Star/Snowflake) for reporting and BI.
• Collaborate with stakeholders to define data requirements.
• Create and maintain data dictionaries, metadata repositories, and data lineage docs.
• Design data models for AWS Data Lake and Data Warehouse environments.
• Work with ETL/ELT teams to ensure efficient data integration.
• Optimize data structures for performance, scalability and cost efficiency.
• Implement data governance, data quality, and MDM best practices.
• Assist modernization and cloud-migration projects.
• Support development teams during sprints and QA.
• Participate in discovery, design reviews, sprint demos and stakeholder workshops.

Skills

Data Modeling

Data Architecture

Relational Database Design

AWS Data Services

Data Governance

ETL/ELT

Agile/Scrum

SQL

Tools

ERwin

ER/Studio

PowerDesigner

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 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.

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

• 12+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.