Role description

Job Summary

Seeking an Associate Principal with 12 to 16 years of experience specializing in Data Architecture Snowflake and Dimensional Data Modeling to lead and architect scalable data warehouse solutions

Job Description

Lead the design and implementation of enterpriselevel data architectures leveraging Snowflake platform Develop and optimize dimensional data models including star and snowflake schemas to support complex business intelligence and analytics needs Architect scalable and highperformance Snowflake data warehouse solutions ensuring data integrity and consistency Collaborate with business stakeholders and technical teams to translate business requirements into robust data models and architecture Drive best practices in data modeling data integration and data governance across projects Stay abreast of emerging technologies and trends in Snowflake architecture and data modeling to continuously innovate and improve solutions Provide technical leadership and mentorship to data architects engineers and modelers within the team

Roles and Responsibilities

Own endtoend data architecture design and implementation for Snowflakebased data warehousing projects

Develop and maintain dimensional data models to support analytical and reporting requirements

Guide and review complex Snowflake SQL queries stored procedures and performance tuning

Lead requirement gathering sessions and provide expert insights on data modeling and Snowflake architecture

Ensure data quality validation and consistency through rigorous testing and governance

Collaborate crossfunctionally with data engineers BI developers database administrators and business analysts

Document data architecture standards processes and best practices to support knowledge sharing





Mentor junior and midlevel team members fostering skill development and knowledge transfer

Troubleshoot and resolve complex datarelated issues within Snowflake environments

Drive continuous improvement initiatives and encourage adoption of cutting-edge data architecture solutions

Skills
Mandatory Skills : Data Architecture, Dimensional Data Modeling, Snowflake

About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltm.com/careers/recruitment-fraud-alert

📌 Associate Principal - Architecture (Pune)
🏢 LTM
📍 Pune