Senior Data Specialist: ETL, Data Governance & Architecture

Caterpillar Brazil; Chicago (IL); On-site; USD 160,555 - 169,060; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) with company match

Paid time off

Job summary

Caterpillar Inc. in Chicago, IL is seeking a Senior Data Specialist to design data pipelines, govern data quality, and model data domains. You will develop ETL solutions and document data models to support Cat Digital initiatives, balancing performance and accuracy across complex datasets.

The role requires advanced degrees with 3–5 years of related experience, strong AWS knowledge, and collaboration across teams to implement scalable data architectures in a dynamic environment.

Qualifications

• Master’s or accredited bachelor with 5+ years in software engineering or related field.
• Experience with computer architecture and software infrastructure.
• Proficiency with AWS tooling and cloud services listed above.
• Experience with API and scripting tools such as PowerShell, SQL, JSON, Python, Apigee or Postman.
• Knowledge of data cleansing, conformance, and correlation of transactional data.

Responsibilities

• Design data object pipelines with field-level mappings and business rules.
• Develop and document data models including logical data models and canonical formats.
• Build robust ETL solutions and scalable data extraction processes.
• Address complex data problems aligning with Cat Digital objectives.
• Work one day per week remotely as described.

Skills

Data design

Data governance

Data quality

Metadata management

Data architecture

ETL design

Python

SQL

APIs

Education

Master’s degree in Computer Science / Computer Engineering / Electrical Engineering / Electronics Engineering or related field

Bachelor’s degree in Computer Science / Computer Engineering / Electrical Engineering / Electronics Engineering or related field

Tools

AWS CloudWatch

AWS Lambda

AWS SQS

AWS SNS

AWS S3

DynamoDB

RDS

PowerShell

JSON

Apigee

Postman

VPC

CloudFormation

EC2

IAM

EBS

ECS

Data cleansing

Job description

Caterpillar Inc. in Chicago, IL is seeking a Senior Data Specialist to design data pipelines, govern data quality, and model data domains. You will develop ETL solutions and document data models to support Cat Digital initiatives, balancing performance and accuracy across complex datasets.

The role requires advanced degrees with 3–5 years of related experience, strong AWS knowledge, and collaboration across teams to implement scalable data architectures in a dynamic environment.