01Overview
Career Area
Technology, Digital and Data
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.
Job Summary
Responsible for administering, maintaining, and optimizing Snowflake cloud data platform environments. Works alongside senior DBAs and data engineers to ensure availability, security, and performance of Snowflake databases across development, QA, and production tires.
What You Will Do
- Monitor and maintain Snowflake databases, schemas, warehouses, and account-level objects across multiple environments (DEV, QA, PROD).
- Manage role-based access control (RBAC): create/alter roles, grant database roles, and troubleshoot privilege issues.
- Perform object migrations between environments DDL deployments, grants replication, and semantic view promotions.
- Investigate and resolve query performance issues using Query Profile, ACCOUNT\_USAGE views, and warehouse metrics.
- Manage Snowflake tasks, streams, agile tables, and scheduled pipelines.
- Assist with Streamlit app deployments, Cortex AI feature enablement (semantic views, Cortex Analyst), and Native App support.
- Implement and maintain network policies, MFA enforcement, and key rotation procedures.
- Write and maintain migration scripts (GRANT statements, DDL changes, environment parity checks).
- Participate in on-call rotation for production incident response.
What You Have
Required Qualifications:
- 4+ years experience with Snowflake Data Warehouse.
- Working knowledge of SQL including stored procedures, UDFs, and DDL management.
- Familiarity with Snowflake .
