We are looking for a highly experienced Senior/Lead Data Architect with 1520 years of experience in Data Warehousing and Dimensional Modeling, robust expertise in ER Studio 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.

📌 Data Modeller Gurugram
🏢 AIonOS
📍 Gurugram