Hire the Best Dataforma Specialists in Nairobi, KE

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.

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

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

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

👋 Data Analytics & Data Engineering | ETL • Power BI • SQL • Python • Data Governance Businesses don't struggle because they lack data. They struggle because their data is scattered across systems, manually reported, difficult to trust, or too complex to turn into meaningful decisions. 🚀 I help organizations build reliable data pipelines, automate reporting, create executive dashboards, and establish data governance practices that turn raw data into trusted business insights. Over the past 3+ years, I've worked across supply chain compliance, healthcare, real estate, marketing, finance, and technology, helping organizations improve data quality, streamline reporting, and build scalable analytics solutions that support better business decisions. 💡 How I Can Help 📊 Dashboards & Business Intelligence Design executive, operational, financial, and KPI dashboards. Build interactive reports using Power BI, Tableau, and Looker Studio. Improve dashboard performance, usability, and reporting consistency. ⚡ Data Pipelines & ETL/ELT Build automated data pipelines from APIs, databases, spreadsheets, and cloud platforms. Clean, transform, and prepare datasets for analytics and reporting. Optimize existing ETL workflows for reliability, scalability, and performance. 🐍 SQL, Python & Data Modeling Develop SQL and Python workflows for automation, transformation, and analysis. Build analytics-ready data models using dbt and dimensional modeling. Standardize KPI definitions to create a single source of truth across reporting. 🛡️ Data Quality & Governance Implement data validation, reconciliation, and quality monitoring. Develop data dictionaries, business glossaries, and technical documentation. Support metadata management, data lineage, classification, and governance initiatives using platforms such as Reltio, Collate, and Snowflake Horizon. ⭐ Recent Results ✔ Reduced executive reporting time by 40% through reporting automation. ✔ Improved ETL pipeline performance by 25% by redesigning and optimizing data workflows. ✔ Built Power BI dashboards that improved visibility into operational and financial performance. ✔ Developed healthcare and financial analytics solutions that transformed complex datasets into actionable insights. ✔ Designed scalable cloud-based data pipelines using BigQuery, Airflow, dbt, and Python for analytics and reporting. ✔ Contributed to the development of enterprise data governance standards and policies, and helped lead the successful Proof of Concept (POC) and implementation of Collate as the organization's data governance platform, improving metadata management, data discovery, and governance capabilities. 🛠 Technical Toolkit Data Engineering: SQL • Python • Apache Airflow • dbt • ETL/ELT • BigQuery • Snowflake • PostgreSQL Business Intelligence: Power BI • Looker Studio • Tableau • Excel Cloud: AWS • GCP Data Management: Data Modeling • Data Governance • Reltio • Collate • Snowflake Horizon ✅ Best-Fit Projects Power BI, Tableau, and Looker Studio dashboards ETL/ELT pipeline development and automation SQL optimization and reporting automation Python data extraction, transformation, and API integrations dbt modeling and data warehouse development Data quality assessments and reconciliation Data governance, metadata, lineage, and documentation 🤝 I enjoy working with teams that want more than reports—they want reliable data they can confidently use to make decisions. 📬 If you're looking for someone to build scalable data pipelines, automate reporting, improve data quality, or strengthen your analytics and governance practices, I'd be happy to discuss your project and help identify the best approach.

I help companies go from scattered data and inconsistent reporting to a reliable, scalable analytics layer built on Google Cloud Platform, powered by dbt, and delivered through Looker. For long term projects, happy to offer a FREE 1 week period of work, let's call it probation period. My results are faster queries, trusted metrics, and dashboards that business teams actually rely on. Let's have a free 30 mins call to discuss your needs, possibilities and data challenge. I'm Peter , a Top Rated Plus (top 3%) Certified Data Engineer (+ Analytics Engineer) with over 9 years of experience transforming complex data into actionable insights for global clients and start ups across finance, hospitality, SAAS, eCommerce, and tech. I specialize in building scalable data solutions that reduce costs, accelerate decision-making, and unlock new revenue streams. My experience: - Worked with leading organizations like KPMG, Savings United, IU Group, aleno, Andela, and the World Bank to define, maintain and optimize their data solutions. - Cut data processing time and operational costs by 20 percent through optimized pipelines and optimized queries and data storage techniques. - Helped a hotel SaaS platform unlock a new revenue stream via client-facing analytics leading to a paid embedded dashboard revenue stream. - Built and tracked KPIs that improved business steering and day-to-day execution delivered timely, cheaply and reliably. Tech & Tools I work with: GCP (BigQuery, Cloud Functions, Cloud scheduler, Cloud Logging, IAM, Compute Engine, Billing and optimization), AWS, Looker (Semantic layer, LookML,Looker API, administration, migration, setup, training, costs, looker embed, pdts), Power BI, Alteryx, dbt, dlt, Python, SQL, REST APIs, Airbyte, Airflow, Docker Some of my Certifications: Project Management Professional (PMP) - Project Management Institute (PMI) Google Cloud Professional Data Engineer Responsible AI with Google Cloud Generative AI Fundamentals – Google What I Deliver: - Automated, scalable pipelines to replace error-prone manual processes - Insightful dashboards and metrics that fuel performance and decision-making - Machine learning integrations and fraud detection solutions - Clear, timely communication and documentation - Google Looker setup, development, optimization and administration - Collaboratively leading agile teams towards accurate, timely and impactful data solutions. Clients consistently rate my work 5 stars for delivering high-quality, high-impact data solutions with a collaborative mindset. Whether you need a short-term fix or a long-term data strategy partner, I bring enterprise-grade quality to the Upwork platform. Let’s connect and discuss how I can help you leverage your data for strategic advantage.