Lead Snowflake Administrator

Brand: Purpose Financial

Address: 322 Rhett Street, Greenville, South Carolina, United States - 29601

Purpose Financial, Inc. is an innovative consumer financial services company that offers a diverse suite of credit products, promoting financial inclusion and meeting consumers wherever they are. Through its brands, the company is committed to helping customers achieve their version of financial stability in the moment and in the future. Since 1997, Purpose Financial has been a pioneer in the consumer credit and financial services market offering money solutions in over 800 storefronts locations and online lending. Providing services in over 23 states, Purpose Financial employs over 2,500 team members.

At Purpose Financial we are always on the lookout for motivated individuals who share in our values of mutual respect to join our team of outstanding professionals.

We offer:

• 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

To learn more about Purpose Financial visit Purpose Financial Website.

Position Summary

The Lead 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.

Job Responsibility

Environment management:

• Lead Snowflake account creation, configuration, and lifecycle management.
• Monitor and optimize Snowflake performance, cost, and usage trends across environments.
• Architect, implement, and support replication strategies to ensure enterprise-grade resiliency and business continuity.
• Build and maintain secure data-sharing frameworks for inbound and outbound data exchanges.

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 247 operational support for the Snowflake based data platforms.

Accountability:

• Understand, adhere to, and enforce all corporate policies.

Job Responsibilities Cont.

Education Required

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

Experience Required

Experience Required:

• 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.

Knowledge Required

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 Have:

• 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.

Physical Requirements

Sitting for long periods of time; standing occasionally; walking; bending; squatting; kneeling; pushing/pulling; reaching; twisting; frequent lifting of less than 10 lbs., occasional lifting of up to 20 lbs.; driving and having access during the workday to an insured and reliable transportation; typing; data entry; grasping; transferring items between hands and/or to another person or receptacle; use of office equipment to include computers; ability to travel to, be physically present at, and complete the physical requirements of the position at any assigned location.

Competencies

OKR
Technical Proficiency/Leadership

Travel

0%-10%

Attire

Business Casual

Other

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

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.

Requisition ID: 46483