Open to opportunities

Kevin Ongati

@kevinongati

Message

Data engineer specializing in metadata-driven ETL and dimensional modeling.

Kenya

Message

What I'm looking for

I am seeking a mid-level data role where I can design scalable data models and pipelines, work in Agile teams, contribute to CI/CD and governance, and grow within cloud/big-data environments.

I am a data engineer and data modeler with 2+ years designing and implementing physical data models and production-grade pipelines across banking, retirement planning, and insurance domains. I build metadata-driven ETL/ELT frameworks, automate ingestion/validation/loading, and create analytics-ready models using tools like ERStudio, SSIS, Git, CI/CD, and SQL/PL/SQL.

I have hands-on experience supporting modern cloud and big data ecosystems including Azure Synapse, Azure Data Factory, Databricks (PySpark/SparkSQL), Snowflake, and GCP BigQuery. I have delivered domain-federated enterprise data warehouses using the Medallion Architecture, implemented CDC/MDM strategies, authored source-to-target mappings and data dictionaries, and completed over 40 development stories for conformed silver-layer entities.

I collaborate closely with data modelers, solution architects, ETL/API teams and business stakeholders in Agile environments to deliver scalable pipelines, automated jobs, performance tuning and end-to-end documentation. I am committed to delivering maintainable, well-documented data solutions that support governance and downstream analytics.

Experience

Work history, roles, and key accomplishments

Current

Data Modeler | Data Engineer

Current

DataSeal Software Limited

Jan 2023 - Present (3 years 2 months)

Designed and implemented dimensional and physical data models and built metadata-driven ETL/ELT pipelines using Medallion Architecture to migrate and transform on-prem Oracle data into Azure Databricks and Synapse, delivering multiple LOB-specific data marts and 40+ modeled entities.

Dimensional Models Pyspark Databricks Azure Synapse Azure Data Factory SSIS ETL Data Modeling

Graduate Engineer

EnerPro Consulting Limited

May 2023 - Nov 2023 (6 months)

Conducted energy benchmarking and audits that identified potential energy savings up to 15% and recommended measures projected to reduce consumption by 10%, delivering actionable reports and cross-functional implementation strategies.

Report Writing Data Analysis

Engineering Intern

Rivatex East Africa Limited

Mar 2023 - May 2023 (2 months)

Performed mechanical installations and maintenance including aligning rollers and boiler inspections, improving equipment reliability and documenting findings that supported process optimization and a 5% production reliability gain.

Equipment Maintenance Inspections Technical Reporting Process Optimization Troubleshooting