Application & Data Systems Analyst

Posted 6 Hours Ago
Be an Early Applicant
Peoria, IL, USA
Hybrid
113K-183K Annually
Mid level
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Cat Digital delivers digital and technology solutions that power Caterpillar's world-famous yellow iron.
The Role
Develops, configures, tests, implements, and supports enterprise applications and data solutions. Designs and optimizes complex SQL Server solutions, manages integrations and data pipelines, monitors production systems, investigates root causes, improves data quality, and documents technical processes. Handles privileged access and sensitive data under security and governance controls while coordinating issue resolution with vendors and business teams. Provides after-hours support for critical production incidents when required.
Summary Generated by Built In
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.
Application & Data Systems Analyst
Provides hands-on development, configuration, testing, implementation, and production support for application and data solutions used by Legal, Security & Public Policy. Works directly with databases, reporting, integrations, data pipelines, application security, business rules, and system triggers.
Investigates how systems behave, resolves technical issues, documents system details, and improves data quality, workflows, reporting, and automation in partnership with vendors and business teams.
What You Will Do:
  • Develops, configures, tests, implements, and supports enterprise application and data solutions, including routine enhancements, fixes, and technical maintenance.
  • Designs, develops, optimizes, and supports complex Microsoft SQL Server solutions, including advanced SQL queries, stored procedures, views, functions, and triggers; analyzes execution plans, tunes indexing and query performance, and resolves complex database issues affecting production applications. Configures and supports integrations, data pipelines, reports, business rules, and system triggers; monitors, validates, maintains, and improves data quality to support reliable operations and business needs.
  • Monitors production systems, investigates unexpected behavior, traces issues across connected components, performs root-cause analysis, and works with vendors and business partners through resolution.
  • Documents configurations, application behavior, data flows, dependencies, support procedures, and technical changes; uses that knowledge to improve reliability, reporting, workflows, and automation. Handles privileged access and sensitive data in accordance with least-privilege principles, access-review and audit requirements, security controls, and data-governance standards. Records privileged changes so administrative activity is traceable and promptly escalates suspected security or data incidents.

What You Have:
  • Expert-level, hands-on Microsoft SQL Server experience developing and troubleshooting complex SQL queries, stored procedures, views, functions, and triggers in enterprise production environments. Demonstrated expertise in execution-plan analysis, indexing strategies, query optimization, transaction management, and diagnosing blocking, deadlocks, and data-integrity issues. Demonstrated hands-on experience supporting enterprise production applications and data solutions, including reporting, integrations, data pipelines, application security, business rules, and system triggers.
  • Experience working with administrative-level system access and confidential or sensitive business data, with consistent adherence to least-privilege access, access governance, auditability, data-handling requirements, and appropriate discretion.
  • Strong technical curiosity and persistence in understanding system behavior, tracing complex issues, testing changes, and documenting findings.
  • Ability to work independently, exercise sound judgment within established controls, manage detailed technical work through completion, and coordinate effectively with vendors and business partners when needed.
  • Experience using approved automation and AI-enabled capabilities to improve support, data quality, reporting, and efficiency is preferred.

Skills Descriptors:
Core Application Systems:
  • Working knowledge of enterprise production applications and the underlying data, integrations, security, business logic, configurations, and dependencies needed to support them reliably. Expert-level proficiency in Microsoft SQL Server, including relational data modeling, advanced SQL development, execution-plan analysis, indexing and performance tuning, transaction handling, and independent resolution of complex production database issues.

Problem Solving:
  • Knowledge of structured problem-solving approaches, tools, and techniques; ability to analyze application, data, database, integration, reporting, and production issues, identify root causes, assess business impact, and implement sustainable solutions.

Application Configuration and Design:
  • Knowledge of application configuration and solution design; ability to understand existing system behavior, translate clear requirements into maintainable technical changes, assess impacts to data, security, reporting, integrations, and production support, and follow controlled change and release practices.

Requirements Analysis:
  • Ability to ask detailed questions, clarify expected system behavior, identify data and reporting needs, document current and desired processes, and convert requirements into specific technical tasks and testable outcomes.

System Testing:
  • Knowledge of system, integration, data, and software testing; ability to develop and execute test strategies for functional changes, validate data integrity, confirm security and regression results, and assess production readiness, including rollback and recovery planning.

Technical Troubleshooting:
  • Knowledge of monitoring, troubleshooting, and root-cause analysis; ability to independently resolve production issues, assess business and data impact, escalate suspected security incidents, and coordinate sustainable solutions with vendors and business partners. Provides after-hours support for critical production issues when required.

Additional Information:
  • This role is in Peoria, IL.
  • SPONSORSHIP IS NOT AVAILABLE FOR THIS ROLE.
  • This role requires 5 days onsite.
  • No relocation is available for this role.

Education / Experience: Bachelor's degree in a relevant field or equivalent experience, plus at least three years of hands-on experience supporting enterprise applications, data solutions, or similarly complex production systems.
What You Will Get:
  • Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.
  • Here you earn more than just a salary because we value your performance. We offer a total rewards package that provides benefits on day one (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus. Additional benefits include paid vacation days and paid holidays.
  • All qualified individuals - Including minorities, females, veterans, and individuals with disabilities - are encouraged to apply.

About Caterpillar -
Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives. For nearly 100 years, we've been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.
Summary Pay Range:
$112,710.00 - $183,140.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
Posting Dates:
October 19, 2026 - October 29, 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.

Skills Required

  • Bachelor's degree in a relevant field or equivalent experience
  • At least three years of hands-on experience supporting enterprise applications, data solutions, or similarly complex production systems
  • Expert-level hands-on Microsoft SQL Server experience, including advanced SQL queries, stored procedures, views, functions, triggers, execution-plan analysis, indexing, performance tuning, transaction management, and production issue diagnosis
  • Hands-on experience supporting enterprise production applications and data solutions, including reporting, integrations, data pipelines, application security, business rules, and system triggers
  • Experience with administrative-level system access and confidential or sensitive business data, including least-privilege access, access governance, auditability, and data-handling requirements
  • Strong technical curiosity and persistence in troubleshooting system behavior, tracing complex issues, testing changes, and documenting findings
  • Ability to work independently, exercise sound judgment, manage detailed technical work through completion, and coordinate with vendors and business partners
  • Experience using approved automation and AI-enabled capabilities to improve support, data quality, reporting, and efficiency
  • Ability to work five days onsite in Peoria, Illinois

What the Team is Saying

Pradeep
Christina
Chad
Madison
Rakshan
MacGregor
Stan

Caterpillar Compensation & Benefits Highlights

  • Retirement Support — Retirement plans are highlighted as a standout element, with a strong company match and an additional company contribution noted for certain groups. Feedback suggests this is a notable strength of the package, with specifics dependent on plan and eligibility.
  • Healthcare Strength — Health coverage is described as comprehensive, spanning medical, dental, vision, HSAs/FSAs, wellness resources, and mental-health support through the EAP. Feedback suggests these offerings are competitive and broadly well regarded.
  • Parental & Family Support — Paid parental leave and adoption assistance are explicitly included, with adoption reimbursement and supportive leave policies emphasized. Feedback suggests family support is generous and a meaningful part of total rewards.

Caterpillar Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Irving, TX
100,000 Employees
Year Founded: 1925

What We Do

Cat Digital is the digital and technology arm of Caterpillar Inc., responsible for bringing digital capabilities to our world-famous yellow iron. With over 1.5M connected assets worldwide, our teams use data, technology, advanced analytics and AI capabilities to help solve our customers' toughest challenges.

Why Work With Us

At Cat Digital, we're accelerating Caterpillar's digital transformation to help customers solve their toughest challenges. Our teams use enterprise-wide data, emerging technologies, and customer insights to deliver solutions that drive real-world impact. Join us as we create innovative experiences that help customers succeed and power the world aro

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Caterpillar Teams

Team
Caterpillar
Team
Career Growth
About our Teams

Caterpillar Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
HQIrving, TX
India
Broomfield, CO
Chennai, IN
Chicago, IL
Geneva, CH
Košice, SK
Peoria, IL
Learn more

Similar Jobs

Caterpillar Logo Caterpillar

Project Manager

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Hybrid
Chicago, IL, USA
100000 Employees
128K-193K Annually

Caterpillar Logo Caterpillar

Digital Operations Support Analyst - Cat Customer Support

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Remote or Hybrid
Illinois, USA
100000 Employees
98K-146K Annually

Caterpillar Logo Caterpillar

Intelligent Automation COE Lead

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Hybrid
Peoria, IL, USA
100000 Employees
128K-209K Annually

Caterpillar Logo Caterpillar

Product Owner

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Hybrid
Chicago, IL, USA
100000 Employees
98K-158K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account