Data Engineer - Technical/User support

Leírás

Career Area:

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.

The Role:

• This role is responsible for designing, building, and operating scalable data solutions that enable reliable analytics and insight across the business. The role focuses on developing robust data pipelines, integrating data from multiple sources, and creating data models that support reporting and advanced analysis. Working closely with data scientists, analysts, and business stakeholders, the role ensures data is accurate, well‑governed, and performant, enabling teams to make confident, data‑driven decisions at scale.

What You will Do:

• Build and manage ETL (Extract, Transform, Load) pipelines to move data from source systems (like databases, APIs, or logs) to data warehouses or lakes.
• Design scalable data models and storage solutions that support analytics and reporting needs.
• Integrate data from various internal and external sources, ensuring consistency and reliability.
• Tune queries and systems for performance, especially when dealing with large datasets.
• Implement checks to ensure data accuracy, completeness, and compliance with data governance policies.
• Work closely with data scientists, analysts, and business stakeholders to understand data needs and deliver solutions.
• Support with debug and analyze data issues raised from user queries and provide timely Root Cause Analyses (RCAs) within defined SLAs.
• Collaborate with the Data Engineering team to assess, design, and implement new scope or evolving business requirements.
• Communicate issue status, impact, and resolution clearly to stakeholders and end users.

Core Skills Required:

• Value Realization: Knowledge of value realization methods; ability to plan, execute, monitor and manage business activities and resources to determine and achieve the actual value from a business initiative as estimated in an associated business case.
• Communicating Complex Concepts: Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple, clear language appropriate to the audience.
• Agile Development: Knowledge of agile methodologies and the agile development lifecycle; ability to utilize formal agile methodologies, disciplines, practices and techniques for the delivery of new and enhanced applications.
• Cloud Computing: Knowledge of cloud-based solutions and their applications; ability to design, implement, and manage cloud-based solutions to meet business needs and improve operational efficiency.
• Database Design (Physical): Knowledge of database systems; ability to establish a data model for designing an organization's database that runs effectively and efficiently for better business outcome.
• ETL Process: Knowledge of the extraction, transformation and loading (ETL) process; ability to develop a database through the ETL process.
• Information Management: Knowledge of an organization's existing and planned Information Architecture and Information Management (IM) methodology; ability to collect and manage information from different sources, and distribute this information to enhance operational efficiency.
• Modeling: Data, Process, Events, Objects: Knowledge of data, process and events; ability to use tools and techniques for analyzing and documenting logical relationships among data, processes or events.

What a Top Candidate Brings to the Role:

• Strong hands‑on expertise in SQL and Python, using them to build, optimize, and support reliable data pipelines and analytical solutions.
• Proven experience working with modern data platforms and ETL tools such as Snowflake or equivalent technologies to deliver scalable, production‑ready data solutions.
• Deep understanding of relational and cloud‑native databases, including PostgreSQL, MySQL, Snowflake, and BigQuery, with the ability to design efficient data models for analytics.
• Practical experience operating in AWS environments, leveraging services such as Glue, Lambda, and Step Functions to orchestrate and automate data workflows.
• Strong problem‑solving and analytical capability, able to diagnose complex data issues and design clear, effective solutions.
• Solid understanding of distributed systems and data architecture, enabling the design of resilient, high‑performance data platforms.
• A clear appreciation of data privacy, security, and governance best practices, ensuring data solutions meet compliance and enterprise standards.

Additional Info:

• This position can be based in Peoria, IL, or Irving, TX
• Domestic relocation assistance is available for those who qualify
• Sponsorship is not available for all type of visa
• International and Domestic travel up to 5%

Summary Pay Range:

Compensation 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:

Any offer of employment is conditioned upon the successful completion of a drug screen.

Caterpillar is an Equal Opportunity Employer, Including Veterans and Individuals with Disabilities. Qualified applicants of any age are encouraged to apply.

Not ready to apply? Join our Talent Community.