Data Engineer: Snowflake, SQL & Analytics

Caterpillar; Mossville (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

Caterpillar is seeking a Data Specialist within the SPPD Digital team to design, build, and maintain analytical data products and pipelines using Snowflake, SQL, and Python. You will modernize legacy SAS-based processes into scalable Snowflake solutions while collaborating with stakeholders to enable data-driven procurement and supply chain decisions.

You'll work across data engineering, investigation, quality, and governance, partnering with Product Owners and Analytics teams to deliver

Qualifications

• Design, build, maintain data pipelines and analytical data products using Snowflake, SQL, and modern development tools.
• Modernize legacy SAS-based processes into scalable Snowflake-based data solutions.
• Develop reliable, repeatable data products that support Procurement and Supply Chain decisions.

Responsibilities

• Design, build, maintain, and support data pipelines, data transformations, and analytical data products using Snowflake, SQL, and modern development tools.
• Support the modernization of legacy SAS-based processes into scalable Snowflake-based data solutions.
• Develop reliable, repeatable, and well-documented data products that support Procurement and Supply Chain decision-making.
• Follow established coding standards, version control practices, and development workflows utilizing tools such as GitHub, VS Code, and GitHub Copilot.
• Contribute to cloud-based data architecture initiatives that improve data accessibility, maintainability, and performance.

Skills

Data engineering

Snowflake

SQL

Python

GitHub

VS Code

GitHub Copilot

Tools

Snowflake

SAS

GitHub

VS Code

Job description

Caterpillar is seeking a Data Specialist within the SPPD Digital team to design, build, and maintain analytical data products and pipelines using Snowflake, SQL, and Python. You will modernize legacy SAS-based processes into scalable Snowflake solutions while collaborating with stakeholders to enable data-driven procurement and supply chain decisions.

You'll work across data engineering, investigation, quality, and governance, partnering with Product Owners and Analytics teams to deliver