Senior Data Engineer, Cat Digital

Caterpillar•Chicago, IL

1d•Onsite

About The Position

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. This position on the Marketing Data & Engineering team will support the implementation of data products. The Marketing Data & Engineering team supports Cat Digital’s overall marketing efforts having responsibility for data pipelines and products used to reach our customers where they are in their journey. This position will be focused around the Digital Intelligence Warehouse. This collection of data and data objects are the foundation for marketing decisions across the enterprise. You will not only be expected to work across multiple cloud database technologies but collaboration with various business & technical teams will be vital. Ideal candidates will have a proven track record of progressive technical responsibility, demonstrated communication skills, and comfort with a rapid-paced environment.

Requirements

Decision Making and Critical Thinking: Knowledge of the decision-making process and associated tools and techniques; ability to accurately analyze situations and reach productive decisions based on informed judgment.
Effective Communications: Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
Software Development: Knowledge of software development tools and activities; ability to produce software products or systems in line with product requirements.
Software Integration Engineering: Knowledge of software integration processes and functions; ability to design, develop and maintain interfaces and linkage to alternative platforms and software packages.
Data Pipeline Engineering: Extensive knowledge of building and supporting cloud‑based data pipelines; understanding of ingestion, transformation, and orchestration patterns.
Cloud Database Proficiency: Working knowledge of cloud database technologies; ability to apply best practices for performance and scalability.
Progressive Technical Ownership: Demonstrated progression in technical capabilities and responsibility; ability to execute tasks autonomously while seeking guidance when needed.

Nice To Haves

Experience with web tracking, social, and ad platform data sets
Working knowledge of SQL & Python
Experience with web based ETL and/or Reverse ETL technologies
Experience with Microsoft productivity tools
Familiarity with Google Cloud and AWS capabilities
Experience with BigQuery and/or Snowflake

Responsibilities

Build data ingestion pipelines using approved patterns
Implement and document standardized data models
Build and document data pipelines required to support those models
Work with multiple international teams for overall success of shared goals
Execute proofs of concept as needed to prove out solutions
Regularly report on initiative status to peers and leadership
Standard administration tasks like time reporting, accomplishing training requirements, and task tracking via Azure DevOps