Lead Business Intelligence Engineer
Nairobi, Kenya
Provided a vertical bridge through the business to communicate information of high value to support decision-making demands. Develops policies & procedures for the collection & analysis of data. Performs data administration, modeling, & integration activities in data warehouse systems. Implements Business Intelligence solutions to achieve data reporting & analysis goals. Supports the development of business intelligence standards to meet business goalsDocumented & maintained BI documentation, training materials, best practices, & overall data toolkitBuilt models to identify trends, forecast performance, & identify improvements to company strategy, products, & operationsDesigned & created dashboards for managerial & executive teams. Collaborated with operation teams to examine data sources, identify connections & design reports that will drive change managementUsed ETL (SSIS & Data Pipelines) to develop jobs for extracting, cleansing, transforming, & loading data (spanning over 20 years) into a data warehouseDesigned analytics reports using Power BI, Custom web charts & SQL Server Reporting Services (SSRS)Developed, customized & managed data engineering processes, databases (SQL & NoSQL), data lakes, data marts & business intelligence systems which drove the organization’s strategic initiativesEngineered the organization’s data warehouse infrastructure using (SQL Server Analysis Services, SSAS) & Azure Analytics tools, integrating data from various systems (ERP – Dynamics NAV, Business Central, Dynamics CRM, Human Resource Management HRM, Field Service Management, Social Media & Document Management)Managed over a million sales conversion deals & KShs. 30 Billion shillings in revenue by designing & tracking KPI metrics & scorecardsGenerated data analysis reports for the Sales, Marketing, Finance, Logistics & Transport, Human Resources, Field Service, Production & Manufacturing departments to analyze & accelerate operational & strategic efficiencies