Hire the Best Dataforma Specialists
in Kenya

To obtain success by benefiting your organization through utilizing my education, achievements, skills, strategic thinking and leadership abilities. To be optimistic, thrive on challenges to ensure the attainment of the organizational goals. * IT professional with strong background in Data Analytics and Data Modeling. * Expert in Data Architect role and in tools such as MS SQL Server, Oracle, DB2 * Experienced in Data Modeling concepts such as conceptual, logical and physical data models * Experienced in major Data Modeling tools such as Erwin, IBM Info-sphere Data Architect, and ER Studio. * Experienced in information and requirements gathering sessions * Very good knowledge in generating SQL scripts and implemented the relevant databases with related properties * Involved in all hops in the end to end data life cycle that included analyzing source systems, creating and maintaining the ODS layer, creating and modeling both the EDW and Analytical using star schema and snowflake schemas and generating various adhoc and canned reports and extracts * Experienced in AWS and in creating Data Lakes for various Big Data projects running in Hadoop and AWS Environments: IBM Infosphere Data Architect, Snowflake, AWS Redshift Spectrum, AWS S3, AWS Glue, AWS Cloud Formation, SQL Server, IBM Data Stage, Tableau, Snowflake, Power BI, data vault 2.0

Hi, I'm Ian – a Data Engineer specializing in building reliable, scalable data pipelines and e-commerce integrations that drive business growth. With 3+ years of experience developing data solutions for e-commerce businesses, I help companies automate their operations, synchronize marketplace data, and gain actionable insights from their data. My technical expertise in Python, SQL, and AWS, combined with my understanding of e-commerce operations, allows me to deliver solutions that directly impact revenue and efficiency. How I can help you: Custom API Integrations: Connect your business with marketplaces, drop shippers, and third-party services through automated, reliable integrations ETL Pipeline Development: Build robust data pipelines that transform raw data into valuable business insights Order Management Systems: Develop automated systems that synchronize orders across platforms with real-time notifications Database Optimization: Improve query performance and data processing speeds through strategic indexing and optimization Business Intelligence Solutions: Create dashboards and analytics platforms that visualize KPIs and drive decision-making Recent achievements: Reduced data processing times by 75% through PostgreSQL optimization Increased sales by 15% with a custom marketplace integration platform Improved fulfillment speed by 99% with an automated order management system Reduced manual data processing time by 60% with AI-powered tools My Skills And Favorite Tools: Data Engineering ETL Pipeline Development API Integrations e-Commerce Systems Python (FastAPI, Flask) PostgreSQL AWS Cloud Services Airflow Data Warehousing Business Intelligence Database Optimization MongoDB NoSQL Databases PowerBI, Apache Superset I approach every project with a focus on delivering business value through technical excellence. Let's discuss how data engineering can help solve your biggest business challenges. less

5+ years of experience 📞 Excellent Communication 🕛 Full Time Availability 🚀 Top Rated Plus 🏅 Certified Data Visualization & Engineering Expert I help businesses turn raw data into powerful dashboards, streamlined workflows and actionable insights. What I offer: - Dashboard Development: Looker Studio, Looker, Microsoft Power BI (DAX & Power Query), Tableau, Metabase, AWS Quicksight, Google Data Studio, LookML - Data Engineering & Transformation: ETL pipelines, SQL & Python scripting, dbt, Snowflake, Google BigQuery, - Data Reporting - Google Analytics, GA4, Jet Admin, Superset, Redash, Retool, Domo, Klipfolio, Periscope, Grafana, Sisense, AirTable, Grow, etc. Growth Metrics. Shopify Reports, E-commerce Reports, etc - Automation & Integration: API-based workflows, Zapier, Google Apps Script - Forecasting & Analysis: Trend analysis, business reporting, performance tracking Technical Skills: - BI Tools: Looker Studio, Power BI, Tableau, Google sheets, Metabase, AWS Quicksight, LookML, - Languages: SQL, Python (Pandas, NumPy), JavaScript - Databases: Snowflake, Google BigQuery, PostgreSQL, MySQL - Workflow Automations: n8n, Make.com, Dagster, Airflow - Cloud & Automation: AWS, Zapier, API integrations I've delivered 100+ data projects across healthcare, finance and tech, including for global firms like Roche and data-first startups. My focus is on creating scalable, insightful solutions that save time and drive better decisions. Let’s work together to unlock the full value of your data. 📩 Message me to discuss your project. Keywords: Best Looker Studio Expert and Dashboard Specialist Freelancer, Looker Studio, LookerML, Google Data Studio, Google Looker Studio, Dashboards, Dashboard Specialist, Dashboard Design, Data Visualization, Interactive Dashboards, Visual Reporting, Financial Reporting, Google Sheets, GA4, Google Analytics 4, GTM, Google Tag Manager, Data Analytics, Data Analysis, Data Insights, Business Intelligence, BI, Analytics, Data Driven, Data Storytelling, Data Reporting, KPI, Metrics, Performance Management, SQL, BigQuery, Snowflake, ETL, Data Engineering, Cloud Analytics, Business Analysis, Analytics Consultant, Visualization Expert, Data Analytics Expert, Freelance Data Analyst, Self Service BI

I help organizations transform raw data into reliable reporting, analytics, and decision-support systems. My background combines Data Engineering, Analytics Engineering, and Monitoring, Evaluation & Learning (MEL) analytics. I design end-to-end data workflows that collect, process, transform, and visualize data to support operational and strategic decision-making. I have experience building production-style data solutions including automated ETL/ELT pipelines, PostgreSQL data warehouses, workflow automation systems, KPI reporting frameworks, and Power BI dashboards. Technical Expertise • SQL (Advanced Queries, CTEs, Window Functions, Query Optimization) • PostgreSQL • Python (Pandas, NumPy) • Airflow • dbt • Docker • Power BI • Data Warehousing • ETL / ELT Pipelines • API Integrations • Workflow Automation (n8n) • KoboToolbox Data Systems Services I Provide ✓ Data Pipeline Development ✓ ETL / ELT Workflow Automation ✓ PostgreSQL Database Design ✓ SQL Development & Optimization ✓ Data Warehouse Design ✓ Power BI Dashboard Development ✓ Monitoring & Evaluation (MEL) Reporting Systems ✓ KoboToolbox Data Processing & Reporting ✓ Automated Data Collection & API Integration ✓ Business Intelligence Solutions Selected Project Experience • Food Security Intelligence Pipeline Designed and deployed an automated humanitarian intelligence platform that ingests KoboToolbox survey submissions, processes vulnerability indicators, stores structured data in PostgreSQL, and generates operational alerts and reporting outputs. • Youth Employment MEL Analytics System Built a monitoring and evaluation database system using PostgreSQL and SQL analytics to assess employment outcomes, measure program impact, compare treatment and control groups, and generate donor-reporting indicators. • Data Warehouse & Analytics Engineering Projects Developing modern ELT architectures using Airflow, dbt, Docker, PostgreSQL, and object storage to support scalable reporting and business intelligence workflows. I focus on building solutions that are accurate, maintainable, scalable, and aligned with real operational needs. Whether you need a reporting dashboard, automated data pipeline, SQL optimization, or a complete analytics platform, I can help transform your data into actionable insights.

Drowning in fragmented data and manual reporting? I build automated data pipelines, rigorous statistical models, and objective dashboards that replace the chaos. My goal is to deliver a single source of truth, giving your team reliable, real-time insights you can confidently act on. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 𝗪𝗵𝗮𝘁 𝗜 𝗗𝗲𝗹𝗶𝘃𝗲𝗿 → ⚙️ Data Engineering & Automation ⟶ Architecture & Pipelines (ETL/ELT): Designing end-to-end automated pipelines using Microsoft Fabric, Python, Apache Spark, and dbt to integrate messy data from ERPs, CRMs, APIs, and flat files. ⟶ Warehousing & Orchestration: Building scalable Lakehouses/Warehouses and automating workflows to eliminate manual data entry and reduce human error. → 📊 Business Intelligence & Dashboards ⟶ Enterprise Reporting: Building high-performance, user-focused dashboards in Power BI, Tableau, and Apache Superset that prioritize clean, objective data visualization. ⟶ Performance Optimization: Auditing and speeding up slow, bloated Power BI reports using DAX Studio, Tabular Editor, and Measure Killer. → 📈 Statistical Analysis & Research ⟶ Advanced Analytics: Moving beyond "what happened" to "why it happened" using R and Python for hypothesis testing, A/B analysis, and predictive modeling. ⟶ Exploratory Data Analysis (EDA): Deep-diving into complex datasets to uncover hidden patterns, delivering findings via reproducible reports (RMarkdown) or interactive web apps (R Shiny). ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🔗 𝗧𝗼𝗼𝗹𝘀 & 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲𝘀 Power BI (advanced DAX, Power Query, semantic modeling, DAX Studio, Tabular Editor, Bravo, Measure Killer) · Microsoft Fabric · Python · R · SQL · dbt · Soda Core · Elementary · Apache Airflow · Dagster · Airbyte · Prefect · Containers & Orchestrators (Docker, Git/GitHub, CI/CD) · Tableau · Azure · ClickHouse · PostgreSQL · MySQL · APIs · AI Agentic Development · Microsoft Excel / Google Sheets · PySpark, SparkSQL, SparkR ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 ✅ Microsoft Fabric Data Engineer (DP-700) ✅ Microsoft Fabric Analytics Engineer (DP-600) ✅ Microsoft Power BI Data Analyst (PL-300) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ I combine data modeling best practices with a commitment to objective, truth-revealing visualization. I deliver projects on time, meticulously documented, and ensure clear communication from day one. I would love to hop on a quick call to discuss your project. The first consultation is on me!

In the last 6 years I've helped SaaS, fintech, and e-commerce companies go from broken spreadsheets and siloed data to pipelines that actually run and dashboards that actually get used. Most recent wins: → Compressed BI delivery by 75% at 1Touch (5–10 dashboards per sprint vs one per quarter) → Reduced reporting turnaround by 43% at FieldPro → Cut warehouse costs by 20% by refactoring dbt models from full-refresh to incremental at Optimetriks → Boosted e-commerce conversion by 37% at Mamap Life My stack: Python · SQL · dbt · BigQuery · Snowflake · Apache Airflow · Airbyte · Looker Studio · Tableau · Power BI · Docker · GCP · AWS · Azure . Databricks I work fully remote and have done since 2020 async delivery, clear communication, and no hand-holding required. If you need a pipeline built, a warehouse migrated, or a reporting layer that doesn't break every time the data changes, let's talk.