Principle Snowflake Administrator

Ally and Your Career Ally Financial only succeeds when its people do - and that’s more than some cliché people put on job postings. We love this stuff! We see our people as, well, people - with interests, families, friends, dreams, and causes that are all important to them. Our focus is on the health and safety of our teammates as well as work-life balance and diversity and inclusion.

From generous benefits to a variety of employee resource groups, we strive to build paths that encourage employees to stretch themselves professionally. We want to help you grow, develop, and learn new things. You’re constantly evolving, so shouldn’t your opportunities be, too?

Work Schedule :
Ally designates roles as (1) fully on-site, (2) hybrid, or (3) fully remote. Hybrid roles are generally expected to be in the office a certain number of days per week as indicated by your manager. Your hiring manager will discuss this role's specific work requirements with you during the hiring process. All work requirements are subject to change at any time based on leader discretion and/or business need.

The Opportunity Provide technical leadership and support on all the stages of database architecture, implementation and/or database related operational support. Participates in designing and implementing database systems and programs. Responsible for developing and administering access methods, device allocation, and security. Participates in database planning and provides inputs on the selection of methods used for database system integration. Interface with business sector managers to assist in resolving database issues and needs.

The Work Itself The Sr. Snowflake Database Administrator will be part of a team that administers and supports enterprise Snowflake environments across cloud platforms. Design, implement, and maintain Snowflake platform architecture, security, and governance policies. Manage access controls, RBAC, SSO, masking policies, and data governance frameworks across enterprise environments. Monitor, optimize, and manage Snowflake performance, workloads, and cost efficiency. Implement and support Snowpipe, Streams, Tasks, Dynamic Tables, and Data Sharing capabilities.

Automate platform deployments using CI/CD pipelines and Infrastructure as Code tools such as Terraform. Manage backup, disaster recovery, replication, and overall platform reliability. Partner with Data Engineering, Analytics, and Security teams to support business initiatives and data platform strategy. Troubleshoot production issues and provide operational support across Snowflake environments. Evaluate and support AI/ML and generative AI use cases within Snowflake, including Cortex AI features where applicable.

The Qualifications We’re Looking For8+ years of experience preferred.

Strong hands-on experience with Snowflake Administration and Architecture required. Expertise in SQL, performance tuning, and query optimization.

Experience with AWS cloud platforms. Solid understanding of data security, governance, and compliance frameworks.

Experience with Terraform, Dev Ops, and automation practices. 1–2 years of experience working with Snowflake Cortex AI, AI-powered data services, or related AI capabilities. Programming experience in Python for automation, scripting, and data platform support. Excellent problem-solving and communication skills. Snow Pro Certification preferred.

Experience with Power BI or other reporting platforms preferred. Knowledge of networking concepts, connectivity, and cloud network configurations preferred.

Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.

Experience with software…