Data Modeler Architect
Ascendion
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Ascendion in Bengaluru seeks a seasoned Data Architect to lead data architecture assessments and target models, guiding modernisation of client data platforms on AWS. You will craft canonical data models, governance artifacts, and collaborate across teams to ensure scalable, compliant data solutions.
Ideal candidates have 12+ years in data modeling/architecture, strong relational DB skills, and hands-on AWS data services experience, with Agile delivery familiarity.
Qualifications
- 12+ years in Data Modeling and Data Architecture.
- Expertise in relational database design and normalization.
- Experience with PostgreSQL, DynamoDB and 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.
- SQL concepts and database performance awareness.
- Knowledge of DB2, PostgreSQL, SQL Server and APIs.
- Data migration, transformation concepts and metadata management.
Responsibilities
- Conduct current-state data architecture assessment across data platform modules.
- Analyse source systems and define data mappings for migration and integration.
- Create conceptual, logical and physical data models for modules.
- Design data models for enterprise apps and analytics platforms.
- Develop dimensional models (Star/Snowflake) for BI needs.
- Collaborate with stakeholders, architects and data engineers on requirements.
- Create and maintain data dictionaries, metadata repositories, lineage docs.
- Design data models for AWS-based Data Lake and Data Warehouse.
- Work with ETL/ELT teams for efficient data integration and transformation.
- Optimize data structures for performance, scalability and cost.
- Implement data governance, data quality and master data management.
- Support data modernization and cloud migration projects.
- Assist development teams during sprint execution and reviews.
- Participate in discovery, design reviews and stakeholder workshops.
Skills
Tools
Job description
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, Europe, 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.
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.
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.
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.
- 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.
- 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.
- 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.
- 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
Be part of a team building next-generation AI solutions and helping enterprises accelerate innovation through Generative AI.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
