Data Specialist

Caterpillar Inc.; Chicago (IL); On-site; USD 98,000 - 146,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) savings

Health Savings Account (HSA)

Flexible Spending Accounts (FSAs)

Career Development

Incentive bonus

Parental leave

Tuition Reimbursement

Employee Discounts

Life Insurance

Disability benefits

Job summary

Caterpillar Inc. in Chicago is seeking a Data Specialist to help shape the data foundation behind a range of Cat Digital programs. You will partner with business and engineering teams to turn complex data challenges into scalable models that enable trusted insights and support better business decisions.

The role covers designing data models, collaborating with data engineers, defining data entities and standards, and ensuring data quality, lineage, and performance across platforms.

Qualifications

• Experience designing complex data models across multiple programs.
• Strong knowledge of DDL and query optimization.
• Experience with relational and non-relational databases.
• Ability to analyze large data sets in transactional databases and warehouse environments.

Responsibilities

• Design and maintain data models across Cat Digital programs.
• Translate requirements into scalable data structures.
• Define data entities, definitions, and modeling standards.
• Collaborate with data engineers on pipelines and platforms.
• Validate data models to improve quality and performance.
• Document mappings and data lineage across systems.

Skills

Communicating Complex Concepts

Agile Development

Cloud Computing

Database Design (Logical & Physical)

ETL Process

Modeling (Data, Process, Events, 0b3)

Tools

Snowflake

Job description

Job Description

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.

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.

Career Area

Technology, Digital and Data

Job Summary

Help shape the data foundation behind a variety of programs across Cat Digital as a Data Specialist. Partner with business and engineering teams to turn complex data challenges into scalable models that connect information, enable trusted insights, and support better business decisions.

What You Will Do

• Design and maintain conceptual, logical, and physical data models supporting a variety of programs across Cat Digital.
• Partner with business stakeholders, architects, and engineering teams to translate program requirements into scalable data structures and relationships.
• Define consistent data entities, business definitions, and modeling standards to promote reuse and alignment across programs.
• Collaborate with data engineers to implement models across databases, data platforms, and integration pipelines.
• Validate and optimize data models to improve data quality, integrity, query performance, and usability.
• Maintain model documentation, source-to-target mappings, and data lineage while assessing the impact of changes across dependent systems.

What You Will Have

• Communicating Complex Concepts: Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple, clear language appropriate to the audience.
• Agile Development: Knowledge of agile methodologies and the agile development lifecycle; ability to utilize formal agile methodologies, disciplines, practices and techniques for the delivery of new and enhanced applications.
• Cloud Computing: Knowledge of cloud-based solutions and their applications; ability to design, implement, and manage cloud-based solutions to meet business needs and improve operational efficiency.
• Database Design (Logical & Physical): Knowledge of database systems; ability to establish a data model for designing an organization's database that runs effectively and efficiently for better business outcome.
• ETL Process: Knowledge of the extraction, transformation and loading (ETL) process; ability to develop a database through the ETL process.
• Modeling: Data, Process, Events, Objects: Knowledge of data, process and events; ability to use tools and techniques for analyzing and documenting logical relationships among data, processes or events.

Top Candidates Will Have

• Previous experience designing complex data models across multiple programs
• Deep knowledge of DDL and query optimization
• Deep knowledge of relational and non-relational databases
• Demonstrated ability to analyze large data sets using transactional databases and warehouse environments. (Snowflake highly desired)

Summary Pay Range

$97,530.00 - $146,290.00

Benefits

• Medical, dental, and vision benefits*
• Paid time off plan (Vacation, Holidays, Volunteer, etc.)*
• 401(k) savings plans*
• Health Savings Account (HSA)*
• Flexible Spending Accounts (FSAs)*
• Health Lifestyle Programs*
• Employee Assistance Program*
• Voluntary Benefits and Employee Discounts*
• Career Development*
• Incentive bonus*
• Disability benefits
• Life Insurance
• Parental leave
• Adoption benefits
• Tuition Reimbursement
• These benefits also apply to part-time employees

Visa Sponsorship is not available for this position.

Posting Dates

October 22, 2026 -

Any offer of employment is conditioned upon the successful completion of a drug screen.

Caterpillar is an Equal Opportunity Employer, Including Veterans and Individuals with Disabilities. Qualified applicants of any age are encouraged to apply.