Role: Snowflake AdministrationThe Snowflake Administrator is responsible for monitoring, maintaining, and supporting the Snowflake data cloud platform. The role performs routine maintenance tasks and ensures system support, maintenance, administration, and process improvement for Snowflake components such as databases, data warehouses, and associated integrations. The role also carries out tasks required for setting up the Snowflake environment for installation, configuration, updates, and migration of data and applications.Primary Responsibilities
- Administer user accounts, roles, and permissions to ensure secure and efficient access to the environments.
- Design and maintain the structure of databases, schemas, and tables within Snowflake to ensure data is organized and accessible for various business needs.
- Set up and manage data sharing capabilities within Snowflake to facilitate secure data exchange between different departments or external partners.
- Continuously monitor the performance of the Snowflake environment, optimizing queries and workloads.
- Oversee the scheduling and execution of data loading and ELT processes to ensure data is accurately and efficiently ingested into Snowflake from various sources.
- Configure and manage Snowflake virtual warehouses to ensure optimal performance and cost efficiency, adjusting warehouse sizes, clusters and settings based on workload requirements.
- Implement and manage backup and restore procedures to ensure data integrity and availability, performing regular backups and testing restore processes to prepare for potential data loss scenarios.
- Enforce security policies and implement encryption mechanisms to protect sensitive data within Snowflake, ensuring compliance with organizational and regulatory security standards.
- Identify and resolve issues related to the Snowflake environment, providing technical support and troubleshooting assistance to users and stakeholders.
- Create and maintain comprehensive documentation for Snowflake configurations, processes, and procedures.
- Conduct regular health checks and audits to ensure system stability and compliance.
- Monitor and manage costs within Snowflake if required, implementing strategies to optimize consumption and storage costs and ensure efficient use of resources.
- Work closely with developers, data engineers, on initiatives to help optimize data models, queries, and workflows, providing guidance on best practices for using Snowflake.
- Ensure that the Snowflake environment complies with relevant regulatory and organizational standards, implementing necessary controls and processes to maintain compliance.
- Administer RBAC, MFA, etc., Security, identify pipeline for optimization, support, testing new features, etc.
- Automate routine tasks and processes, improving efficiency and reducing manual intervention.
- Collaborate with IT and business teams to plan for future capacity needs.
- Keep skills up to date on Snowflake and other cloud related technologies (Azure, AWS.).
- Collaborates with DevOps to utilize procedures and tooling (i.e., Azure DevOps, Terraform, etc.).
Required Skills/Experience
- 5+ years of experience in Snowflake Administration, Systems/IT Infrastructure or a related field preferably in a high availability architecture.
- Bachelor’s degree in Computer Science, Information Technology, and/or commensurate experience.
- Must be able to demonstrate ability to lead system and application upgrades
- Proficient with troubleshooting techniques to determine root cause analysis and formulate solution recommendations.
- Practical skills in deploying large scale environment processing millions of records per day in a high-availability environment.
- Willingness to learn new technologies at an accelerated pace.
- Excellent analytical and problem-solving skills.
- Excellent written and verbal communication skills and collaboration skills.
Labcorp is proud to be an Equal Opportunity Employer:
As an EOE/AA employer, Labcorp strives for diversity and inclusion in the workforce and does not tolerate harassment or discrimination of any kind. We make employment decisions based on the needs of our business and the qualifications of the individual and do not discriminate based upon race, religion, color, national origin, gender (including pregnancy or other medical conditions/needs), family or parental status, marital, civil union or domestic partnership status, sexual orientation, gender identity, gender expression, personal appearance, age, veteran status, disability, genetic information, or any other legally protected characteristic. Additionally, all qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law.
We encourage all to apply
If you are an individual with a disability who needs assistance using our online tools to search and apply for jobs, or needs an accommodation, please visit our accessibility site or contact us at Labcorp Accessibility.
For more information about how we collect and store your personal data, please see our Privacy Statement.
