Application & Data Systems Analyst

Caterpillar•Peoria, IL

2d•$112,710 - $183,140•Onsite

About The Position

The 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. The role works with databases, reporting, integrations, data pipelines, application security, business rules, and system triggers. It investigates system behavior, resolves technical issues, documents system details, and improves data quality, workflows, reporting, and automation in partnership with vendors and business teams. The position is based in Peoria, Illinois, requires five days onsite, and provides after-hours support for critical production issues when required. Sponsorship and relocation are not available. The analyst develops and supports enterprise application and data solutions, including enhancements, fixes, and technical maintenance. The role requires expert-level Microsoft SQL Server skills, including complex SQL development, execution-plan analysis, indexing and query tuning, transaction management, and diagnosing production database issues. It also involves production monitoring, root-cause analysis, documentation, controlled changes and testing, data governance, and appropriately handling privileged access and sensitive information. A bachelor’s degree in a relevant field or equivalent experience is required, along with at least three years of hands-on experience supporting enterprise applications, data solutions, or similarly complex production systems. Caterpillar offers a total rewards package with benefits beginning on day one, subject to eligibility and plan terms. The stated summary pay range is $112,710 to $183,140.

Requirements

Expert-level, hands-on Microsoft SQL Server experience developing and troubleshooting complex 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.
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, and consistent adherence to least-privilege access, access governance, auditability, data-handling requirements, and 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.
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.
Ability to work onsite five days per week in Peoria, Illinois.

Nice To Haves

Experience using approved automation and AI-enabled capabilities to improve support, data quality, reporting, and efficiency.

Responsibilities

Develop, configure, test, implement, and support enterprise application and data solutions, including routine enhancements, fixes, and technical maintenance.
Design, develop, optimize, and support Microsoft SQL Server solutions, including advanced queries, stored procedures, views, functions, and triggers; analyze execution plans, tune indexes and query performance, and resolve complex production database issues.
Configure and support integrations, data pipelines, reports, business rules, and system triggers; monitor, validate, maintain, and improve data quality.
Monitor production systems, investigate unexpected behavior, trace issues across connected components, perform root-cause analysis, and work with vendors and business partners to resolve issues.
Document configurations, application behavior, data flows, dependencies, support procedures, and technical changes; use this knowledge to improve reliability, reporting, workflows, and automation.
Handle privileged access and sensitive data in accordance with least-privilege principles, access-review and audit requirements, security controls, and data-governance standards.
Record privileged changes to make administrative activity traceable and promptly escalate suspected security or data incidents.
Develop and execute testing for functional changes, validate data integrity, confirm security and regression results, and assess production readiness, including rollback and recovery planning.
Provide after-hours support for critical production issues when required.