Databricks Data Architect (Wealth Management Data Platform)

Our client is designing and delivering a modern enterprise data platform for the Wealth Management domain. The platform will consolidate data from multiple CRM, portfolio management, trading, reporting, risk, and compliance systems into a governed, trusted, and scalable source of truth.

The platform will support analytical, operational, regulatory, and client-facing use cases.

This is an architecture role with a primary focus on platform architecture, integration design, Data Vault architecture, governance, and delivery guidance. The person will define the target-state architecture, integration patterns, data modeling approach, and implementation standards, working closely with engineering teams responsible for delivery.

A key focus will be the architecture and design of a Data Vault-based platform on Databricks, enabling scalable ingestion, historization, auditability, lineage, and downstream consumption.

Requirements

• Strong experience designing Databricks Lakehouse architectures, including Spark, SQL, Delta Lake, Unity Catalog, and workflow orchestration concepts.
• Proven experience architecting enterprise data platforms, preferably in financial services or Wealth Management environments.
• Strong practical understanding of Data Vault 2.0 architecture.
• Experience defining integration architecture for enterprise data landscapes with multiple source systems and consumption channels.
• Experience designing governance and security models (Unity Catalog, RBAC/ABAC, row/column-level security, PII protection, and compliance).

Nice to have

• Experience in Wealth Management, Private Banking, Asset Management, Investment Management, Capital Markets, or broader financial services.
• Experience with Databricks Lakeflow Connect, Lakeflow Spark Declarative Pipelines, and Lakeflow Jobs.
• Experience designing platforms that support regulatory, audit, compliance, risk, and financial reporting requirements.
• Experience with MDM concepts.
• Experience with cloud infrastructure on AWS, Azure, or GCP.
• Experience with AI/RAG, semantic search, Vector Search, embeddings, metadata filtering, source-grounded generation, or LLM-based data enrichment is a plus, but not a core requirement.
• dbt experience.

Responsibilities

• Own the target-state architecture for a Databricks-based data platform.
• Define platform architecture, integration patterns, data flows, architectural principles, and delivery guardrails for the engineering teams.
• Design scalable data ingestion, transformation, orchestration, and publication patterns using Databricks, Spark, SQL, Delta Lake, Unity Catalog, and Lakeflow where appropriate.
• Lead the Data Vault architecture, including raw vault, business vault, hubs, links, satellites, historization patterns, PIT tables, bridge tables, and downstream consumption layers.
• Define canonical data models for core Wealth Management entities such as clients, households, advisors, accounts, portfolios, holdings, transactions, products, instruments, mandates, risk profiles, fees, suitability, and regulatory classifications.
• Design integration patterns across heterogeneous source systems, including CRM, portfolio management platforms, trading systems, custodians, market data providers, risk systems, reporting platforms, and compliance tools.

We offer

• Projects for such clients as PayPal, Wargaming, Xerox, Philips, Adidas and Toyota.
• Competitive compensation that depends on your qualification and skills.
• Career development system with clear skill qualifications.
• Flexible working hours aligned to your schedule.
• Options to work remotely.