Snowflakes Architect with Strong Data Lake experience

Role - Snowflakes Architect with Strong Data Lake experience

Location: NYC/NJ - 100% onsite

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

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