Architecture Design:
- Develop and implement scalable highperformance 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 crossfunctional 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. PCIDSS 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.
RealTime Data Processing:
- Design solutions to support realtime or nearrealtime 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 highperformance architecture.
Payments Domain Knowledge:
- Indepth 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 largescale data environments.
Compliance Knowledge:
- Familiarity with regulatory requirements impacting payment data including PCIDSS 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