Sr. Snowflake Architect

Join our team - and take the next step in achieving a fulfilling career!

What We Do

At CardWorks, we aim to help people connect with possibility and opportunity using our financial servicing expertise. Building meaningful, long-term relationships with consumers, our employees, and our clients is what matters most.

Who We Are

CardWorks Servicing, LLC provides end-to end operational servicing functions for credit cards, secured cards, and installment loans.  We service consumer and small business loans across the credit spectrum and offers backup servicing and due diligence services to capital providers and trustees.

Merrick Bank is an FDIC-insured Utah Industrial Loan Bank.  Merrick operates three main business lines:  credit cards, recreational lending, and merchant services.

Carson Smithfield, LLC provides a variety of post-charge-off debt recovery services, including digital self-service, IVR, live agent, and external agency management.

Position Summary:

The Senior Snowflake Architect/Director of Data Engineering is a Snowflake Product Manager, who is responsible for architecture and design of snowflake cloud data platforms including ideation of repeatable design patterns and standards as well as planning, designing, developing, and maintenance. The Senior Snowflake Architect/Director, Data Engineering & Strategy identifies opportunities within the Data & Analytics Business Unit and Cloud-based Data Management Platform (Data Lake, DWH), Data Marts, and Analytic Applications. The candidate is the primary D&A liaison to the business for the assigned products. This position gains an understanding of business needs, clearly communicates those needs, facilitates prioritization discussions across business and D&A constituents, and helps drive vision and future strategy for the Data Engineering & Strategy portfolio of products. The ability to advance Data Engineering capabilities is a critical foundational pillar for a modern and performing Data Management platform. Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse. Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices. This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project.

Essential Functions:

• Defines, evolves, and executes on the product vision for Data and Analytic projects, including Data Lake, Enterprise Data Warehouse and Analytics platform 
• Helps to drive product capabilities and strategy 
• Creates buy-in for the product vision both internally (and eventually with external clients)
• Defines offerings for opportunities to innovate and improve, including identification of opportunities to standardize, simplify, or reduce redundancy within the product offerings and snowflake cloud data platform
• Works in a cross-functional and collaborative role spanning several teams (e.g., IT, Business, Sales, Operations)
• Acts as a technical, strong and eloquent product advocate for our core foundational Cloud-based Data Management Platform 
• Contributes to the data strategy and its execution for the department, such as developing right architecture and enablement of Cloud Data Platform, PCI data tokenization & Detokenization capabilities.
• Design, develop and manage multiple snowflake accounts & environments to be able to support multi legal entity business structures, complex technical projects and create high-level design and architecture of the solution, and infrastructure diagrams.
• Look out for newer and/or enhancements to existing features & capabilities in snowflake space, perform value-vs risk-based assessment, bring them into the company, incorporate into company’s systems and processes, and drive adoption.
• Establish Snowflake best practices for managing load operations and performance.
• Establish standards, dashboards and monitor snowflake accounts for user activities, credits consumptions, warehouses utilization, workloads etc.
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface. 
• Review the architectural/ technological solutions for ongoing projects and ensure the right choice of solution(s) is implemented.
• Work closely with business teams to understand their business, capture requirements, identify pain areas, propose an ideal solution, and implement.
• Manages snowflake data accessibility within CardWorks organization. 
• Acts as a technical, strong, and eloquent product advocate for snowflake and our Cloud-based Data Management Platform 
• Adherence to legal and company standards
• Actively participates in D&A estimating and prioritization sessions.
• Helps to drive product capabilities and strategy. 
• Performs other duties as assigned.

Education and Experience:

• Bachelor’s degree in computer science, Information Technology, Business, Analytics, or relevant field is required. 
• 10+ years of experience in Data Engineering related areas like Warehouse, ETL, and BI projects area. 
• Must have at least 5+ years of experience working as a Snowflake Data Architect and Administrator.
• Experience in Requirements Collection, Documentation, Design, Development and Deployment of data processes is required.
• Prior Experience in Financial/Banking domain, credit card experience will be an added advantage.

Summary of Qualifications:

• Must have prior experience in end-to-end implementation of multi account Snowflake architecture, including deployment model.
• Data governance expertise in snowflake, including column-level data security, and dynamic data masking features.
• Expertise in design and development of secure access to objects in Snowflake with Role-Based Access Control (RBAC), including data access and functional roles.
• Expertise in deploying Snowflake features such as data sharing, zero copy cloning, streamlit, Snowpark, Stored procedures, materialized views etc.
• Expertise in recovery methods and agile development with Time Travel & Cloning.
• Experience in establishing CICD pipeline automation to deploy and manage snowflake code/objects using GitHub, Schema Change etc.
• Experience is setting up monitoring of snowflake accounts, including user activities, credits consumption, warehouses utilization, workloads etc.
• Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
• Experience in re-clustering of the data in Snowflake with good understanding of micro-Partitions.
• Experience in Data Migration from on premise RDBMS to Snowflake cloud data warehouse.
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling).
• Experience with Systems Development Lifecycle, specifically Agile/Scrum.
• Experience working with Data Science (SAS, Python or R) a plus. 
• Experience with process improvement methodologies a plus. 
• Experience with BI/Analysis tools (DOMO, PowerBI, QlikSense, Tableau) a plus
• Experience with AWS data storage and management technologies such as S3, EC2, Lambda, Redshift, RDS.
• Certified Snowflake Architect (Desirable).
• Should be able to troubleshoot problems across infrastructure, platform, and applications.
• Must have experience of Agile development methodologies.
• Strong verbal and written communication skills.

The salary range for this position, if located in NY Metro/NY State is $151,583 to $168,426. However, please note that the salary range will vary for other geographic areas.

Our Employee Value Proposition

• Competitive Pay, including a Bonus Target or Variable Pay Incentive Program 
• Benefits Package -Medical, Dental, and Vision (plus much more) 
• 401(k) Plan with Company Match 
• Short- & Long-Term Disability 
• Wellness Programs 
• Group Life and AD&D Insurance 
• Paid Vacation, Sick Days and bank Holidays 
• Employee Engagement Activities including Employee Appreciation Day, DEI Employee Resource Groups, Corporate Social Responsibility, Service Recognition

We offer a total rewards package comprised of a competitive base rate of pay, variable pay incentive programs based on the role, and a comprehensive benefit suite.  Offered rates of pay are determined based on job-related knowledge, relevant experience, skills, certifications, and geographic location.

We are an equal opportunity employer, and we evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status or any other legally protected characteristic.  We will conduct a thorough background check for all hires in compliance with applicable laws.