Snowflakes Architect

New York, NY/ Jersey City, NJ – 100% onsite

Contract

Detailed Job Description

Snowflake Architect with deep expertise in the payments 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.

Mandatory skills