Snowflake Database Administrator

Caterpillar - Nashville, TN

Full-time - Mid Level

Nashville, TN

Machinery Manufacturing

About the position

As a Snowflake Database Administrator at Caterpillar, you will be responsible for ensuring the integrity, security, and performance of the Snowflake data platform that supports various business units. This role involves collaboration with data governance teams and stakeholders to provide effective data solutions, manage data processes, and maintain best practices in data management.

Responsibilities

• Manage and monitor the Snowflake platform, including data ingestion, transformation, quality, security, and access.
• Apply principles and policies agreed with the Business Governance team regarding data source ingestion and access management.
• Implement and enforce best practices for data modeling, architecture, governance, and lifecycle management.
• Troubleshoot and resolve issues related to the Snowflake platform, providing root cause analysis and recommendations.
• Provide technical support and guidance to data users, ensuring appropriate access and permissions.
• Review and approve code changes as part of the CI/CD process.
• Maintain and update the CI/CD Python package as required.
• Collaborate with Enterprise Data Lakes to ensure efficient data flows.
• Stay updated on developments in Snowflake and other data technologies, recommending new features or tools.
• Lead actions to maintain IT systems infrastructure for efficient business operations.
• Guide design solutions to align current systems with best practices and compliance requirements.
• Execute middleware application server and automated workflow tools, working with server virtualization technologies.
• Administer updates, upgrades, and maintenance tasks in hardware and software areas.

Requirements

• Bachelor's degree in computer science, Information Systems, or a related field, or equivalent work experience.
• At least 3 years of experience as a Snowflake Database Administrator or similar role in data management.
• Strong knowledge and skills in Snowflake, including data ingestion, transformation, security, access, and optimization.
• Experience with data governance and quality frameworks and tools.
• Experience with SQL and scripting languages such as Python, JavaScript, Shell, or PowerShell.
• Excellent communication, collaboration, and critical thinking skills.
• Ability to work independently and as part of a team in a fast-paced environment.
• Certification in Snowflake or other data technologies is a plus.

Nice-to-haves

• Certification in Snowflake or other data technologies.

Benefits

• Medical, dental, vision, and RX benefits from day one.
• 401K retirement plan.
• Potential for an annual bonus.
• Paid vacation days and paid holidays (prorated based on hire date).