IT Analyst Applications (Snowflake Developer)

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 an experienced IT Analyst Applications (Snowflake Developer) to join RI Order Fulfilment & Procurement–CAT IT Division . To support the SDP (Sales Data Platform), EPDP, and SCDP applications. This role will be responsible for developing, enhancing, and maintaining Snowflake-based data solutions while ensuring high availability, performance, and data quality across critical procurement and supplier data platforms. 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 optimize Snowflake data models, ETL/ELT pipelines, and data integration solutions. Support ongoing development and production support activities for SDP, EPDP, and SCDP applications. Collaborate with business stakeholders, analysts, and application teams to understand data requirements and deliver scalable solutions. Develop and maintain data ingestion, transformation, and reporting processes using Snowflake and cloud-based technologies. Monitor and troubleshoot data pipelines, resolve production issues, and perform root cause analysis. Optimize database performance, storage, and query efficiency. Ensure data security, governance, and compliance standards are maintained. Support system upgrades, data migrations, and modernization initiatives. Participate in Agile development processes, code reviews, and technical documentation. Work closely with onsite and offshore teams to deliver high-quality solutions and support business objectives. Required Qualifications Bachelor's degree in Computer Science, Information Technology, Engineering, or equivalent experience. 5+ years of experience in data engineering, data warehousing, or database development. Strong hands-on experience with Snowflake, SQL, Python and data modeling concepts. Experience with ETL/ELT tools, data integration frameworks, and cloud platforms (AWS preferred). Knowledge of data warehousing, performance tuning, and data governance best practices. Experience supporting production systems and resolving complex data-related issues. Strong analytical, problem-solving, and communication skills. Preferred Qualifications Experience with AWS services, CI/CD pipelines, and DevOps practices. Knowledge of procurement, supplier management, or enterprise data platforms. Familiarity with reporting and visualization tools such as Power BI. Experience working in global support and development environments 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 Working Knowledge: • Identifies and documents specific problems and resolution alternatives. • Examines a specific problem and understands the perspective of each involved stakeholder. • Develops alternative techniques for assessing accuracy and relevance of information. • Helps to analyze risks and benefits of alternative approaches and obtain decision on resolution. • Uses fact-finding techniques and diagnostic tools to identify problems. 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 Working Knowledge: • Creates a basic architecture diagram, including component interactions and data flows. • Identifies and prioritizes application design and architecture tasks, such as refactoring and technical debt reduction. • Selects and presents design alternatives for applications of small to medium complexity. • Uses design tools and technologies to develop prototypes and proof of concepts. • Documents design decisions and rationale for future reference and review. Implementation: Knowledge of how to run applications for organizations; ability to implement application software within an organization and help end-users perform specific tasks (ex: accounting or graphic design). Level Working Knowledge: • Tracks problems associated with the quality and effectiveness of application software. • Researches the benefits and drawbacks of an organization's application software. • Drafts application software usage for the department's needs. • Provides instant support for end users of application software. • Implements a specific application software under the supervision of management. Requirements Analysis: Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project. Level Working Knowledge: • Follows policies, practices and standards for determining functional and informational requirements. • Confirms deliverables associated with requirements analysis. • Communicates with customers and users to elicit and gather client requirements. • Participates in the preparation of detailed documentation and requirements. • Utilizes specific organizational methods, tools and techniques for requirements analysis. System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms. Level Working Knowledge: • Assists with current and planned integration initiatives. • Explores major issues and considerations for successful system integration. • Works with applications, data, technology bridges and a variety of platforms. • Works with existing interfaces as well as integration and migration plans within own area. • Plays an active role in local integratio