
Lead Data Architect – Snowflake & Payments (BFSI) | Atlanta GA – 30326 (Hybrid)—Locals Only
Quick overview
Job description
Job Title: Lead Data Architect – Snowflake & Payments (BFS)-- 12+ years
Location: Atlanta GA – 30326 (Hybrid)—Locals Only
Duration: Long Term
Role overview
We're hiring a Lead Data Architect to guide a payments client through key architecture decisions and design the data models behind a semantic layer spanning many business domains. The client runs several Snowflake instances across more than one cloud. You will set the target architecture, define how shared business entities are modelled consistently across them, and lead the client's data teams through delivery.
This is a billable, client-facing consulting role. You will be the client's trusted technical advisor and the senior architect on the engagement.
Key responsibilities
Architecture decisions
- Lead architecture decisions for a multi-instance Snowflake estate across multiple clouds (for example AWS and Azure). Topics include data sharing, replication, failover and cross-region or cross-cloud access.
- Write architecture decision records that set out options, trade-offs and a recommendation, and present them to client architecture boards and senior stakeholders.
- Define standards for environment layout, naming, security, role-based access and cost management.
Semantic layer and data modelling
- Design the semantic layer: shared business definitions, metrics and dimensions that give every business area one consistent view of the data.
- Build conceptual, logical and physical data models for payments domains. Examples include authorisation, settlement, billing and pricing, disputes and chargebacks, merchant onboarding and hierarchy, funding, fraud and risk, and general ledger accounting.
- Model shared entities such as merchant, customer, product and transaction once, and reconcile them across instances and source systems.
- Help sequence domain delivery across a multi-quarter roadmap, balancing business priority against data readiness.
Client leadership and delivery
- Act as the client's lead technical advisor, translating business requirements from finance, operations and product teams into data designs.
- Guide data engineers and analytics engineers on implementation, including tools such as dbt and Snowflake semantic views.
- Review designs and code for quality, performance and adherence to the target architecture.
- Identify risks early, propose options and keep the engagement on scope and on schedule.
Required qualifications
- 12+ years in data architecture, data warehousing or data engineering, with 5+ years as a lead or principal architect.
- Deep Snowflake expertise: 5+ years designing on Snowflake, including multi-account or multi-instance setups, data sharing, replication, security, and performance and cost tuning.
- Payments domain knowledge in banking and financial services: hands-on work with payments data such as card authorisation, clearing and settlement, merchant acquiring, interchange and fees, or chargebacks.
- Semantic layer and modelling: proven design of enterprise data models and semantic or metrics layers. Familiar with dimensional modelling, Data Vault or similar approaches.
- Multi-cloud: experience with data platforms across at least two of AWS, Azure and Google Cloud Platform.
- Client-facing consulting: led architecture decisions with senior client stakeholders and presented recommendations to architecture or governance boards.
- Strong SQL and working knowledge of dbt or similar transformation tools.
- Clear written and spoken communication, including architecture decision records and design documents.
Preferred qualifications
- SnowPro Advanced: Architect or Data Engineer certification.
- Experience with Snowflake semantic views, Cortex Analyst, or semantic layer tools such as dbt Semantic Layer, AtScale or Cube.
- Background at a payment processor, acquirer, card network, merchant services provider or bank payments division.
- Knowledge of payments regulation and controls, such as PCI DSS, SOX and data privacy requirements.
- Experience consolidating data after mergers or across business units with different source systems.
- Familiarity with data governance and catalog tools, such as Collibra, Alation or Snowflake Horizon.
Best Regards,
Ravi M | Senior Recruiter
Cyberobotix Technology
6500 River Place Blvd, Building 7,
Suites 250, Austin, Texas 78730
E:
W:
Technology Consulting & Talent Solutions | United States & India
This email and any attachments are confidential and intended only for the recipient.
Similar jobs
- TT
Senior Databricks Data ArchitectRecently posted
Tbright Technologies · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLGitApache Spark+9TechnologySalary not listed - TE

Teradata ArchitectRecently posted
TekDallas · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLShellAWS+7TechnologySalary not listed - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Schertz, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Converse, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · San Antonio, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Universal City, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · New Braunfels, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Seguin, Texas · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Mc Lean, Virginia · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - GU
Associate Director, Lead Data Architect - DatabricksRecently posted
Guidehouse · Arlington, Virginia · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSDatabricksUnity+1Technology$149k - $248k/yr - AI

Data Platform Principal Architect, Seattle/San FranciscoRecently posted Auto Apply
Airwallex · US - Seattle · Hybrid · Posted 16 Nov 2026 🇺🇸
ComplianceDatabricksKafka+3Salary not listed - NG

Senior Data ArchitectRecently posted Auto Apply
Nimble Gravity · LATAM (Remote) · Remote · Posted 15 Nov 2026 🇺🇸
SQLApache SparkCompliance+7TechnologySalary not listed