Senior Data Specialist

Caterpillar

Chicago (IL)

On-site

USD 160,555 - 169,060

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

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

Career Area:

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.

Company Website

Caterpillar Inc. seeks Senior Data Specialist at its facility located at 540 W Madison St, Floor 14, Chicago, IL 60661.

Data design, data quality, metadata management, data governance or data architecture (25% of time spent on these job duties). Develop data object pipeline specifications including detailed field level mapping, business rules, data quality rules, etc (25% of time spent on these job duties). Document data models for domains to be deployed including a logical data model, candidate source lists, and canonical formats (20% of time spent on these job duties). Design robust, scalable database and data extraction, transformation, and loading (ETL) solutions (15% of time spent on these job duties). Work directly on complex problems and provide solutions aligned with overall objectives of Cat Digital (15% of time spent on these job duties). Telecommuting: 1 day/week.

REQS: This position requires a master’s degree, or foreign equivalent, in Computer Science, Computer Engineering, Electrical Engineering, Electronics Engineering or a related field and 3 years of experience as a Software Engineer, Software Developer or related occupation. In the alternative will accept bachelor’s degree, or foreign equivalent, in Computer Science, Computer Engineering, Electrical Engineering, Electronics Engineering or a related field and 5 years of experience as a Software Engineer, Software Developer or related occupation.

Additionally, the applicant must have employment experience with:

(1) Computer Architecture and systems Software Infrastructure;
(2) AWS tools such as CloudWatch logging, Lambda service, Simple Queue Service (SQS), Simple Notification Service (SNS), Simple Storage Service (S3), DynamoDB / NoSQL, or Relational Database Service (RDS);
(3) API and scripting tools such as PowerShell, SQL, JSON, Python, Apigee, or Postman;
(4) Virtual Private Cloud (VPC), CloudFormation, Elastic Compute Cloud(EC2), Identity and Access Management (IAM), Elastic BlockStore (EBS), or Elastic Container Service (ECS);
(5) Data cleansing, conforming or correlation of transactional data sets.

Summary Pay Range:

$160,555.00 - $169,060.00 Per Year

Compensation and benefits offered may vary depending on multiple individualized factors, job level, market location, job-related knowledge, skills, individual performance and experience. Please note that salary is only one component of total compensation at Caterpillar.

Benefits:

Subject to plan eligibility, terms, and guidelines. This is a summary list of benefits.