Career Area: Business Technologies, 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.
Python Developer
Role Definition:
This team is responsible for managing the business partners Snowflake platform. We have developed a Python package to manage our ETL activities. This advanced package is used to extract, transform, and load data coming from various sources into our Snowflake database.
As a Python Developer, you will be responsible for maintaining our Python ETL package and developing new functionalities. Partnering with our DBA, your role will also be to follow up ETL jobs execution, troubleshoot and resolve any issues with the ETL jobs. Our team is located both in Europe and in the US, the business partners we support are located all other the globe, so you will have the opportunity to interact with people from different continent and cultures.
What You Do:
Maintain and update the ETL package developed by the team in Python.
Ensure that ETL jobs run correctly and efficiently and monitor their performance and status.
Troubleshoot and resolve any issues with the ETL jobs or the data sources and communicate with the data owners.
Create and access Snowflake objects such as tables, views to ensure that the data is correctly loaded into the Snowflake database.
What You Have:
Bachelor's degree in computer science, information systems, or related field, or equivalent work experience.
At least 1 year of experience in Python development.
Basic knowledge of SQL and relational databases, preferably Snowflake.
Basic experience with data modeling and data quality concepts.
Ability to work independently and collaboratively with a team.
Excellent communication, problem-solving, and analytical 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 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 Basic Understanding:
Describes basic activities and deliverables associated with application design.
Discusses technical architecture relevant to own environment.
Identifies technical application architecture standards and considerations.
Names the specific tasks, activities and deliverables of technical application design.
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 Basic Understanding:
Cites specific types of application software and their usage within an organization.
Identifies problems commonly associated with application implementation.
Lists main application software and vendors in the market place.
Describes the general processes and policies of application implementation.
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 Basic Understanding:
Cites examples of functional and non-functional requirements.
Describes basic concepts and major activities associated with requirements analysis.
Explains the life cycle context and scope of requirements analysis.
Explains the structure and components of effective requirements analysis documents.
System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms.
Level Basic Understanding:
Describes the basic concepts and issues of system and technology integration.
Illustrates the risks and benefits of technology integration projects.
Discusses major software, hardware or application integration initiatives and plans.
Explains system integration initiatives in own environment.
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 Basic Understanding:
Documents the standard processes and procedures involved in system testing.
Explains the importance of thorough system testing prior to implementation.
Identifies common errors that occur in standard system testing activities.
Education/Experience: Degree or equivalent experience desired
Additional Info :
The primary location for this position is Peoria, IL, Dallas, TX or Nashville, TN.
This role requires 3 days onsite.
Relocation is NOT available.
SPONSORSHIP IS NOT AVAILABLE.
What You Will Get -
Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.
Here you earn more than just a salary because we value your performance. We offer a total rewards package that provides benefits on day one (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus. Additional benefits include paid vacation days and paid holidays.
All qualified individuals - Including minorities, females, veterans, and individuals with disabilities - are encouraged to apply.
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 one hundred 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.
Posting Dates: October 17, 2024 - October 31, 2024 Any offer of employment is conditioned upon the successful completion of a drug screen.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.