Profile Details

Create Project

★★★★★

☆☆☆☆☆

USD 35 /hr

★★★★★

☆☆☆☆☆

Hire Wilfred K.

United States

USD 35 /hr

Ms Data Engineer with two years' experience in designing, building, and optimizing end-to-end data pipelines.

Profile Summary

With a strong foundation in real-time data integration, event-driven architectures, and analytics engineering, I bring data to life with comprehensive dashboards and actionable insights. Core Skills and Expertise: Microsoft Fabric Ecosystem: Expertise in Real-Time Intelligence Eventstream, Dataflow Gen2, Lakehouses, and KQL-based analytics. Real-Time Data Streaming: Integration of Apache Kafka (configured via Docker) with Microsoft Fabric to enable live data ingestion and processing. Data Transformation: Proficient in Power Query, KQL, and Python for transforming and analyzing raw data into actionable formats. End-to-End Analytics Projects: Experienced in connecting streaming pipelines to Power BI, creating dynamic dashboards to visualize live data, and generating business-critical insights. API Integration: Seamlessly integrating APIs like Mexc API into data pipelines to capture and process live market data. Cloud & Containerization: Hands-on with Docker, AWS S3, and Azure Synapse, ensuring scalable and efficient data workflows. Notable Projects: 1. Real-Time Market Data Pipeline: - Ingested live market data from the Mexc API into a Kafka topic and processed it with Microsoft Fabric Real-Time Eventstream. - Built a Power BI dashboard displaying key market metrics like price movements, trade volumes, and trends. 2. E-Commerce Data Warehouse: - Designed and implemented a data warehouse to consolidate multiple e-commerce data sources using APIs. - Optimized queries and integrated with Power BI for a robust analytics solution. 3. Global CO2 Emissions Tracker: - Developed an end-to-end pipeline for analyzing global carbon emissions data. - Used Microsoft Fabric Lakehouses for storage and KQL for analytics, visualized trends with Power BI. Why Work with Me? - Problem Solver: I thrive on turning complex data challenges into streamlined, automated solutions. - Detail-Oriented: I ensure all aspects of the pipeline are optimized, from API integration to data visualization. - Collaborative Approach: I value open communication and adapt quickly to your unique project needs.

Subject Matter Expertise

• ★ Big Data Analytics
• ★ Python
• ★ SQL
• ☆ Data Analysis
• ☆ Predictive Modeling & Analytics
• ☆ Data Processing
• ☆ Data Exploration
• ☆ Cluster Analysis
• ☆ Data Visualization
• ☆ Data Management
• ☆ Data Manipulation
• ☆ Data Mining
• ☆ Data Cleaning
• ☆ Data Architecture
• ☆ Business Analytics
• ☆ Statistics
• ☆ Regression Analysis
• ☆ Correlation Analysis
• ☆ Trend Analysis
• ☆ Pure Mathematics
• ☆ Excel
• ☆ R
• ☆ Tableau
• ☆ Scikit-learn

Services

• Writing
• Research
• Consulting
• Data & AI

Writing Technical Writing

Research Market Research, User Research, Feasibility Study

Consulting Business Strategy Consulting

Data & AI Statistical Analysis, Data Visualization, Big Data Analytics, Data Mining, Data Cleaning, Data Processing

Work Experience

Ms Fabric Data Engineer

Digital Qatalyst

January 2025 - Present

Payroll Analyst

Cyka Manpower Sevices Limited

March 2021 - Present

Education

B.Sc Financial Engineering

Jomo Kenyatta University of Agriculture and Technology

September 2014 - November 2018

BSc Financial Engineering (Statistics And Applied Sciences)

Jomo Kenyatta University of Agriculture and Technology

August 2014 - November 2018

Certifications

• Google Analytics IQ Certification

  Google Inc.

  December 2022 - Present

Publications

REPORT

Tableau Dashboard .