Lead Data Engineer (Snowflake)

• Design and build scalable data ingestion pipelines from structured and unstructured data sources into Snowflake.
• Develop and maintain ELT/ETL processes to transform cleanse and integrate enterprise data.
• Design reusable dimensional semantic and business-ready data models that support analytics and AI use cases.
• Build and maintain consumable data products including curated datasets data marts semantic layers APIs and AI-ready data assets.
• Design and implement enterprise data architectures that support scalability interoperability and future AI adoption.

• Design and curate AI-ready datasets that support machine learning generative AI intelligent agents and advanced analytics.
• Implement metadata lineage and semantic modeling capabilities that improve data discoverability and AI readiness.
• Collaborate with AI and analytics teams to establish patterns for retrieval search knowledge management and AI-enabled business solutions.
• Evaluate and adopt emerging Snowflake capabilities including Cortex AI semantic models vectorized data structures and AI-related platform services.

• Apply Data Product Management principles by establishing ownership quality standards service levels and lifecycle management processes.
• Implement data quality monitoring automated validation observability and governance frameworks.
• Ensure compliance with enterprise security privacy regulatory and data governance requirements.
• Establish and maintain metadata standards data lineage business definitions and cataloging practices.

• Optimize Snowflake performance through query tuning workload management storage optimization and architectural improvements.
• Ensure high availability reliability and scalability across data platforms and pipelines. Implementing proactive monitoring alerting and observability practices.
• Drive cloud and Snowflake cost optimization through consumption monitoring capacity planning and engineering best practices.

• Lead and mentor a team of 3-4 data engineers providing technical leadership coaching and career development.
• Serve as the technical subject matter expert for Snowflake modern data platforms and AI-ready data engineering practices.
• Define and enforce enterprise data engineering standards architectural patterns and development best practices.
• Collaborate with business stakeholders product owners analysts architects and data scientists to translate business objectives into scalable data solutions.

• Bachelor's degree in computer science Information Systems Data Engineering Software Engineering or related technical field (or equivalent experience)
• 10+ years of experience in data engineering or related disciplines with increasing responsibility
• Expert knowledge of Snowflake architecture security performance tuning and workload management.
• Strong SQL data modeling and data architecture skills.
• Experience building enterprise-scale ELT/ETL pipelines and data integration solutions.
• Experience with cloud platforms (AWS Azure or GCP).
• Proficiency in Python Java Scala or similar modern programming languages.

• SnowPro Core or Advanced Snowflake certifications.
• Experience designing enterprise-scale Snowflake architectures.
• Experience supporting machine learning generative AI or agentic AI solutions through enterprise data platforms.
• Familiarity with Snowflake Cortex AI semantic models vector search and AI-ready data architecture.
• Experience working with structured and unstructured data sources at scale.
• Experience designing data products and supporting analytics consumption patterns.
• Experience implementing data governance metadata lineage and quality frameworks.
• Knowledge of CI/CD DevOps Infrastructure as Code (IaC) and platform automation practices.
• Strong communication skills with the ability to translate technical concepts into business value.

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

• The location for this position is East Peoria IL or Irving TX.
• Domestic relocation is NOT available.
• This role requires 5 days onsite.
• SPONSORSHIP IS NOT AVAILABLE.

• Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.
• Here you earn more than just a salary because we value your performance. We offer a total rewards package that provides benefits on day one (medical dental vision RX and 401K) along with the potential of an annual bonus. Added benefits include paid vacation days and paid holidays.
• All qualified individuals - Including minorities females veterans and individuals with disabilities - are encouraged to apply.

• 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

What We Do

Cat Digital is the digital and technology arm of Caterpillar Inc. responsible for bringing digital capabilities to our world-famous yellow iron. With over 1.5M connected assets worldwide our teams use data technology advanced analytics and AI capabilities to help our customers build a better world.

Why Work With Us

The Cat Digital team is at the forefront of Caterpillar’s evolution. We take pride in solving complex problems by building new systems from the ground up. On our team you’ll leverage data from across our entire enterprise to find solutions that open a new world of possibilities for our customers and dealers. Join us in building a better tomorrow.

Gallery