Cat
Principal Data Engineer
Peoria, Illinois · Principal · Part-time
No sponsorship$128k-$209kDetected 8 hours ago
PythonData StructuresAlgorithmsGitSQLSnowflakeAWSCloud PlatformsCI/CDDevOpsMachine LearningData EngineeringData ScienceAgentic AIEHR/EMRCommunicationCollaborationMentoring
About the role
- Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc.
- What You Will Have: - Data Programming - BS in Computer Science, Computer Engineering, Data Engineering, Data Science, or related field.
- Understanding of data structures, algorithms, profiling & optimization. - Data Governance, Quality, & Security - Understanding and appreciation for the data governance standards, the dimensions of data quality, and data security.
Responsibilities
- Design, build, and maintain scalable Snowflake-based data platform supporting analytics, reporting, and AI/ML workloads
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing data pipelines for greater scalability
- Perform debugging, troubleshooting, modification and testing of integration solutions
- Create solutions and methods to monitor systems and solutions
- Review and optimize code. Automate code testing and pipelines
- Design, develop, and maintain efficient and scalable AI and ML solutions
- Put in place systems and processes to support data governance capabilities
- Engage with business partners to participate in design and development of data integration/transformation solutions per functional requirements
- Data Governance, Quality, & Security - Understanding and appreciation for the data governance standards, the dimensions of data quality, and data security. Familiarity with tools and frameworks to support these standards.
- Database/Data Lake Administration - Experience managing a Snowflake database/environment. Understanding of SQL, ETL/ELT design, data modeling techniques, change data capture techniques. Familiarity with indexing, partitioning, and query optimization.
Requirements
- 5+ years development experience with modern development languages and frameworks, preferably Python, SQL, etc.
- Experience managing a Snowflake database/environment.
- Familiarity with indexing, partitioning, and query optimization.
- Experience with version control in Github and devops practices, like continuous integration and continuous delivery (CI/CD)
- Ability to communicate difficult or technical concepts in a relatable manner.
- Experience in agent assisted programming.
- Deep Snowflake expertise including Cortex, Snowpipe, Snowpark, Snowsight, etc.
Compensation
- $128,470.00 - $208,770.00
- Please note that salary is only one component of total compensation at Caterpillar.
- Compensation and benefits offered may vary depending on multiple individualized factors, job level, market location, job-related knowledge, skills, individual performance and experience.
- Summary Pay Range:
Benefits
- This is a summary list of benefits.
- Medical, dental, and vision benefits*
- Paid time off plan (Vacation, Holidays, Volunteer, etc.)*
- Health Savings Account (HSA)*
- Flexible Spending Accounts (FSAs)*
- Health Lifestyle Programs*
- Voluntary Benefits and Employee Discounts*
- Incentive bonus*
- Disability benefits
Company info
- 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.
- This position will be responsible for building scalable, high performance data pipelines and data driven predictive analytics applications using automation, artificial intelligence (AI) and machine learning (ML) models to provide actionable recommendations and insights.
- The position will be part of Caterpillar's Legal, Security and Public Policy team, tackling challenges and problems that are critical to realizing business value and mitigating high impact enterprise risks.
- This position will work with data scientists, business analysts, and others as part of a team that assembles large, complex data sets, automates processes and pipelines, builds models and provides insight to key stakeholders.
- What Will Set You Apart:
Equal opportunity
- Equal Opportunity Employer, Including Veterans and Individuals with Disabilities.
Visa & Work Authorization
- Visa Sponsorship is not available for this position.
This listing is sourced directly from Cat's careers page and normalized into a canonical job model.