Apply on Employer Site

Purpose Financial · 1 month ago

Snowflake Administrator

Greenville, SC

Full-time

Onsite

Senior Level

5+ years exp

Purpose Financial, Inc. is an innovative consumer financial services company that offers a diverse suite of credit products. The Snowflake Administrator will support and maintain the health and performance of a Snowflake data platform while providing technical leadership and operational support for the Snowflake environment.

CommunitiesFinancial ServicesProfessional Services

No H1B

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

Qualification

Snowflake AdministrationPerformance OptimizationData IntegrationDevOps ExperiencePythonSQLLinuxCI/CD PipelinesAgile/SCRUMDocumentationCommunication Skills

Required

Bachelor's degree (or foreign equivalent degree) in any Computer, Engineering, or other technical field, or equivalent level of job experience

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

Must be eligible to work in the USA and able to pass a background check

Preferred

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