IT Analyst Applications (Snowflake Developer)

Job description

Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. About Caterpillar Caterpillar Inc. is the world’s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we’ve been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed. Your Impact Shapes the World at Caterpillar Inc When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. Job Summary We are seeking a skilled IT Analyst Applications (Snowflake Developer) to join Order Fulfillment & Procureme – Cat IT Division team. With 3 to 5 years of experience in designing, developing, and supporting enterprise data solutions within Procurement applications in RI IT. The candidate will be responsible for building scalable data pipelines, optimizing Snowflake data models, and enabling analytics solutions across Procurement Data Platforms such as EPDP and SCDP. The preference for this role is to be based out of Bangalore – Caterpillar PSN This position requires candidate to work a 5-day -a -week schedule. Shift Timing : 01:00-10:00PM IST Key Responsibilities • Design, develop, and maintain data pipelines and ETL/ELT processes using Snowflake and cloud-based data technologies. • Build and optimize Snowflake databases, schemas, tables, views, stored procedures, tasks, and streams. • Develop data integration solutions to ingest data from ERP, procurement, supplier, and supply chain systems into enterprise data platforms. • Support Procurement analytics, supplier management, sourcing, item master data, and spend analytics initiatives. • Collaborate with business analysts, product owners, and data consumers to gather requirements and deliver data solutions. • Monitor data quality, troubleshoot performance issues, and implement optimization strategies. • Develop reusable data models and ensure adherence to enterprise data governance and security standards. • Support reporting and analytics teams by enabling data access for Power BI and other BI solutions. • Participate in Agile ceremonies, code reviews, testing, and deployment activities. Required Skills • 3 to 5 years of experience in Data Warehousing and Data Engineering. • Strong hands-on experience with Snowflake. • Proficiency in SQL, Python, data modeling, and performance tuning. • Knowledge of cloud platforms such as AWS. • Understanding of Supply Chain, Procurement, or Manufacturing business processes. • Experience working with large-scale enterprise datasets and analytical solutions. • Familiarity with CI/CD practices and Git-based version control. Preferred Skills • Knowledge with Power BI and analytics reporting. • Exposure to procurement systems, supplier management, sourcing, and master data domains. • Knowledge of Python or scripting languages for automation. • Experience working in Agile/Scrum environments. Qualifications • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field. • Snowflake certification is preferred. • Strong analytical, communication, and problem-solving skills. Skill Descriptors Core Application Systems: Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations. Level Basic Understanding: • Describes basic elements and benefits of core applications supported by own area. • Names the organization's core application systems. • Names major business functions and services supported by core applications. • Locates and uses relevant documentation for core applications. Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations. Level Basic Understanding: • Explains the value of a disciplined approach to problem solving. • Describes problem reporting and escalation practices. • Utilizes accepted procedures for problem analysis and resolution. • Identifies key aspects of problem-solving techniques used in own area. Application Design, Architecture: Knowledge of application design and architecture principles and practices; ability to utilize application design methodologies, tools, and techniques to convert business requirements and logical models into a technical application design. Level Basic Understanding: • Describes the role of design patterns and principles in application design and architecture. • Identifies the basic components of an application design. • Lists common application architecture styles, such as monolithic, microservices, and event-driven architecture. • Explains the importance of scalability, security, and performan