Amazon logoCurrently an Extern @Amazon·🟢 Open to work
Jemilah Damilola Alao portrait

Data Analyst | People Analytics & Operational Strategy

Data & Business Intelligence Analyst Turning data into practical business and workforce insights Excel • SQL • Power BI • Python | Operations • People Analytics

View my workMessage Me

Work samples

I use data to help businesses understand people, processes, and performance. I’m driven by curiosity, problem-solving, and turning messy data into practical insights for better decisions.

  • Amazon Operational Strategy & People Analytics Externship
    Amazon Operational Strategy & People Analytics Externship
    Amazon logo

    Amazon · Aug 2026 · ✅ Verified by Extern

    Amazon Operational Strategy & People Analytics Externship

    Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

    Data AnalysisPythonStrategyOperations
  • Sales Review Analysis (Excel)
    Sales Review Analysis (Excel)

    Restructured a 1,621-row dataset across linked tables using VLOOKUP, XLOOKUP, and INDEX; built an interactive dashboard with slicers for state and category to surface KPI trends.

    VLOOKUPXLOOKUPINDEXExcelPivot Tables

About me

Data & Business Intelligence Analyst Turning data into practical business and workforce insights Excel • SQL • Power BI • Python | Operations • People Analytics

I’m a Data & Business Intelligence Analyst with a background in Agricultural Science and hands-on operations experience. Managing breeder, broiler, and hatchery operations strengthened my skills in performance monitoring, process improvement, and operational decision-making. I’ve since moved into analytics, using Excel, SQL, Power BI, and Python across projects in sales, e-commerce, employee analytics, and operations. I’m also a Women in AI Fellow.

Externships

Amazon Operational Strategy & People Analytics Externship

Amazon

Experience

Women in AI Fellow

Webfala Digital Skills for All Initiative (Onsite) · Apr 2026 — Present

Data Analyst Intern

TechCrush (Remote) · Dec 2025 — Mar 2026

Operations Lead

Tuns Farm Nigeria Limited (Onsite) · Mar 2023 — Nov 2025

Education

University of Ilorin, Kwara State, Nigeria

B.Agriculture, Second Class (Upper Credit) · Class of 2022

Skills

Data AnalysisSQLExcelPower BIPythonBusiness IntelligenceData VisualizationCritical ThinkingProblem SolvingWorkforce Data AnalysisSentiment AnalysisData Storytelling
Back to works
Amazon · Aug 2026 ↗

✅ Verified by Extern

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

Data AnalysisPythonStrategyOperations

Overview

In this externship, I focused on enhancing employee retention at Amazon by analyzing workforce data and employee feedback. By exploring the structures and operations of fulfillment centers, I aimed to improve the onboarding experience for new hires, ensuring they feel welcomed and valued from the start. My work contributed to developing strategies that align with Amazon's commitment to an

Amazon Operational Strategy & People Analytics Externship
Google Sheets
Access

What I've accomplished

I produced a CSV-style workforce map of fulfillment-center roles and an evidence-backed set of evaluated employee-review examples that identify features of strong employee voice.

Project breakdown

View all works
Back to works

Sales Review Analysis (Excel)

Restructured a 1,621-row dataset across linked tables using VLOOKUP, XLOOKUP, and INDEX; built an interactive dashboard with slicers for state and category to surface KPI trends.

VLOOKUPXLOOKUPINDEXExcelPivot Tables
View all works
Back to works

E-Commerce Sales Analysis (Excel)

Ran exploratory analysis on 361 rows of e-commerce data, identifying Electronics and the UK as top performers; top-scoring evaluation outcome.

Excel
View all works
Back to works

Supply Chain Analysis Dashboard (Power BI)

Built a dashboard tracking $577.6K in revenue across products, locations, and shipping carriers, defining metrics to flag top performers and quality risk areas.

Power BI
View all works