Michael Dairo

Experience

• 

  Edi-Jen Group

  Sept 2019 - Sept 2022

  BI & Data Engineer

  Developed and launched a database to track and manage credit sales data, streamline reporting processes, and reduce data retrieval times by 70% across the organization.Created Excel VBA process automation scripts that save approximately 45 minutes of process time and reduce errors by limiting human interaction by 100%.Analyzed sales data and built user-friendly sales dashboards using MS Excel and PowerBI improving data-driven decision-making process.

• 

  Kibo School

  Oct 2022 - Aug 2024

  Collaborated with a team to design a data model for students’ academic data and implemented automated ETL processes for moving academic data from multiple sources into a Postgres database leveraging APIs.Analyzed students’ academic data and built academic dashboards using Looker Studio with KPIs to help instructors, student advisors, and administrators understand the performance of 100+ students, drive actions, and support decision-making.Developed and optimized complex SQL queries to transform raw data into actionable insights reducing query time by 30%. Show less Developed and launched a custom application & admissions portal to process 3000+ applications using Airtable, Make, Zapier, and WeWeb.Built a Students’ Information System to serve 100+ students giving them access to their academic performance data and key administrators an overview of students’ performance using Airtable, Make, Zapier, and WeWeb.Developed and launched custom tools by integrating low-code/no-code tools and services to streamline workflows and processes and improve operational efficiency with appropriate documentation and usage videos.Designed and implemented an Automation Assistants Training Program that trained 40+ university students to become workflow automation specialists. Show less

  • Data Engineer

    Oct 2022 - Aug 2024

  • Automation Specialist

    Oct 2022 - Aug 2024
• 

  ExamRoom.AI®

  Jan 2025 - now

  Data Engineer