General information
Ref # 16908
Remote? No
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 live 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?
The Opportunity
At Ally, you get a startup feel, but experience the benefits of a company that’s worked out the kinks and is fulfilling its purpose. We’re always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions. To read more about what our tech team does, be sure to visit our tech blog at ally.tech
We are seeking a Technical Manager - Snowflake Administration to manage the day-to-day operations Ally’s Snowflake data platform. At Ally, the data that we use to make critical business decisions every day is the cornerstone of our success. The data stored in our Snowflake SaaS accounts is the cornerstone of our data platform. Our Snowflake data platform is the enterprise data warehouse, positioned to impact the immediate and strategic success of the organization, across all lines of business. As the subject matter expert in this space, your input will be sought when making tactical and strategic design decisions.
The Work Itself
Perform role of Technical Manager over the Snowflake DBA TeamAbility to think creatively and critically, and openly share your viewpoints in all matters related to SnowflakeMentor and inspire junior Snowflake admins, collaborate with senior Snowflake admins, and synthesize solutions in concert with internal customersThorough working knowledge of Snowflake administration related technologies:
RBAC - Ability to read, understand and create Snowflake stored procedures and related objects to automate routine management tasks
Snowflake data sharingSnowflake Infrastructure: Tri-Secret Secure, PrivateLink, SSO, SCIM, security and storageIntegrationsData replication, particularly when applied to a disaster recovery solutionVirtual warehouse management in the context of performance and cost managementData engineering topics: Tasks, Streams, Cloning, ETL, data maskingThorough working knowledge of ACCOUNTUSAGE and INFORMATIONSCHEMA views
Engage and lead conversations with SMEs in other related teams (Active Directory, Okta/IDP, networking, cloud engineering) to create, test, and deploy cross platform technical solutions.
Partner with Ally's Cloud Architecture, compliance, internal audit, and security professionals to ensure all Snowflake solutions adhere to approved recommendations and standardsCommunicate project status, blockers, and alternate solutions in a clear and concise manner to leadership teamChallenge requests that do not conform to the accepted standards and best practicesRecognize the difference between essential and non-essential activities; focus on activities that will have maximum long-term impactMaintain and design processes to proactively detect issues before they happen
Manage and enforce standard Change Management processes and procedures
The Skills You Bring
3+ years of experience managing complex Snowflake accounts and a Snowflake DBA team/experience with technical leadership5-10+ years of progressive database admin experience including SQL / scriptingBS in a technical disciplineHands on working knowledge of networking and cloud infrastructure technologies (IPv4, SSO / OKTA / SCIM, Active Directory), particularly in AWSGitlab / CICD / code managementMust be able to effectively manage multiple projects with competing prioritiesEnthusiastic, resourceful, creative, and results-oriented with demonstrated problem solving skillsSnowflake and related cloud technology certifications, preferredPython, Machine Learning/AI, and data science experience, preferred#LI-hybrid
How We'll Have Your Back
*
Ally's compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. But Ally’s total compensation - or total rewards - extends beyond your paycheck and is designed to support and enrich your personal and professional life, including:* Time Away: competitive holiday and flexible paid-time-off, including time off for volunteering and voting.* Planning for the Future: plan for the near and long term with an industry-leading 401K retirement savings plan with matching and company contributions, student loan and 529 educational assistance programs, tuition reimbursement, and other financial well-being programs.* Supporting your Health & Well-being: flexible health and insurance options including dental and vision, pre-tax Health Savings Account with employer contributions and a total well-being program that helps you and your family stay on track physically, socially, emotionally, and financially.* Building a Family: adoption, surrogacy, and fertility support as well as parental and caregiver leave, back-up child and adult/elder day care program and childcare discounts.* Work-Life Integration: other benefits including LifeMatters® Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.
Who We Are:
Ally Financial is a customer-centric, leading digital financial services company with passionate customer service and innovative financial solutions. We are relentlessly focused on "Doing it Right" and being a trusted financial-services provider to our consumer, commercial, and corporate customers. For more information, visit www.ally.com.
Ally is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity or expression, pregnancy status, marital status, military or veteran status, genetic disposition or any other reason protected by law.
Where permitted by applicable law, must have received or be willing to receive the COVID-19 vaccine by date of hire to be considered, if not currently employed by Ally.
We are committed to working with and providing reasonable accommodation to applicants with physical or mental disabilities. For accommodation requests, email us at [email protected]. Ally will not discriminate against any qualified individual who is capable of performing the essential functions of the job with or without reasonable accommodation.
Base Pay Range:
Emerging: 110000
Experienced: 145000
Expert: 180000
Incentive Compensation: This position is eligible to participate in our annual incentive plan