Applications Engineer - ETL (Snowflake/Matillion)

Your Work Shapes the World at Caterpillar Inc.

Our common values and focus on inclusion and respect drive the decisions made by our company, teams and people. This is why we are committed to hiring and building diverse teams representative of the customers we serve globally. When you join our team, you can apply your unique life and job experiences and work in an environment where your ideas are heard, your contributions are celebrated, and your whole-self matters.

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 Cat Financial

Cat Financial is a subsidiary of Caterpillar Inc., 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 more than 40 years, Cat Financial has provided a wide range of financing solutions to customers and Cat® dealers for machines, engines, Solar® gas turbines, genuine Cat parts and services. Headquartered in Nashville, Tennessee, Cat Financial serves customers globally with offices and subsidiaries located throughout North and South America, Asia, Australia, Europe and Africa. Visit cat.com to learn more about Cat Financial.

Role Definition
Assists in developing, testing and implementing application systems. Join a team of developers who provide ETL via Matillon into Snowflake providing both Operational and Data Warehouse data support.

Preferred Skills

• 8+ Years of Experience in ETL / ELT.

• Proficient experience in Snowflake and Matillion.

• Hands on experience on developing SQL and Python scripts for automation.

• Excellent research, analysis and problem solving skills.

• Strong verbal and written communication skills.

• Ability to understand the functional and technical design architecture implemented on Snowflake.

Responsibilities

• Lead the design, development, and implementation of ETL processes using Matillion and Snowflake.

• Answer & respond to data requests on demand.

• Manage through multiple & business requirements. Develop solutions that best meet the needs of the business partners.

• Participates in developing, coding and testing computer programs for relatively straightforward or small projects.
• Assist in preparing technical and procedural documentation required in application system development.
• Provide detailed flowcharts to show processing logic for simple application programs.
• Contribute solutions for programming system operations, including encoding, testing, debugging and documenting programs.

Degree Requirement
Degree or equivalent experience desired

Skill Descriptors
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 basic activities and deliverables of application design; ability to utilize application design methodologies, tools and techniques to convert business requirements and logical models into a technical application design.
Level Working Knowledge:
• Works with specific development platforms, system and program design tools.
• Participates in the technical design of a specific application.
• Selects and presents design alternatives for applications of small to medium complexity.
• Defines tasks, activities, deliverables and key concerns of technical design.
• Assists in reviewing and documenting technical application designs.

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.

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 integration efforts.

System Testing: Knowledge of system and software testing; ability to design, plan and execute system testing strategies and tactics to ensure the quality of software at all stages of the system life cycle.
Level Working Knowledge:
• Supports the project leader in developing and executing system test plans.
• Evaluates system documentation and user manuals for usability, accuracy and completeness.
• Executes test cases, analyzes test results and reports on findings regularly.
• Tests system components for compliance with functional requirements.
• Participates in the testing of a system's ability to recover from hardware or software failures.

Systems Software Infrastructure: Knowledge of computer architecture and system software interaction; ability to design and build a fundamental architecture of operating systems, database management systems, communications protocols, compilers and other development tools.
Level Working Knowledge:
• Reports software connectivity and integration issues.
• Demonstrates planned software changes on the local environment.
• Administers software migration and contingency plans related to own function.
• Analyzes the local software architecture components and products.
• Tests key features for the entire software infrastructure environment.

Technical Troubleshooting: Knowledge of technical troubleshooting approaches, tools, and techniques; ability to anticipate, recognize, and resolve technical issues on hardware, software, application, or operation.
Level Working Knowledge:
• Handles calls related to product features, applications, and compatibility standards.
• Analyzes code, logs, and current systems as part of advanced troubleshooting.
• Discovers, analyzes and resolves hardware, software, or application problems.
• Records and reports specific technical problems, solving processes and tools that have been used.
• Works with vendor-specific diagnostic guides, tools, and utilities.

Technical Writing/Documentation: Knowledge of technical writing; ability to write technical documents such as manuals, reports, guidelines or documents on standards, processes and applications.
Level Working Knowledge:
• Implements technical documentation standards, guidelines and best practices.
• Prepares written text and layout of materials according to required outlines and specifications.
• Completes and maintains technical reference documents.
• Uses the major features, functions and facilities of an automated documentation tool.
• Coordinates and constantly updates system operations, installations, service manuals, and help documents.

This Job Description is intended as a general guide to the job duties for this position and is intended for the purpose of establishing the specific salary grade. It is not designed to contain or be interpreted as an exhaustive summary of all responsibilities, duties and effort required of employees assigned to this job. At the discretion of management, this description may be changed at any time to address the evolving needs of the organization. It is expressly not intended to be a comprehensive list of “essential job functions” as that term is defined by the Americans with Disabilities Act.

#LI-Hybrid