Jonathan Kiprono

Data Pipeline Deployment & Optimization - Designed and deployed automated data pipelines
to integrate and ensuring real-time synchronization and consistency of analyzed security
logs.
• Data Warehouse Development - Contributed to the design and implementation of a
centralized data warehouse, enabling advanced analytics and improved decision-making
across ministries onboarded.
• ETL/ELT Workflows - Built and maintained ETL processes to extract, transform, and load
structured and unstructured data from APIs, databases, and external systems into reporting
layers.
• Data Security & Compliance - Implemented secure data frameworks, VPNs, and access
control measures to ensure data confidentiality, integrity, and compliance with government
regulations.
• Data Reporting & Insights - Developed reporting pipelines and dashboards to track service
usage reducing inefficiencies and improving service delivery.
• Cybersecurity Awareness - Researched and applied best practices in data security to protect
citizen data, mitigate threats, and enhance resilience against cyberattacks.

• Collaborated with development teams to design database structures aligned with project
need
• Developed and maintained data warehouses by modelling schemas and optimizing queries to
support business intelligence and advanced analytics.
• Implemented data validation and quality checks to ensure accuracy, consistency, and
reliability across staging, transformation, and production layers.
• Built and monitored dashboards for pipeline performance, system health, and data usage
metrics, enabling proactive troubleshooting and optimization.
• Optimized and implemented data collection systems to enhance statistical efficiency and data
quality using AWS services such as AWS lambda, AWS S3, AWS Athena, AWS IAM, and Aws
EC2, leveraging Python and SQL for data manipulation and orchestration.
• Provided support for database systems, including installation, configuration, and
maintenance of MySQL and PostgreSQL databases.
• Designed and implemented ELT workflows to streamline data processing and integration.
Utilized tools like Apache Kafka and Apache Airflow to manage data pipelines and ensure
real- time data flow.