Application & Data Systems Analyst

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