Senior Data Architect & ETL Solutions Lead

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

Benefits offered by this job

Medical, dental, and vision benefits

Paid time off (vacation, holidays)

401(k) savings plan

Health Savings Account (HSA)

Flexible Spending Accounts (FSAs)

Career development

Job summary

Caterpillar Inc. seeks a Senior Data Specialist at its Chicago, IL facility. The role emphasizes data design, data quality, metadata management, data governance, and data architecture, with 25% of time on these duties.

You will develop data pipelines, document data models, and design scalable ETL solutions. You will work on complex problems aligned with Cat Digital, with telecommuting one day per week.

Qualifications

• Master’s degree or foreign equivalent in CS/CE/EE or related field with 3 years of software experience OR Bachelor’s degree with 5 years of experience.
• Experience with data design, data quality, metadata management, data governance or data architecture.
• Strong experience with AWS tools and data engineering practices.

Responsibilities

• Design robust data pipelines including ETL/ELT processes.
• Document data models for domains and canonical formats.
• Develop and maintain data objects with mapping and business rules.
• Tackle complex data problems aligned with Cat Digital objectives.
• Collaborate to ensure scalable, high-quality data infrastructure.

Skills

Data governance

Data architecture

Data quality

Metadata management

Data design

Education

Master's degree in Computer Science or related field

Bachelor's degree in Computer Science or related field

Tools

AWS CloudWatch

AWS Lambda

AWS SQS

AWS SNS

AWS S3

DynamoDB

RDS

SQL

Python

Apigee

Job description

Caterpillar Inc. seeks a Senior Data Specialist at its Chicago, IL facility. The role emphasizes data design, data quality, metadata management, data governance, and data architecture, with 25% of time on these duties.

You will develop data pipelines, document data models, and design scalable ETL solutions. You will work on complex problems aligned with Cat Digital, with telecommuting one day per week.