Application & Data Systems Analyst

Caterpillar

Peoria (IL)

On-site

USD 113,000 - 183,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical benefits
Dental benefits
Vision benefits
401K plan
Annual bonus

Job summary

Caterpillar in Peoria, IL is hiring an Applications & Data Systems Analyst to deliver and support enterprise data solutions for Legal, Security & Public Policy. You will work with SQL Server, data pipelines, security controls, and reporting to ensure accurate, timely information and reliable operations.

Responsibilities include configuring, testing, implementing, and maintaining applications; performing root-cause analysis, documenting changes, and coordinating with vendors and business

Qualifications

  • Expert-level Microsoft SQL Server experience developing and troubleshooting complex SQL queries, stored procedures, views, functions, and triggers in enterprise environments.
  • Experience with execution-plan analysis, indexing strategies, and performance tuning.
  • Ability to support enterprise applications, data solutions, reporting, and security controls.

Responsibilities

  • Develops, configures, tests, implements, and supports enterprise application and data solutions.
  • Monitors and tunes SQL Server performance; analyzes execution plans and issues.
  • Documents configurations, data flows, security, and change procedures; coordinates with vendors and business partners.

Skills

SQL Server
Query optimization
Execution plans
Indexing
Data quality
Automation & AI

Education

Bachelor's degree in a relevant field

Tools

SQL Server tooling

Job description

## Application & Data Systems AnalystApply: Peoria, Illinois: Full time: Posted Today: R0000399424**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.00Compensation 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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Specialist
Lead Data Specialist

Caterpillar • Peoria (IL)

On-site
USD 128,000 - 193,000
Sales System Information Specialisit
Sales System Information Specialisit

Caterpillar Inc. • Peoria (IL)

On-site
USD 128,000 - 209,000
Medical, dental, and vision benefits
401(k) retirement plans
Health Savings Account (HSA)
+2
Software Development Engineer
Software Development Engineer

Caterpillar • Illinois

On-site
USD 98,000 - 146,000
Medical, dental, and vision benefits
Paid time off
401(k) saving plan
+1
Info Technology Analyst
Info Technology Analyst

Solar Turbines Incorporated • San Diego (CA)

On-site
USD 89,000 - 134,000
Medical, dental, and vision benefits
Paid time off
401(k) savings plans
+8
Lead Data Specialist
Lead Data Specialist

Caterpillar Inc. • Illinois

On-site
USD 128,000 - 193,000
Senior Product Consultant
Senior Product Consultant

Caterpillar Inc. • Denver (CO)

On-site
USD 128,000 - 193,000
Relocation assistance
Onsite work five days a week
Data Engineer
Data Engineer

Caterpillar • Chicago (IL)

On-site
USD 89,000 - 145,000
Medical benefits
Dental benefits
Vision benefits
+11
Autonomy Systems Engineering Specialist
Autonomy Systems Engineering Specialist

Caterpillar • Irving (TX)

On-site
USD 128,000 - 209,000
Medical, dental, and vision benefits
401(k) savings plans
Paid time off
Data Scientist
Data Scientist

Caterpillar • Peoria (IL)

On-site
USD 89,000 - 145,000
Relocation assistance
Career development
Onsite five days a week
Program Specialist
Program Specialist

Caterpillar Inc. • Illinois

On-site
USD 128,000 - 193,000