Senior Data Modeler (Teradata + OLAP)

LTM; Dadri; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

LTM is seeking an experienced Data Modeler (Teradata + OLAP) in Dadri, Uttar Pradesh to lead enterprise-scale data modeling initiatives. The role requires strong expertise in OLAP data modeling and Teradata data warehouse design, collaborating with analytics and ETL teams. Responsibilities include data model design, performance tuning, and ensuring adherence to data governance. Ideal candidates should have 5-15 years of experience and must have OLAP experience; onsite work is required for 5 days a week.

Qualifications

• 5–15 years of experience in data modeling with a focus on OLAP and Teradata.
• Proven experience in leading data modeling initiatives at an enterprise level.
• Strong analytical and problem-solving skills along with effective communication.

Responsibilities

• Lead conceptual, logical, and physical data modeling for OLAP solutions.
• Design and optimize dimensional models for analytics and reporting.
• Drive performance tuning including indexing strategies and optimization.

Skills

Teradata data modeling

OLAP data modeling

SQL proficiency

Dimensional modeling

Data modeling tools

Performance tuning

Stakeholder communication

Tools

Erwin

ER Studio

Job description

Work Mode: All 5 Days Work from Office

Experience: 5–15 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 high‑performing 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.