Senior Data Modeler (ER Studio/Erwin)

Role: Senior Data Modeler (ER Studio/Erwin)

Location: Gurugram/Mumbai, 5 days WFO

Duration: Permanent (FullTime)

Notice Period: Immediate joiners preferred

Experience: 8-12 Years

What you will do:

• We are looking for a highly experienced Senior/Lead Data Architect with 8-10 years of experience in Data Warehousing and Dimensional Modeling, strong expertise in ER Studio/Erwin Data Architect, and deep Airline domain knowledge.
• The candidate will drive enterprise-level data architecture, design scalable dimensional models, and lead data initiatives across airline business functions.
• Key Responsibilities Architecture & Strategy Define and own enterprise Data Warehouse & Dimensional Modeling strategy.
• Design scalable Star/Snowflake schemas aligned with enterprise data architecture.
• Establish modeling standards, naming conventions, and governance frameworks.
• Define data modeling best practices using Kimball methodology (and hybrid approaches where applicable).
• Data Modeling & Design Lead logical and physical data modeling using ER Studio.
• Define fact table grain, conformed dimensions, surrogate key strategy, and SCD approaches (Type 1, 2, 3, Hybrid).
• Design models for: Reservations & PNR Ticketing & Fare rules Flight Operations Revenue Management Revenue Accounting Ancillary services Cargo operations Loyalty / Frequent Flyer Programs Customer 360 Ensure historical data tracking and audit compliance.
• Conduct performance optimization and partitioning strategy.
• Leadership & Governance Lead and mentor data modelers and ETL teams.
• Conduct architecture/design reviews. Collaborate with enterprise architects, BI teams, and business stakeholders.
• Drive data governance, classification, lineage, and metadata management. Ensure regulatory compliance and data security policies.