LT

Senior Data Modeler (Teradata + OLAP)

LTM
Noida Posted 17 Nov 2026
FULL TIME
Olap
Erwin
Bi Tools
Dimensional Modeling
Er Studio
+3 more

Job Description

Lead – Data Modeler (Teradata + OLAP)

Location: Noida (Client / Office Location – Vaishali)

Work Mode: All 5 Days Work from Office

Experience: 5–15 Years

Role Summary

We are seeking an experienced Data Modeler (Teradata + OLAP) to drive enterprise-grade data modeling efforts. This position requires deep knowledge of OLAP data modeling and Teradata data warehouse design, along with strong collaboration across business, analytics, and ETL functions to implement high-performing analytical solutions.

Key Responsibilities

  • Lead the creation of conceptual, logical, and physical data models for OLAP and enterprise data warehouse implementations on Teradata.
  • Develop and refine dimensional models (Star / Snowflake schemas) for large-scale analytical and reporting scenarios.
  • Convert complex business requirements into scalable, high‑performance data models.
  • Collaborate with ETL developers, BI/reporting teams, and data architects to maintain end-to-end data consistency.
  • Own performance tuning activities, including indexing approaches, partitioning, and query optimization.
  • Ensure compliance with data standards, governance, naming conventions, and maintain complete documentation such as data dictionaries and metadata.
  • Conduct data model reviews and provide technical guidance/mentorship to junior data modelers.
  • Participate in technical design reviews and support stakeholder discussions.

Required Skills & Qualifications

  • Strong expertise in Teradata data modeling with practical experience in large enterprise setups.
  • Demonstrated experience in OLAP data modeling, dimensional modeling, and data warehousing principles.
  • Thorough understanding of Star / Snowflake schemas, facts, dimensions, SCDs.
  • Excellent SQL capability on Teradata.
  • Experience working with BI tools and reporting layers.
  • Knowledge of performance tuning methods for analytical databases.
  • Hands-on experience with data modeling tools such as Erwin / ER Studio / equivalent.
  • Strong analytical thinking, problem-solving abilities, and stakeholder communication skills.

Good to Have

  • Experience in Data Warehousing / Analytics / Enterprise Reporting initiatives.
  • Exposure to onsite or tightly governed delivery environments.
  • Prior background leading small teams or functioning as a 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.

foundit: Fast. Faster. foundit. 10 lakh+ jobs, top recruiters hiring. Register nowSponsored
Join WhatsApp Channel