CardWorks · 2 days ago
Snowflake Architect
Pittsburgh, PA
Full-time
Onsite
Senior Level
$129K/yr - $143K/yr
5+ years expCardWorks is a diversified consumer finance service provider, and they are seeking a Snowflake Architect/Administrator responsible for planning, designing, developing, and maintaining the Snowflake environment. The role involves contributing to data strategy, establishing best practices, and managing Snowflake accounts to support various data integration and data warehouse projects.
Financial Services
Responsibilities
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
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
Educates the customers in, and fosters an awareness of, the capabilities of the product portfolio to stakeholders across the enterprise
Works with Product Sponsors and Stakeholders to identify opportunities to expand or improve analytic information available
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
Qualification
Required
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
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
Must have experience of Agile development methodologies
Strong verbal and written communication skills
Preferred
Prior Experience in Financial/Banking domain, credit card experience will be an added advantage
Certified Snowflake Architect (Desirable)
Benefits
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
Company
CardWorks
Cardworks is a service provider provides comprehensive service and support to bankcard issuers.
1001-5000 employees
H1B Sponsorship
CardWorks has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2022 (2)
2021 (2)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Parthenon Capital Partners
2022-02-15Private Equity
2017-08-01Private Equity
Leadership Team
Christian Wymbs
EVP & CFO
Recent News
2025-10-03
2025-10-01
2025-05-10
Company data provided by crunchbase