Application & Data Systems Analyst

Technology, Digital and Data

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.

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.

• 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.

• 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…