Snowflake Administrator

Select how often (in days) to receive an alert:

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
• 401(k) Savings Plan with Company Match
• Company Paid Holidays
• Tuition Reimbursement
• Business Casual Environment
• Rewards & Recognition Program
• Employee Assistance Program
• Office in downtown Greenville that offers free parking, onsite gym, free snacks/drinks

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.

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

Accountability

Understand, adhere to, and enforce all corporate policies.

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 Dev Ops experience with a clear understanding of related tools, structure, and processes. Experience with Terraform/Terra Grunt/Atlantis, Cloud Foundation (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:
  Cortex
  
  AI, 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…