Blog

Position Details

Requirement

CREQ

CREQ204889

Role

Snowflake Architect

Location

NYC, NY (Day 1 On-site – All 5 days’ Work from Office)

Type of Hire – Contract/ C2H

Contract/C2H

Duration

Long Term Contract

Number of Interviews

2

In person interviews Yes/No

No

Client Interview Yes/No

Yes

Position requirements

On-site (No Remote option)

Job Description

Relevant Experience: 12+ Years

Mandatory Skills: Snowflake, SQL Cloud platforms (AWS, Azure or GCP), ETL tools (e.g., Informatica, Talend), Python or Java is a plus

Job Description:

• Snowflake Architect with deep expertise in the payment’s domain.
• Architecture Design: Develop and implement scalable, high-performance data architectures using Snowflake to support payment processing, transaction analytics, and compliance reporting.
• Data Modeling: Design optimized data models tailored to payments data, enabling efficient data ingestion, processing, and retrieval for reporting and analytics.
• Integration with Payment Systems: Collaborate with cross-functional teams to integrate Snowflake with payment processing systems (e.g., SWIFT, ACH, SEPA) and ensure smooth data flow across platforms.
• Performance Optimization: Identify and implement best practices for query performance, storage management, and resource optimization specific to payments data volume and complexity.
• Compliance and Security: Ensure data architecture complies with regulatory requirements (e.g., PCI-DSS, AML, KYC), including data encryption, access controls, and audit trails.
• Data Governance: Implement data governance frameworks within Snowflake, including data quality checks, lineage, and metadata management for payment data.
• Real-Time Data Processing: Design solutions to support real-time or near-real-time processing for payment transactions and monitoring, enabling timely insights and fraud detection.
• This role requires designing, implementing, and optimizing data solutions using Snowflake for payment processing and analytics. The ideal candidate will have extensive experience with data warehousing, cloud infrastructure, and payment systems, as well as a strong understanding of transaction data, compliance requirements, and high-performance architecture.
• Payments Domain Knowledge: In-depth understanding of payment processing systems (SWIFT, ACH, SEPA) and transaction data structures.
• Data Modeling and Warehousing: Strong skills in data modeling, data warehousing, and experience with large-scale data environments.
• Compliance Knowledge: Familiarity with regulatory requirements impacting payment data, including PCI-DSS, AML, and KYC.