Snowflake Architect

Job not on LinkedIn

October 30

🗽 New York – Remote

Although this job is listed in New York, this company may be open to hiring remote in other states.

💵 $129k - $143k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🏛️ Architect

🦅 H1B Visa Sponsor

Apply Now

Receive Emails with Similar Jobs

CardWorks

WebsiteLinkedInAll Job Openings

Finance • Banking • Fintech

CardWorks is a credit and payments company that operates as a direct consumer lender, payment processor, and loan/credit servicer. Through its affiliated Merrick Bank and other entities, it issues general-purpose and secured credit cards, provides recreational and installment lending, merchant acquiring and bank sponsorship for ISOs, PayFacs, ISVs and fintechs, and delivers end-to-end servicing (including primary, backup, and post-charge-off recovery) enabled by data, technology and compliance-focused operations. The company serves consumers, banks, and payment industry clients with scalable servicing, risk management, and payment processing solutions.

1001 - 5000 employees

Founded 1987

💸 Finance

🏦 Banking

💳 Fintech

📋 Description

• Responsible for planning, designing, developing, and maintenance of the Snowflake environment including data architecture, data models and standards for various Data Integration Data Warehouse projects in Snowflake. • 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 in the field of data warehouse architecture and modelling. • 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. • Gather end user requirements, convert them into technical requirements and documentation. • Manage snowflake data accessibility within CardWorks organization. • Act as a technical, strong, and eloquent product advocate for snowflake and our Cloud-based Data Management Platform. • Educate customers in, and foster an awareness of, the capabilities of the product portfolio to stakeholders across the enterprise. • Work with Product Sponsors and Stakeholders to identify opportunities to expand or improve analytic information available. • Adhere to legal and company standards • Actively participate in D&A estimating and prioritization sessions. • Help to drive product capabilities and strategy. • Perform other duties as assigned.

🎯 Requirements

• Bachelor’s degree in computer science, Information Technology, Business, Analytics, or relevant field is required. • Must have at least 5+ years of experience working as a Snowflake Data Architect and 10+ years of experience in Data Warehouse, ETL, and BI projects area. • 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. • 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 AWS data storage and management technologies such as S3, EC2, Lambda, Redshift, RDS. • Certified Snowflake Architect (Desirable).

🏖️ Benefits

• 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