Application & Data Systems Analyst

Caterpillar; Peoria (IL); On-site; USD 113,000 - 183,000; Full time

Benefits offered by this job

Benefits package

Paid time off

401(k) plan

Bonus eligibility

Job summary

Caterpillar is seeking an Applications & Data Systems Analyst in Peoria, IL. You will develop and support enterprise data solutions, focusing on SQL Server, data pipelines, and security controls.

You will collaborate with vendors and business partners, monitor production systems, and ensure data quality, governance, and reliable reporting for Legal, Security & Public Policy teams. Five onsite days are expected.

Qualifications

• Expert-level SQL Server experience in enterprise environments.
• Experience with data solutions, reporting, and data pipelines.
• Knowledge of least-privilege access and data governance.

Responsibilities

• Develops, configures, tests, implements, and supports enterprise application and data solutions.
• Designs and optimizes SQL Server solutions, queries, and performance tuning.
• Monitors production systems and conducts root-cause analysis with vendors.
• Documents configurations, data flows, and security controls to improve reliability.

Skills

Microsoft SQL Server

SQL development

Query optimization

Data governance

Troubleshooting

Security controls

Automation

Vendor coordination

Documentation

System monitoring

Education

Bachelor’s degree in a relevant field

Job description

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, escrow 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.