# joshua mubia

joshua mubia is a remote worker on Himalayas, Data Analyst/ Data Architect at Pesuar Jobs International Consultancy LLC, based in Kenya.

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

```text
Experienced Data Architect specializing in data modeling and analysis.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Kenya |
| Authorized to work in | Kenya |
| Job categories | Data Architect, Data Analyst, Business Analyst, Database Architect, Big Data Architect |
| Skills | Data Analysis, Data Modeling, Data Architecture, SQL, Teradata, Hadoop, Oracle, Erwin, Informatica, Data Studio, MySQL, Bower, XML, Gemini, Data Warehouse, Excel |

## What I'm looking for

```text
I am seeking a challenging role that fosters innovation and collaboration, allowing me to leverage my data expertise to drive business success.
```

## About

```text
As a highly skilled Data Architect and Analyst, I have a proven track record in optimizing and migrating applications to the Azure cloud. My expertise lies in data modeling, data analysis, and data architecture, where I have successfully managed cloud solutions and improved security protocols. I am adept at utilizing various methodologies, including agile and waterfall, to ensure the successful execution of projects.

Throughout my career, I have participated in numerous Joint Application Design (JAD) sessions, gathering requirements and translating them into effective data warehouse designs. My experience spans across multiple industries, where I have developed logical and physical data models, performed data profiling, and implemented data transformation processes. I pride myself on my strong communication skills and my ability to lead teams to meet strict project deadlines while maintaining data integrity and consistency.
```

## Experience

### Data Analyst/ Data Architect

Pesuar Jobs International Consultancy LLC. May 2023 - May 2024

```text
Involved in solution scoping sessions to gather requirements, translating business needs into Data Warehouse designs. Conducted data profiling and analysis using Teradata SQL Analyzer, designed logical and physical data models, and oversaw data transformation processes.
```

Skills: Data-Analysis, Data-Profiler, Teradata, Data-Warehouse, SQL-Queries, JAD-Sessions, Data-Modeling, ETL-Applications, Documentation

### Lead Data Analyst/Modeler/Data Architect

DataSeal Software. Jan 2021 - Apr 2023

```text
Engaged with clients to gather requirements, performed data analysis across multiple sources, and designed dimensional models. Created logical models and documentation, resolved data inconsistencies, and coordinated with DBAs for implementation.
```

Skills: Data-Analysis, Dimensional-Models, SQL-Queries, Documentation, JAD-Sessions, Data-Mapping

### Lead Data Analyst/ Data Modeler/ Data Architect

Elimu Community Center. Apr 2022 - Feb 2023

```text
Led data analysis and modeling efforts, translating business requirements into data designs. Developed logical and physical data models, conducted testing, and maintained existing applications while ensuring data accuracy and performance tuning.
```

Skills: Data-Modeling, SQL-Queries, JAD-Sessions, Data-Mapping, SDLC, Documentation, Performance-Optimization, Data-Analysis

### Data Modeler/Architect

Dataseal Software. Mar 2017 - Dec 2020

```text
Interacted with business users to gather requirements and performed reverse engineering for data marts. Designed conceptual, logical, and physical data models, ensuring adherence to data naming conventions and standards.
```

Skills: Data-Modeling, JAD-Sessions, Reverse-Engineering, Dimensional-Data-Models, Documentation, SQL-Queries, Data-Marts, Business-Analysis, Oracle-Data-Modeler

## Education

### Pesuar Jobs International Consultancy LLC

Data Analyst/ Data Architect, Data Architecture. 2023 - 2024

```text
Involved in Initial solution scoping sessions with stakeholders to gather and understand requirements. Performed Data Profiling and Data Analysis on source data using Teradata SQL Analyzer. Designed and reviewed logical and physical data models for OLTP and OLAP in compliance with corporate standards.
```

### Elimu Community Center

Lead Data Analyst, Data Analysis. 2022 - 2023

```text
Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in various JAD sessions to gather requirements. Developed Business and Subject Area Logical Data Models, Physical Data Models, and Data Flow Diagrams. Extensively used Erwin to design Logical/Physical Data Models and wrote SQL Queries to profile databases.
```

### DataSeal Software

Lead Data Analyst/Modeler/Data Architect, Data Modeling. 2021 - 2023

```text
Interacted with clients to gather requirements in JAD sessions. Performed Data Analysis and generated various reports. Designed a STAR schema for sales data and created Logical Models while documenting all entities and attributes.
```

### Dataseal Software

Data Modeler/Architect, Data Architecture. 2017 - 2020

```text
Interacted with business users to gather requirements in JAD sessions. Designed and developed Conceptual, Logical, and Physical Data Models to meet reporting needs. Managed the flow of information between departments through relational databases.
```

## Tech stack

- Data Studio
- DB
- MySQL
- Hadoop
- Gmail
- Rollout
- Bower
- XML
- Gemini
- Microsoft Excel
- SQL

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

## People also viewed

- [Cynthia Koskei](https://himalayas.app/@cynthiakoskei): Data Analyst, Kenya Revenue Authority
- [Evans Yaran](https://himalayas.app/@evansyaran): Lead Data Analyst, Gilanis Distributors Ltd
- [Reinhard Nzomo](https://himalayas.app/@reinhardnzomo): Assistant Manager, Data Analytics & AI, Diamond Trust Bank
- [Mueke Mwangangi](https://himalayas.app/@muekemwangangi): Data Engineer/Architect/Analyst, Pathways Technologies
- [DANIEL MWANGI](https://himalayas.app/@ngahu): Data Engineer, Unknown
- [Seth Momanyi](https://himalayas.app/@sethmomanyi): Senior Data Engineer, Teleperformance Kenya Limited
- [Elvis Otwoma](https://himalayas.app/@elvisotwoma): Data Analyst, Cheqroom
- [Miriam Nganga](https://himalayas.app/@miriamnganga): Business Analysis Associate, Oracle
- [Elvis Otieno](https://himalayas.app/@elvisotieno): Data Architect/Modeler, DataSeal Kenya
- [James Mbugua](https://himalayas.app/@jamesmbugua2): Business Data Analyst, global analytic project
