Snowflake Engineer

Orosof LLC - New York, NY

Full-time

New York, NY

About the position

The Snowflake Engineer will develop and implement scalable, high-performance data architectures using Snowflake to support payment processing, transaction analytics, and compliance reporting. This role focuses on designing optimized data models, integrating with payment systems, and ensuring compliance with regulatory requirements while enabling real-time data processing for timely insights and fraud detection.

Responsibilities

• Develop and implement scalable data architectures using Snowflake for payment processing and analytics.
• Design optimized data models tailored to payments data for efficient ingestion, processing, and retrieval.
• Collaborate with cross-functional teams to integrate Snowflake with payment processing systems (e.g., SWIFT, ACH, SEPA).
• Identify and implement best practices for query performance, storage management, and resource optimization.
• Ensure data architecture complies with regulatory requirements (e.g., PCI-DSS, AML, KYC).
• Implement data governance frameworks within Snowflake, including data quality checks and metadata management.
• Design solutions to support real-time or near-real-time processing for payment transactions.

Requirements

• Extensive experience with data warehousing and cloud infrastructure.
• Strong understanding of transaction data and compliance requirements.
• In-depth knowledge of payment processing systems (SWIFT, ACH, SEPA).
• Strong skills in data modeling and experience with large-scale data environments.
• Familiarity with regulatory requirements impacting payment data, including PCI-DSS, AML, and KYC.
• Proficiency in Snowflake and SQL.
• Experience with cloud platforms (AWS, Azure, or Google Cloud Platform).
• Experience with ETL tools (e.g., Informatica, Talend).

Nice-to-haves

• Experience with Python or Java.