> Markdown version of [/jobs/ext/3851120-application-data-systems-analyst](https://www.wearedevelopers.com/jobs/ext/3851120-application-data-systems-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Application & Data Systems Analyst - **Company:** Caterpillar - **Location:** Peoria, IL, United States - **Experience:** Experienced - **Salary:** $112,710.0 - $183,140.0 - **Contract:** Permanent contract - **Skills:** Testing (Software), Query Performance, Artificial Intelligence, Application Configuration Access Protocols, Business Logic, Audit Trail, Databases, Data Integrity, Data Systems, Relational Databases, Identity and Access Management, Microsoft SQL Server, Operational Databases, Performance Tuning, Query Optimization, SQL Stored Procedures, Data Streaming, System Testing, Systems Integration, Strategies of Testing, Freeform SQL, Enterprise Software Applications, Database Optimization, Software Security, Indexer, Data Management, Data Pipelines - **Published:** October 21, 2026 - **Apply:** https://www.techcareers.com/job.asp?id=3462146815&tx=JJ9185FFQ&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54 ## About the Role * 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., * 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., 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. ## Description 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.