Senior Data Modeler (Teradata + OLAP)

Lead Data Modeler (Teradata + OLAP)

Location: Noida (Client / Office Location Vaishali)

Work Mode: All 5 Days Work from Office

Experience: 515 Years

Role Summary

We are looking for an experienced Data Modeler (Teradata + OLAP) to lead enterprise-scale data modeling initiatives. The role demands strong expertise in OLAP data modeling, Teradata data warehouse design, and close collaboration with business, analytics, and ETL teams to deliver high-performance analytical solutions.

Key Responsibilities

• Lead conceptual, logical, and physical data modeling for OLAP and enterprise data warehouse solutions on Teradata.
• Design and optimize dimensional models (Star / Snowflake schemas) for large-scale analytical and reporting use cases.
• Translate complex business requirements into scalable and highperforming data models.
• Work closely with ETL developers, BI/reporting teams, and data architects to ensure end-to-end data consistency.
• Drive performance tuning, including indexing strategies, partitioning, and query optimization.
• Ensure adherence to data standards, governance, naming conventions, and documentation (data dictionaries, metadata).
• Perform data model reviews and provide technical guidance/mentorship to junior modelers.
• Support stakeholder discussions and participate in technical design reviews.

Required Skills & Qualifications

• Strong expertise in Teradata data modeling with hands-on experience in large enterprise environments.
• Proven experience in OLAP data modeling, dimensional modeling, and data warehousing concepts.
• Deep understanding of Star / Snowflake schemas, facts, dimensions, SCDs.
• Excellent SQL proficiency on Teradata.
• Experience working closely with BI tools and reporting layers.
• Familiarity with performance tuning techniques in analytical databases.
• Experience with data modeling tools such as Erwin / ER Studio / equivalent.
• Strong analytical, problem-solving, and stakeholder communication skills.

Good to Have

• Exposure to Data Warehousing / Analytics / Enterprise Reporting projects.
• Experience in onsite or tightly governed delivery environments.
• Prior experience leading small teams or acting as module/technical lead.

Additional Notes

• Strictly 5 days work from office (Noida Vaishali).
• Candidates must have OLAP experience; OLTP-only profiles will not be suitable.
• Immediate joiners or candidates with short notice preferred.