Caterpillar Logo

Caterpillar

Data Specialist

Posted 2 Hours Ago
Be an Early Applicant
Hybrid
Chicago, IL, USA
98K-146K Annually
Entry level
Hybrid
Chicago, IL, USA
98K-146K Annually
Entry level
Design and maintain conceptual, logical, and physical data models for Cat Digital programs. Translate business requirements into scalable data structures, define data entities and standards, collaborate with data engineers on implementation, and optimize models for quality, integrity, performance, and usability. Maintain documentation, source-to-target mappings, data lineage, and change-impact assessments across databases, data platforms, and integration pipelines.
The summary above was generated by AI
Career Area:
Technology, Digital and Data
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.
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
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.
  • 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.
Not ready to apply? Join our Talent Community.

Caterpillar Chicago, Illinois, USA Office

In the heart of Chicago's lively West Loop area, we have easy access to public transport, great bars and restaurants, and an awesome office roof deck.

Similar Jobs at Caterpillar

2 Hours Ago
Hybrid
Chicago, IL, USA
113K-183K Annually
Senior level
113K-183K Annually
Senior level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Lead analytics and applied AI initiatives using statistical and machine learning methods to solve business challenges and support sales and services growth. Partner with stakeholders to develop insights, models, and scalable digital solutions; mentor data scientists; research emerging techniques; and communicate findings to technical and non-technical audiences.
Top Skills: Artificial IntelligenceAWSData VisualizationGoogle Cloud PlatformMachine LearningAzureNumpyPandasPythonRScipySQLStatistical Modeling
2 Hours Ago
Hybrid
113K-183K Annually
Entry level
113K-183K Annually
Entry level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Administer and support SAP GRC Access Control and Process Control modules, including configuration, troubleshooting, access risk analysis, segregation-of-duties monitoring, workflow automation, synchronization, audits, and compliance reporting. The role improves GRC processes, supports users and deployments, conducts disaster recovery testing and upgrades, and maintains SOX and risk-management controls within SAP environments.
Top Skills: BrfplusMsmpSAPSap GrcSap Grc Access Control (Ac)Sap Grc Process Control (Pc)
2 Hours Ago
Hybrid
128K-209K Annually
Expert/Leader
128K-209K Annually
Expert/Leader
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Leads technical architecture for Caterpillar’s Scheduled Oil Service LIMS platform, guiding existing and new solutions, integrations, scalability, security, and performance. Translates business requirements into architecture blueprints, evaluates emerging technologies, and delivers cloud-native digital solutions. The role combines Java architecture and hands-on coding with enterprise AI, data integration, analytics, Agile SDLC, CI/CD, mentoring, and cross-functional collaboration.
Top Skills: Agentic AiAnalytics PlatformsAWSChatgptCi/CdClaudeEnterprise Data IntegrationGeminiHybrid CloudJavaLaboratory Information Management Systems (Lims)Microsoft CopilotPublic CloudTest Automation

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account