Snowflake Administrator

Purpose Financial•Greenville, SC

37d•Onsite

About The Position

The Snowflake Administrator reports to the Manager of Data Operations and is responsible for supporting and maintaining the health and performance of a Snowflake data platform. Provide technical leadership and operational support for our Snowflake environment. As a thought leader in Data Platforms, evaluate new technologies and features, design and implement them by partnering with architects and end users. Collaborate with other data teams to proactively identify cost anomalies and savings opportunities.

Requirements

5+ years of proven experience with Snowflake Platform Administration in an enterprise-level environment.
2+ years of DevOps experience with a clear understanding of related tools, structure, and processes. Experience with Terraform/TerraGrunt/Atlantis, CloudFoundation (or similar IaC)
Hands-on experience with Snowflake administration and optimization in AWS (preferred) or other cloud environments.
Expertise in Snowflake advanced concepts such as resource monitors, RBAC controls, and cost optimization. Snowflake utilization and Capacity Planning for general operations as well as peak periods.
Proficiency with Linux, Python, SQL, and ETL/Scheduler tools; and operating in regulated environments.
Programming experience required, preferably Python.
Solid understanding of Snowflake features: CortexAI, Streamlit, Cloning, Data Sharing, Secure views, caching, warehouse sizes, and scaling
Experience with Snowflake data loading and unloading processes.
Familiarity with Snowflake's security features and role-based access control.
Knowledge of integrating Snowflake with various data sources and BI tools.
Experience authoring CI/CD pipelines, automation elements related to infrastructure composition, deployment orchestration, and monitoring.
Familiarity and experience with Agile/SCRUM based development methodology.
Able to manage automated build & deployment processes along with Rollback mechanisms.
Excellent written and verbal communications skills; adaptability and flexibility to changing environment; and comfortable working in a dynamic, high volume, fast-paced environment. Ability to understand and ensure compliance with policies, procedures, and laws governing our industry/business and products.

Nice To Haves

Aide in developing and managing Kafka-based data pipelines.
Maintaining the availability, performance, and security of Kafka infrastructure.
Creating and managing Kafka topics, producers, consumers, Python-based Kafka consumers, and producers to enable efficient data processing with other systems.
Familiarity with related technologies like Kafka Connect, and Kafka Streams enhances effectiveness.

Responsibilities

Environment management: Create, manage, and maintain Snowflake databases, warehouses, and roles.
Security and access: Implement and manage robust security measures, including user access controls, roles, and permissions.
Performance optimization: Monitor system performance, analyze query execution, and tune database configurations to improve efficiency and reduce costs.
Data loading and integration: Develop and execute strategies for data loading, migration, and integration with other systems and tools.
Troubleshooting and support: Diagnose and resolve database-related issues and provide support to data engineers, business analysts, and end-users.
Compliance and governance: Ensure compliance with data governance policies and regulatory requirements.
Automation: Write scripts (e.g., Python, SQL) to automate repetitive tasks like data ingestion, backups, and monitoring.
Documentation: Maintain comprehensive documentation of the Snowflake architecture, processes, and procedures.
Dailly Activities: Participate in on-call rotations, providing 24×7 operational support for the Snowflake based data platforms.

Benefits

Competitive Wages
Health/Life Benefits
Health Savings Account plus Employer Seed
401(k) Savings Plan with Company Match
Paid Parental Leave
Company Paid Holidays
Paid Time Off including Volunteer Time
Tuition Reimbursement
Business Casual Environment
Rewards & Recognition Program
Employee Assistance Program
Office in downtown Greenville that offers free parking, onsite gym, free snacks/drinks