Analytics Data Engineer, Cat Digital

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.

Cat Digital is the digital and technology arm of Caterpillar Inc., leveraging the latest technologies to build industry leading digital solutions for our customers and dealers. With over 1.5 million connected assets worldwide, our teams use data, technology, advanced analytics, telematics, and AI capabilities to help our customers build a better, more sustainable world.
 

Job Summary:
Join the Analytics Engineering team of Cat Digital and perform analytical tasks and initiatives on One Funnel and OneSite programs with a focus on development and support of data-driven business decisions.
 

What You Will Do:

• Design, develop, and maintain data pipelines and infrastructure using AWS Services, MWAA Airflow, Snowflake, GIT and Azure DevOps CD-CI pipelines.
• Work with other team members to ensure the performance, reliability, and scalability of our data systems
• Keep up to date with industry trends and best practices related to data engineering and related technologies
• Troubleshoot and debug issues with data pipelines and systems
• Write and maintain technical documentation for data engineering processes and systems

What You Will Have:

• Analytical Thinking: Working knowledge of techniques and tools that promote effective analysis; ability to determine the root cause of organizational problems and create alternative solutions that resolve these problems.
• Query and Database Access Tools: Working knowledge of data management systems; ability to use, support and access facilities for searching, extracting and formatting data for further use.
• Requirements Analysis: Working 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.
   

Considerations for Top Candidates:

• Bachelor's or master’s degree in Computer Science, Information Technology, or related field
• Working experience applying SQL and Python (NumPy, SciPy, pandas, etc.) programming to solve business challenges.
• Working knowledge with cloud technologies (AWS, MWAA Airflow, S3, EC2, etc.)
• Experience with CI/CD Pipelines (Azure DevOps, Git Actions, or equivalent)
• Experience with data structure (JSON, XML, or equivalent)
• Experience with automated testing (Regression tests)
• In-depth technical and problem-solving skills and evidence of continuous learning in the analytics field
• Working experience with version control / repositories such as GitHub
• Experience operating in an Agile environment
• Must demonstrate strong initiative, interpersonal skills, and the ability to communicate effectively.
• Excellent organizational skills, with the ability to manage multiple requests and priorities simultaneously.
   

Preferred Skills and Qualifications:

• Experience with Azure DevOps, AWS Cloud, Managed Warehouse for Apache Airflow (MWAA), Github, Snowflake/Snowpark pipelines, SQL, Python, AI/ML, Microsoft Office, Power App Tools, Power BI, and automation capabilities.
   

What You Will Get:

Working with a Fortune 100 leader, you can build your career on a global scale and take advantage of development opportunities with emerging technologies. We’ve created an inclusive environment for you to explore your passions, make an impact and do the work that really matters. Join Us.

Additional Information:

This position will be based out of either our Chicago, IL or Peoria, IL offices.

#LI

#BI (used to post on Built In Chicago)

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 inno