Data Specialist

Caterpillar Inc.•Chicago, IL

1d•$97,530 - $146,290

About The Position

As a Data Specialist at Caterpillar, you will help build the data foundation for programs across Cat Digital. You will partner with business and engineering teams to turn complex data challenges into scalable models that connect information, enable trusted insights, and support business decisions. The role involves designing and maintaining data models, aligning stakeholders on definitions and standards, supporting implementation across data platforms, and ensuring models remain accurate, efficient, documented, and usable.

Requirements

Knowledge of effective presentation tools and techniques, including the ability to summarize and explain complex technical concepts clearly for different audiences.
Knowledge of agile methodologies and the agile development lifecycle, and ability to apply agile practices to deliver new and enhanced applications.
Knowledge of cloud-based solutions and their applications, and ability to design, implement, and manage solutions to meet business needs and improve operational efficiency.
Knowledge of database systems and ability to establish effective, efficient database models.
Knowledge of extraction, transformation, and loading (ETL) processes and ability to develop a database through ETL.
Knowledge of data, processes, and events, and ability to use tools and techniques to analyze and document logical relationships among them.

Nice To Haves

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 experience is highly desired.

Responsibilities

Design and maintain conceptual, logical, and physical data models for 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, and assess the impact of changes across dependent systems.