Data Engineer: Snowflake Pipelines & Analytics

Caterpillar Inc.; Mossville (IL); On-site; USD 89,000 - 134,000; Full time

Benefits offered by this job

Medical benefits

Paid time off

401(k)

HSA

Tuition reimbursement

Job summary

Caterpillar Inc. in Mossville, IL is seeking a Data Specialist to design, build, and maintain cloud-based data pipelines and analytical products. You will modernize legacy SAS processes to Snowflake, ensuring data quality, governance, and availability for procurement and supply chain decisions.

You will engage with stakeholders across the organization, translate business needs into scalable data solutions, and contribute to a robust data platform while adhering to agile development practices.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, Data Science, or a related discipline.
• Equivalent experience demonstrating strong technical capability will be considered.

Responsibilities

• Design, build, maintain, and support data pipelines, data transformations, and analytical data products using Snowflake, SQL, and modern development tools.
• Investigate data discrepancies, reporting inconsistencies, and production issues by tracing data through source systems, transformation logic, and downstream applications.
• Support efforts to establish trusted, standardized data definitions across Procurement and Supply Chain systems and platforms.
• Partner with Product Owners, Business Process Owners, Data Stewards, and Analytics teams to translate business needs into scalable technical solutions.
• Develop practical documentation describing data definitions, transformations, technical specifications, and lineage, while participating in Agile development and continuous improvement.

Skills

Data engineering

Cloud platforms

Agile

Education

BSc in CS/IS/Engineering/Data

Tools

Snowflake

SQL

Python

GitHub Copilot

VS Code

GitHub

Job description

Caterpillar Inc. in Mossville, IL is seeking a Data Specialist to design, build, and maintain cloud-based data pipelines and analytical products. You will modernize legacy SAS processes to Snowflake, ensuring data quality, governance, and availability for procurement and supply chain decisions.

You will engage with stakeholders across the organization, translate business needs into scalable data solutions, and contribute to a robust data platform while adhering to agile development practices.