Senior Manager

Ex; Gurugram District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Ex is hiring a Data Modeler to design and maintain data models across conceptual, logical, and physical layers. The role emphasizes scalable dimensional models and analytics-ready structures, aligning with platform standards and collaborating with data architects and engineers.

The ideal candidate has 7+ years of data modeling experience, strong SQL, and a deep understanding of data warehousing and ETL architectures. This is a full-time on-site position based in Gurga on/Bangalore.

Qualifications

• 7+ years of experience in data modeling for large-scale data platforms.
• Strong expertise in dimensional modeling, normalized and denormalized designs.
• Good understanding of data architecture and ETL architecture.
• Advanced SQL skills and deep understanding of analytical query patterns.
• Experience working closely with data architects and engineering teams.
• Strong understanding of data warehousing and analytics use cases.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Develop scalable dimensional for analytics and reporting.
• Collaborate with data architects and engineers to align models with platform and architectural standards.
• Translate business requirements into high-quality, reusable data structures.
• Ensure data consistency, integrity, and performance across data layers.
• Support impact analysis, data lineage, and metadata documentation.

Skills

Dimensional modeling

SQL

Data warehousing

ETL architecture

Analytical queries

Collaboration with data teams

Job description

Role: Data Modeler

Location:Gurgaon/Bangalore (5 days mandatory work from office)

Type:Full-time

Experience:7+ years

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models
• Develop scalable dimensional for analytics and reporting
• Collaborate with data architects and engineers to align models with platform and architectural standards
• Translate business requirements into high-quality, reusable data structures
• Ensure data consistency, integrity, and performance across data layers
• Support impact analysis, data lineage, and metadata documentation

Must-Have Skills

• 7+ years of experience in data modeling for large-scale data platforms
• Strong expertise in dimensional modeling, normalized and denormalized designs
• Good understanding of data architecture and ETL architecture
• Advanced SQL skills and deep understanding of analytical query patterns
• Experience working closely with data architects and engineering teams
• Strong understanding of data warehousing and analytics use cases