PUNE · FULLTIME
Senior Data Modeler (Data Vault + AWS + SQL)
Ascendion
Pune · hybrid · Posted 2d ago
Your match
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
Job Summary
We are looking for an experienced Senior Data Modeler to support enterprise data modernization and cloud migration initiatives. The role will focus on designing conceptual, logical, and physical data models, assessing legacy data architecture, and defining future-state data models for AWS-based platforms.
Key Responsibilities
- Design conceptual, logical, and physical data models for enterprise applications and analytics platforms.
- Perform current-state data architecture assessments and support legacy modernization.
- Hands-on experience with Data Vault modeling.
- Develop Star and Snowflake schemas for reporting and analytics.
- Create source-to-target mappings, data dictionaries, metadata, and data lineage documentation.
- Design data models for AWS Data Lake/Data Warehouse environments.
- Work with ETL/ELT teams on data migration, integration, and transformation.
- Implement data governance, data quality, and MDM best practices.
- Collaborate with architects, developers, QA, SMEs, and business stakeholders.
Mandatory Skills
- 9 to 12+ years of Data Modeling / Data Architecture experience.
- Strong Data Vault experience.
- Strong SQL and relational database design skills.
- Experience with PostgreSQL, SQL Server, DynamoDB/DB2 or similar databases.
- Hands-on experience with AWS data platforms and cloud modernization.
- Experience with ERwin, ER/Studio, PowerDesigner, or similar modeling tools.
- Strong knowledge of data migration, source-to-target mapping, metadata, data lineage, and governance.
- Experience with API/integration data modeling.
Nice to Have
- QNXT experience
- Agile/Scrum experience
- Enterprise Data Lake/Data Warehouse modernization experience
Locations: Bangalore / Pune / Chennai / Hyderabad / Vadodara
Shift: 2 PM to 11 PM IST
Work Mode: Hybrid
Notice Period: Immediate Joiners or serving notice less than 30 Days
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
Section · Company
About Ascendion
Ascendion
IT Services & Consulting
3.3k+
employees
2022
4 years old
Basking Ridge, NJ
India
About
Ascendion is a leading provider of AI-first 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.
Industries
Employee ratings
799 reviews
Culture
3.2
Career growth
2.7
Work-life
3.3
Employees rate it well for
Find them on