# Joshua Mwaura

Joshua Mwaura is a remote worker on Himalayas, Senior Data Architect at Johns Hopkins Hospital, based in United States.

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

```text
Senior Data Architect and Data Modeler driving enterprise data modernization and compliance.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Data Architect, Data Modeler, Data Engineer, ETL Developer, Analytics Engineer, Data Warehouse Developer, BI Analyst Developer, Metadata Specialist, Cloud Data Engineer, Enterprise Data Architect, Database Architect, Big Data Architect, Data Pipeline Architect, Cloud Data Solutions Architect |
| Skills | Tailwind, Data Warehouse, OMOP, IBM UDMH, ETL, Apache Spark, Azure Data Factory, Databricks, Snowflake, Azure Synapse, Matillion, Data Modeling, Power BI, Erwin, SQL, Python, AWS, GCP, Data Lake, Pl SQL, Data Governance, MySQL, SAS, Temporal, XML, Dat, Erwin Data Modeler |

## What I'm looking for

```text
I seek senior-level roles building scalable enterprise data platforms using cloud and modern analytics stacks, with strong collaboration, governance, and regulatory focus.
```

## About

```text
I am a seasoned Senior Data Architect and Data Modeler with over a decade designing, modeling, and implementing enterprise data solutions across healthcare, banking, and insurance sectors. I specialize in architecting large-scale enterprise data warehouses, building ETL/ELT pipelines, and standardizing complex clinical and financial data into industry models such as OMOP CDM and IBM UDMH.

My hands-on experience includes Azure, AWS, GCP, Databricks, Snowflake, Synapse, Matillion, and ADF, and I have developed Spark applications, implemented data lakes, and created mapping strategies for complex lab and claims data. I lead end-to-end initiatives covering logical, physical, and dimensional modeling, metadata management, governance frameworks, and regulatory-compliant reporting solutions.

I collaborate closely with business analysts, DBAs, ETL developers, and stakeholders to translate requirements into scalable, reusable data models and production-ready pipelines that drive operational efficiency, regulatory reporting, and advanced analytics.
```

## Experience

### Senior Data Architect

Johns Hopkins Hospital. Jan 2024 - Jan 2025

```text
Architected EDW using IBM UDMH and OMOP mappings to standardize clinical and claims data, created ETL/ELT pipelines with Azure Data Factory and Databricks, and implemented mappings for 800+ lab tests using LOINC to support regulatory reporting and analytics.
```

Skills: Data-Modeling, OMOP, IBM-UDMH, Azure-Data-Factory, Databricks, Power-BI, ETL

### Data Modeler

Flagstar Bank. Jan 2022 - Jan 2023

```text
Designed and built Azure Stream Analytics ingestion and Databricks-based ETL pipelines for a 20+ TB environment, implemented indexing/partitioning strategies, and created ADF orchestration and CI/CD for production data engineering workloads.
```

Skills: Azure-Stream-Analytics, Azure-Data-Factory, Databricks, Python, Azure-Synapse, Data-Modeling

### Data Modeler/Architect

SunTrust. Jan 2017 - Jan 2019

```text
Translated business requirements into logical and physical data models using Data Vault and maintained LDMs and source-to-target mappings, supporting reporting data warehouse development and PL/SQL-based integrations.
```

Skills: Vault, Data-Modeling, Erwin, Pl-SQL, ETL, Source-To-Target-Mapping, SDLC, Data-Warehouse

### Data Modeler

Presbyterian Medical Center. Jan 2015 - Jan 2016

```text
Mapped Epic and Cerner clinical data into OMOP CDM and migrated analytical tables from Netezza to Snowflake, designing ETL processes and validating models with SAS scripts to preserve clinical context and temporal relationships.
```

Skills: OMOP, Snowflake, Netezza, ETL, Erwin, SQL, SAS

### Data Analyst

[American Family Insurance](https://himalayas.app/companies/american-family-insurance). Jan 2014 - Jan 2015

```text
Performed data analysis and modeling for insurance reporting, created star schemas and logical models, generated DDL and materialized views, and coordinated with DBAs to implement solutions across Oracle and DB2 sources.
```

Skills: Data-Analysis, SQL, Oracle, DDL, Reporting

## Education

### Western Governors University

Master of Science, Computer Science. 2022 - 2025

```text
Completed a Master's degree in Computer Science focused on advanced computing concepts and practical applications.
```

### Kenyatta University

Bachelor of Science, Computer Science. 2009 - 2012

```text
Completed a Bachelor's degree in Computer Science covering core programming, data management, and systems concepts.
```

## Tech stack

- Matillion
- SAS
- dat
- MySQL
- Tailwind CSS
- Databricks
- XML
- erwin Data Modeler
- SQL
- Temporal
- Transform

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

## People also viewed

- [Hazzy M](https://himalayas.app/@hazzym): Data Solution Architect, ApTask
- [Mobeen Butt](https://himalayas.app/@mobeenbutt): Data Solution Architect, ApTask
- [Benjamin A-](https://himalayas.app/@benjamina-): Data Solution Architect, Mountainise
- [Ramon A](https://himalayas.app/@ramona): Senior Data Solution Architect, Consignor Connect
- [Taylor Franklin](https://himalayas.app/@taylorfranklin1): Data Solution Architect, SpireDigital
- [Ken Odegard](https://himalayas.app/@kenodegard): Data Solution Architect, Benchling
- [Junaid Raza](https://himalayas.app/@junaidraza1): Data Architect, Effectual
- [Khateja Begum](https://himalayas.app/@khatejabegum): Sr. Data Engineer, AssistRx
- [Madhav Ghimire](https://himalayas.app/@madhavghimire1): Sr. Data Architect, U.S. Department of Housing and Urban Development (HUD)
- [Joshua cook](https://himalayas.app/@joshuacook): Senior Data Architect, Johns Hopkins Hospital
