Role Overview
We are looking for a Senior Data Architect (15+ years experience) to design and own the entire data architecture for a financial services platform covering:
* Accounts / Real-Time Ledger (RTL)
* Payments Engine
* Foreign Exchange (FX)
* Enterprise Data Platform
The architect will be responsible for how data is stored, moved, governed, secured, and consumed across operational systems and the enterprise data warehouse (Snowflake).
Must-Have Keywords (High Priority)
Data Architecture
✅Data Architecture
✅ Enterprise Data Platform
✅ Data Modelling
✅ Data Governance
✅ Data Lineage
✅ Data Quality
✅ Data Dictionary
✅ ERD (Entity Relationship Diagrams)
✅ Data Flow Diagrams
✅ Data Contracts
✅ ADRs (Architecture Decision Records)
✅ Domain-Driven Design
Snowflake (Critical Skill)
✅ Snowflake Architecture
✅ Snowflake Data Warehouse
✅ Snowpipe
✅ Streams & Tasks
✅ Snowpark
✅ Dynamic Tables
✅ Cortex AI
✅ Dynamic Data Masking
✅ Row-Level Security
✅ Clustering Keys
✅ Materialized Views
✅ Cost Governance
✅ Query Optimization
Databases
✅ PostgreSQL
✅ Oracle Database
✅ Redis
✅ MongoDB
✅ TimescaleDB
✅ InfluxDB
Skills Required:
* Schema Design
* Indexing Strategy
* Replication
* Database Performance Tuning
* Data Lifecycle Management
Data Integration & Engineering
✅ CDC (Change Data Capture)
✅ Debezium
✅ Kafka Connect
✅ ETL / ELT
✅ Apache Spark
✅ AWS Glue
✅ Event-Driven Architecture
✅ NATS JetStream
✅ Real-Time Data Pipelines
Cloud & AWS
✅ AWS
✅ S3
✅ RDS
✅ Aurora
✅ Glue
✅ IAM
✅ VPC
✅ Lake Formation
✅ Redshift Migration
Governance & Compliance
✅ GDPR
✅ BCBS 239
✅ Data Classification
✅ Data Stewardship
✅ Data Ownership
✅ Data Retention Policies
✅ Master Data Management (MDM)
Tools:
* Apache Atlas
* Collibra
* Snowflake Horizon Catalog
AI / ML & Analytics
✅ Feature Stores
✅ ML Pipelines
✅ AI/ML Data Architecture
✅ Snowflake Cortex AI
✅ Vector Databases
✅ LLM Data Pipelines
✅ AI-Powered Data Cataloguing
Data Transformation
✅ dbt (Data Build Tool)
Key Areas:
* Data Modelling
* Testing Frameworks
* Documentation
* Incremental Models
* Analytics Engineering
Financial Services Domain Experience (Very Important)
Candidates should ideally have experience in:
Real-Time Ledger (RTL)
✅ Double-Entry Accounting
✅ Event-Sourced Ledger
✅ Balance Aggregation
✅ Reconciliation
Payments
✅ ISO 20022
✅ SWIFT
✅ Payment Processing
✅ Settlement Systems
✅ Payment Lifecycle
Foreign Exchange (FX)
✅ FX Trading Systems
✅ Trade Data Models
✅ Market Data Feeds
✅ Position Keeping
✅ P&L Attribution
Risk & Limits
✅ Exposure Management
✅ Limit Management
✅ Risk Aggregation
Regulatory Reporting
✅ BCBS 239
✅ EMIR
✅ MiFID
Client Onboarding
✅ KYC
✅ AML
✅ Client Master Data
Key Responsibilities
Data Architecture
* Define enterprise-wide data architecture.
* Design data models across multiple database technologies.
* Establish data standards and governance frameworks.
* Define data ownership, lineage, and quality controls.
Snowflake Leadership
* Design and optimize Snowflake architecture.
* Build ingestion frameworks and transformation standards.
* Implement security and compliance controls.
* Manage warehouse performance and costs.
Database Governance
* Review database schemas and performance.
* Define migration and versioning standards.
* Ensure consistency between transactional and analytical systems.
Data Governance
* Implement data quality rules and SLAs.
* Manage lineage and metadata.
* Support regulatory compliance requirements.
AI & Analytics
* Design data products for reporting and analytics.
* Build foundations for ML and AI workloads.
* Support feature stores and LLM use cases.
Stakeholder Management
* Work with Engineering, Risk, Finance, Operations, and Product teams.
* Mentor engineers and developers.
* Drive architecture decisions across the organization.
Ideal Candidate Profile
Mandatory
✔ 15+ years IT experience
✔ 5+ years as Data Architect
✔ Strong Snowflake Architecture experience
✔ Financial Services / Banking experience
✔ Data Governance and Data Quality expertise
✔ Real-time Data Pipelines experience
✔ AWS Cloud experience
✔ Strong SQL and Data Modelling skills
✔ Stakeholder Management experience
Preferred Certifications
✔ Snowflake SnowPro Core
✔ Snowflake SnowPro Architect
✔ AWS Solutions Architect
✔ AWS Data Analytics