Hi there,
I am a Data Architect and Data Modeler based in Kenya, focused on designing reliable, scalable, and well-structured data systems that power analytics and business decision-making.
I specialize in transforming raw, complex data into clean and usable datasets that support reporting, insights, and data-driven decisions across organizations.
My work spans the full data lifecycle — from raw data ingestion to curated analytics layers — with a strong emphasis on data quality, consistency, and usability.
- Design dimensional data models using kimballs datawarehousing technique for analytics and reporting
- Build and maintain medallion architecture pipelines (Bronze, Silver, Gold layers)
- Clean, transform, and standardize data from multiple sources into consistent business definitions
- Translate business requirements into structured data solutions and reporting datasets
- Support BI development by preparing optimized datasets for tools like Power BI
Languages & Tools
- SQL/No SQL
- Python
- Power BI, Excel
- DBT
Data Engineering Concepts
- Data Warehousing
- Star Schema Design
- ETL / ELT pipelines
- Data Quality & Validation
- I currently work as Data Modeller/Data Architect at ArtSam Technologies
Focused on designing data warehouses, dimensional models, and analytics-ready datasets that support reporting and business intelligence.
- Data Engineering and Analytics Engineering
- Building clean and scalable data systems
- Improving data quality and trust in reporting systems
Email: carsonallan71@gmail.com
Medium: https://medium.com/@carsonallan71
LinkedIn: Visit Example