Open to opportunities

Joshua Mwaura

@joshuamwaura

Message

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

United States

Message

What I'm looking for

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

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

Work history, roles, and key accomplishments

Senior Data Architect

Johns Hopkins Hospital

Jan 2024 - Jan 2025 (1 year)

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.

Data Modeling OMOP IBM UDMH Azure Data Factory Databricks Power BI ETL

Data Modeler

Flagstar Bank

Jan 2022 - Jan 2023 (1 year)

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.

Azure Stream Analytics Azure Data Factory Databricks Python Azure Synapse Data Modeling

Data Modeler/Architect

SunTrust

Jan 2017 - Jan 2019 (2 years)

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.

Vault Data Modeling Erwin Pl SQL ETL Source To Target Mapping SDLC Data Warehouse

Data Modeler

Presbyterian Medical Center

Jan 2015 - Jan 2016 (1 year)

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.

OMOP Snowflake Netezza ETL Erwin SQL SAS

Data Analyst

American Family Insurance

Jan 2014 - Jan 2015 (1 year)

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.

Data Analysis SQL Oracle DDL Reporting