Responsibilities:-Building and maintaining data warehouses, setting up pipelines, and deploying models while ensuring data is securely and readily available to internal and external stakeholders-Identifying, designing, and implementing internal process improvements, including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.-Building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Looker, and BigQuery.-Working with data and technology while assisting with data-related technical issues and supporting data infrastructure needs while ensuring compliance with data governance and security policies.-Providing assistance with the development and management of continuous integration, continuous delivery, and continuous testing pipelines for machine learning and other model iterations for customers.-Maintaining comprehensive documentation for data engineering processes, workflows, and solutions.-Analysing large datasets to identify trends, patterns, and correlations relevant to our clients’ business objectives.-Developing and maintaining data models, algorithms, and statistical analyses to support decision-making processes.-Collaborating with cross-functional teams to gather requirements and define data-driven solutions.-Designing and implementing data visualisation dashboards and reports to communicate findings effectively.-Performing data cleansing, transformation, and validation to ensure data accuracy and consistency.-Staying current with industry trends and best practices in data analysis, cloud computing, and related technologies.-Supporting ongoing data-related projects and initiatives, including data migration, integration, and optimisation efforts.

Key Achievements• Designed and developed data warehouses consolidating data from 100+ sites by creating pipelines for processing datasets from web traffic, social media, and advertising platforms, pushing the data to MySQL and Postgres Databases and Cloud buckets (Google, AWS) and moving the data from the data lakes to data warehouses for analysis on Google Big Query, Redshift or DBT.• Utilizing Python’s Prefect, Mage and Airflow for orchestration in the mentioned pipelines dependingon the specific requirements, infrastructure, and familiarity of the team with the tool.• Designed and implemented social media, web and mobile performance dashboard using Google Data Studio and Power BI analysis tool.• Led 100+ migration of on-premises data warehouse to Big Query/Redshift, optimizing query performance and reducing data processing times• Utilized DBT (Data Build tools) for Analytics engineering by transforming, testing, deploying, and documenting data for end users and using version control and continuous integration to the analytics code base• Assisted in implementing unified batch and real-time event processing systems using Apache Spark and Kafka

Key Achievements • Designed and Implemented program performance dashboard using Power BI. • Capacity building Data Management Unit on the use of Power BI to perform data visualization and analysis. • Capacity building of M&E staff on the use of Excel and access-based databases for query and validation checks.• Generating SQL and MySQL EMR scripts for data extraction used for reporting• Implementation of eHealth solutions in 104 sites out of 109 sites with 78 using EMR at Point of Care.• Integration of Power BI with QGIS to describe geo visuals for epidemic control. • 100% reporting and pushing of data to the National Data Warehouse of all EMR sites

•Collaborated in developing and maintaining the Blissful web application platform using the Laravel PHP framework to link service providers and customers•Created dynamic and interactive user interfaces such as landing pages and email marketing campaigns using HTML, CSS, JavaScript, and React.js.•Integrated third-party APIs, such as payment gateways and social media platforms, to extend application capabilities using Google Analytics API to monitor user interactions on the web app for informed decision-making and advertising, PesaPal payment API for payment processing, AfricasTalking SMS gateway for user instant user messaging•Designed and optimized the web application relational database schemas using MySQL and interfaced it using PHP my admin for easy database management.•Regularly conducted code reviews and contributed to improving coding standards and best practices.•Deploy the web application applications using GitLab CI/CD tool on DigitalOcean and image storage on AWS buckets

Enterprise Business Unit (Strategy & Business Development Department)Customer experience deskTransformation teamContract Management

Exposure to real world of health Information Technology through select short guest lectures and health facility site tours.Interaction with leading health leaders and techies in HITLearn practical health information system software development skills for development in KenyaEMR, DHIS2 and MFL platforms.