Data Architect - Banking

Hong Kong Unison Limited; Singapore; On-site; SGD 180,000 - 260,000; Full time

Job summary

Unison Consulting is seeking a senior Data Architect with a decade in data and substantial banking experience. You will shape data platforms, models and lakehouse architectures for regulatory and business needs.

You will drive design reviews, create authoritative data specifications, and collaborate with data engineering teams to ensure lineage, quality and auditability across large data estates.

Qualifications

• 10+ years in data with 4+ years in banking domain.
• Hands-on data engineering background required.
• Experience designing data platforms for large banks including BCBS 239 lineage and audit.
• Proficient in data warehousing, lakehouse concepts and data products.
• Strong data modelling: dimensional, 3NF, Data Vault; semantic layers.

Responsibilities

• Lead design authority discussions and review architecture & code.
• Produce design specifications for regulatory review and audit.

Skills

Data platform design

Banking data models

BCBS 239 standards

Data warehouse

Data mesh / lakehouse

Dimensional data modelling

SCD Type 2 / bi-temporal

Data as a service

Metadata & data quality

ETL/ELT development

Teradata / Hadoop

Spark / Python / SQL

Streaming / Kafka

Denodo / Snowflake

Cloud & DevOps

Education

Bachelor's degree in CS or related field

Tools

Teradata

Hadoop / Cloudera

Snowflake

Databricks

Kubernetes

Airflow

Job description

We are looking for a Data Architect with 10+ years in data, including 4+ years in banking and a hands‑on data engineering background.

Must-have skills

• Data platform design inside tier-1 or large regional banks.
• Banking data models (Teradata FSLDM or equivalent) across customer, account, payments and AML/CFT subject areas.
• Financial crime or regulatory data marts built to BCBS 239 standards for lineage, reconciliation and audit.
• Enterprise data warehouse, data lake and Lakehouse architecture; Data Mesh and Data Fabric concepts.
• Data modelling: dimensional, 3NF and Data Vault; semantic layers and data products.
• Historical data design: snapshots, SCD Type 2, bi-temporal models and large multi-grain backfills.
• Data-as-a-service patterns across batch and API delivery, with lineage, observability and SLA monitoring.
• Metadata, business glossary, lineage and data quality frameworks.
• ETL/ELT development, CDC, historical data processing, metadata-driven automation frameworks and performance optimisation.
• Teradata and Hadoop/Cloudera at scale: warehouses of 100 TB+ and tables of billions of rows.
• Spark, Python, R, SQL, Hive, Impala, HBase, Pig and Hue; Apache Iceberg and Trino.
• Streaming and integration: Kafka, Spark Streaming, Informatica (including IDL) and Talend.
• Databases and data federation: advanced SQL, NoSQL, Denodo and Snowflake.
• Cloud and DevOps: Kubernetes, Airflow, GitOps and CI/CD tools.

Delivery and communication

• Running design authority forums and reviewing engineers’ designs and code.
• Writing design specifications that pass architecture, audit and regulatory review.

Good-to-have skills

• Databricks, Snowflake and Lakehouse platforms; data services on Azure, Google Cloud, Huawei Cloud or Alibaba Cloud.
• BI and analytics platforms: Qlik Sense, Microsoft Power BI and Azure analytics services.

Certifications (preferred):

TOGAF; Teradata Vantage; Cloudera; DAMA CDMP; Databricks or cloud architect

Unison Consulting established in the year 2012 in Singapore. We provide technology consulting, systems implementation, and integrations service to Asia Pacific customers. We help transform enterprise data in actionable insights. Our consultants have wide range of functional expertise within Banking and Financial services spectrum, working closely with clients to anticipate, illuminate and overcome complex business challenges.

Our objective is to be a one-stop solution provider all enterprise business intelligence and data warehousing needs of organizations.

Our mission is to consistently deliver our services to our clients in a cost-effective way without compromising the quality.

Our current clients include - DBS, OCBC, Standard Chartered Bank and Maybank.

Unison Consulting established in the year 2012 in Singapore. We provide technology consulting, systems implementation, and integrations service to Asia Pacific customers. We help transform enterprise data in actionable insights. Our consultants have wide range of functional expertise within Banking and Financial services spectrum, working closely with clients to anticipate, illuminate and overcome complex business challenges.

Our objective is to be a one-stop solution provider all enterprise business intelligence and data warehousing needs of organizations.

Our mission is to consistently deliver our services to our clients in a cost-effective way without compromising the quality.

Our current clients include - DBS, OCBC, Standard Chartered Bank and Maybank.