# Herrick OCHOM

Herrick OCHOM is a remote worker on Himalayas, Data Architect / Data Engineer / Data Modeller at TCS / NatWest Banking Group, based in United Kingdom.

Source: https://himalayas.app/@herrickochom

```text
Data Architect at TCS / NatWest Banking Group who architected a governed payments lakehouse processing ISO 20022 events into data products.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United Kingdom |
| Authorized to work in | United Kingdom, United States, Canada, Switzerland, Kazakhstan, Suriname, Somalia |
| Salary expectations | 99k-100k GBP |
| Job categories | Data Architect, Data Engineer, Data Modeller, Business Analyst, Data Consultant, AI Developer |
| Skills | Enterprise Data Architecture, Data Modeling, Financial Services Data, Data Governance, Data Lakehouse, Data Mesh, Data Products, Data Warehouse, Data Integration, Data Quality, Data Lineage, Data Security, Data Engineering, SQL, Python |

## About

```text
At TCS / NatWest Banking Group, I architected a medallion payments lakehouse using dbt, Apache Iceberg, Athena and S3 to process ISO 20022 payment events from Kafka into governed data products. I also designed reusable payment event models with data quality controls, DLP and PII tokenisation.

Across banking and financial services clients including Nationwide Building Society, Barclays Bank, AIB and HSBC, I’ve translated risk, regulatory and transactional requirements into enterprise data architectures and models. My work has included modernising data platforms, supporting credit risk and financial crime data, and establishing governance and integration patterns.
```

## Experience

### Data Architect / Data Engineer / Data Modeller

TCS / NatWest Banking Group. Feb 2026 - Aug 2026

```text
Architected a medallion payments data lakehouse using dbt, Apache Iceberg, Athena and S3, processing ISO 20022 payment events from Kafka into governed silver and gold data products. Led legacy system discovery, data mapping and domain analysis across retail and commercial banking data.
```

Skills: DBT, Apache-Iceberg, Athena, S3, Kafka, Data-Lakehouse, Data-Governance, DLP, Tokenization, Architecture-Decisions

### Lead Data Architect / Data Solution Architect

Stragechom Consulting (UK) Ltd. Feb 2025 - Jul 2025

```text
Architected and implemented a Dockerised data lakehouse integrating Spark, HDFS/S3, Hive Metastore, PostgreSQL and Apache Iceberg. Established ingestion and dbt transformation patterns supporting bronze, silver and gold data layers.
```

Skills: Docker, Spark, HDFS, S3, HiveMetastore, PostgreSQL, Apache-Iceberg, DBT, Data-Lakehouse, Data-Governance

### Data Architect / Consultant - Azure Data Platform

Stragechom Consulting (UK) Ltd. May 2023 - Dec 2024

```text
Developed a Data Strategy Framework and Credit Score MIS for Ugandan financial institutions using Data Fabric and Data Mesh approaches. Designed secure data integration pipelines, semantic models and governance controls using Azure data services, Power BI, Purview and Databricks.
```

Skills: Azure, Power-BI, Purview, Databricks, Data-Fabric, Data-Mesh, Data-Governance, Semantic-Modeling

### Senior Data Architect / Senior Business Analyst - GCP Platform

BT Digital. Jul 2022 - Feb 2023

```text
Designed enterprise data architecture using data mesh and data product approaches to support digital transformation. Developed and governed conceptual and logical models to unify disparate enterprise sources and improve interoperability.
```

Skills: GCP, Dataplex, BigQuery, BigTable, IAM, KMS, Data-Mesh, Data-Governance

### Data Consultant / Data Platform Practice Lead - Azure

The Innovation Village, Kampala. Jan 2021 - Sep 2021

```text
Led the design and implementation of an Azure data platform integrating customer journey data from multiple retail systems. Built enterprise analytical models using Kimball and 3NF approaches and established data governance, quality and security controls.
```

Skills: Azure, Kimball, 3NF, Data-Governance, Data-Quality, Security

### Data Solution Architect / Data Modeller - Teradata / Cloudera / AWS

[Nationwide Building Society](https://himalayas.app/companies/nationwide-cws). Sep 2018 - Oct 2019

```text
Designed end to end data solutions and enterprise models for regulated banking initiatives including CMA CAPA, EBA PSD2 and FCA financial crime requirements. Created data models and master data structures across Teradata, Cloudera and AWS, ensuring integrity, scalability, governance and business alignment.
```

Skills: Teradata, Cloudera, AWS, Data-Modeling, Data-Governance, Regulatory-Compliance

### Data Architect / Data Modeller - Corporate Credit Risk

[Barclays Bank](https://himalayas.app/companies/barclays). Feb 2016 - Aug 2018

```text
Led enhancement and support of the Corporate Credit Risk System within Basel III, Bank Reform Act 2013 and EBA capital regulatory requirements. Translated complex credit risk and regulatory requirements into technical specifications, data models, process flows and system architecture.
```

Skills: Teradata, SQL, ETL, Credit-Risk, Basel-III, Regulatory-Compliance

### Data Solution Architect / Data Modeller - Teradata

AIB, Dublin. Aug 2015 - Dec 2015

```text
Designed and implemented customer segmentation models and supporting data structures for banking analytics. Engineered high-performance Teradata and Informatica data solutions supporting KYC, AML and customer data processing.
```

Skills: Teradata, Informatica, KYC, AML, Customer-Segmentation

### Business Analyst / Technical Data Consultant - Teradata

HSBC, Sheffield. Jan 2015 - Jul 2015

```text
Designed an integrated banking data solution supporting Suspicious Activity Reporting and financial crime investigation. Consolidated diverse data sources into governed analytical structures using Teradata, DataStage, Inmon and Kimball approaches.
```

Skills: Teradata, DataStage, Inmon, Kimball, Data-Profiling, ETL

### EDW Technical Architect / Data Modeller - Teradata

Shop Direct, Liverpool. Aug 2014 - Dec 2014

```text
Optimised enterprise Teradata data models and execution plan for high volume transactional and analytical workloads. Used data profiling, indexing, partitioning, join strategy and SQL Explain techniques to improve performance of critical reporting.
```

Skills: Teradata, Data-Modeling, SQL, Performance-Optimization

### Professional Services Consultant / Data Modeller

Teradata International, Prague. Aug 2012 - Mar 2014

```text
Designed and implemented enterprise BI, EDW and data modelling solutions for clients including Lloyds Bank, UniCredit Bank and BNP Paribas. Created scalable Teradata data models and ETL solutions using Informatica and IBM DataStage.
```

Skills: Teradata, Informatica, IBM-DataStage, EDW, BIツール, Data-Modeling

## Education

### University of the West of England

Bachelor of Science, Applied Statistics

```text
BSc in Applied Statistics from the University of the West of England, Bristol, UK.
```

### Teradata

Teradata Certified, Data Management

```text
Teradata certification.
```

## Tech stack

- Snowflake
- AWS Glue
- dbt
- PostgreSQL
- MongoDB
- Cassandra
- Oracle
- Databricks
- Python
- Kafka
- SQL
- Apache Iceberg
- DuckDB
- Trino
- Collibra
- Microsoft Purview
- Informatica PowerCenter
- AWS

To contact Herrick, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Antreas F](https://himalayas.app/@antreasf): Lead Data Engineer, Redkite Data Intelligence (Now Accenture)
- [Gnanasambandham Balasundaram](https://himalayas.app/@gnanasambandhambalas): Data Engineer, NatWest
- [Adil Khan](https://himalayas.app/@adilkhan49): Senior Data Consultant, Cervello, A. T. Kearney
- [Hove Henry](https://himalayas.app/@hovehenry): Lead Data Architect & Principal, CyberPro Consulting
- [Pavan Tikkisetty](https://himalayas.app/@pavantikkisetty): Data Engineer, Mercedes Benz UK
- [Imad TALSI](https://himalayas.app/@imadtalsi): Senior Data Architect, Decathlon
- [Kalpana Munag](https://himalayas.app/@kalpanamunag): Enterprise Data Architect (Senior Manager), Legal & General
- [Kostas Papadopoulos](https://himalayas.app/@kostaspapadopoulos): Senior Data Engineering Manager, AllPoints Fibre Network Ltd
- [Venkat Chamarthy](https://himalayas.app/@venkatchamarthy): Consultant – Data Architecture, Data Management & Engineering, USAA
- [Prasanna Bhat](https://himalayas.app/@prasannabhat1): Data Engineer, Lloyds Bank