Amara Osei / data_analyst
GitHub LinkedIn Resume · PDF 1pg

OPEN TO WORK · JUN 2026

Amara Osei
Junior Data Analyst

Statistics & data science senior who treats every question like a query. I turn messy tables into decisions with SQL, Python, and Tableau — and I document the pipeline so the next analyst can rerun it.

Download Resume (PDF, 1 pg · 184 KB) Browse Case Files
SQL PYTHON TABLEAU R / DAX
12 Dashboards shipped
3.2M Rows analyzed
5 Certifications
2 Analytics internships
FIG. 01

Skills Dashboard

self-assessed · updated 2026.07

Proficiency by Tool

scale 0–100 · relative comfort in production use

SQL
Excel
Tableau
Python
Power BI
R

Capability Index

segments filled n / 10

STATISTICS8/10
VISUALIZATION9/10
ETL / PIPELINES7/10
STORYTELLING8/10
MACHINE LEARNING6/10

Also fluent: dbt · git · Google Sheets · BigQuery · Jupyter · pandas · scikit-learn

FIG. 02

Case Files

4 records · filter by method
PRJ-001 · CHURN ANALYSISSQL / VIZ

Streaming Subscriber Churn

"Which subscribers are most likely to cancel in the next 60 days — and what would keep them?"

AT-RISK FLAGGED RETAINED BASE

pilot cohort · n = 41,200 accounts

−18% churn in pilot
$240K revenue flagged
SQL dbt Tableau
View notebook ↗ GitHub ↗
PRJ-002 · A/B READOUTSQL / VIZ

Checkout Flow Experiment

"Did the one-page checkout actually lift conversion, or did we just get lucky?"

14-day test · 96,400 sessions

+12.4% conversion lift
p=0.003 two-tailed z-test
SQL Python Matplotlib
View notebook ↗ GitHub ↗
PRJ-003 · DEMAND FORECASTML

Bikeshare Dock Forecasting

"How many bikes does each downtown dock need before Saturday morning rush?"

backtest accuracy by model version

7.9% MAPE (v4)
52 wks backtested
Python scikit-learn Prophet
View notebook ↗ GitHub ↗
PRJ-004 · ENERGY AUDITVIZ

Campus Energy Dashboard

"Which of our 9 campus buildings are burning money after midnight?"

overnight kWh · spring term

−11% usage after fix
9 bldgs live-metered
Power BI Excel DAX
View notebook ↗ GitHub ↗
FIG. 03

Experience Log

ORDER BY start_date DESC
2025.06 — PRESENT

Data Analytics Intern

Brightcart · e-commerce · Chicago, IL (hybrid)

  • Built 6 Tableau dashboards for merchandising, cutting weekly reporting prep from 5 hrs to 40 min.
  • Wrote dbt models over 1.4M order rows; flagged a discount-stacking bug worth $38K/quarter.
  • Presented churn pilot findings to 3 directors; recommendations adopted for the fall roadmap.
2024.09 — 2025.05

Research Assistant, Behavioral Data Lab

Lakeview State University · Dept. of Statistics

  • Cleaned and validated 12,400 longitudinal survey responses in R; documented a reusable QA checklist.
  • Automated weekly panel refresh with an R pipeline, saving the lab ~6 hrs per cycle.
  • Co-authored a methods poster presented at the 2025 undergraduate research symposium.
2024.01 — 2024.08

Student BI Consultant

Lakeview Analytics Collective · pro-bono client work

  • Delivered 5 Power BI dashboards for local nonprofits, including a donor-retention view that surfaced a +22% repeat-gift opportunity.
  • Ran stakeholder interviews and translated fuzzy asks into 18 concrete metrics definitions.
2023.09 — PRESENT

Founder & Lead, Data Viz Society

Student organization · Lakeview State University

  • Grew the club from 0 to 120 members; hosted 14 hands-on Tableau & SQL workshops.
  • Organized an annual campus datathon with 21 teams and real datasets from facilities and athletics.
FIG. 04

Education & Credentials

6 records verified
CREDENTIALS_LEDGER · degree + certifications
Credential Status Issued
B.S. Statistics & Data Science
LAKEVIEW STATE UNIVERSITY · MINOR: CS 		IN PROGRESS 2026.05 (exp.)
Google Data Analytics Certificate
COURSERA / GOOGLE 		VERIFIED 2024.03
Tableau Desktop Specialist
TABLEAU / SALESFORCE 		VERIFIED 2024.11
AWS Certified Cloud Practitioner
AMAZON WEB SERVICES 		VERIFIED 2025.02
SQL (Advanced) Skill Certification
HACKERRANK 		VERIFIED 2025.06
dbt Fundamentals
DBT LABS 		VERIFIED 2025.07

Let's query something together.

Seeking a junior data analyst role starting June 2026 — Chicago, remote, or anywhere with good coffee and clean schemas.

Download Resume (PDF, 1 pg · 184 KB) github.com/amara-osei linkedin.com/in/amaraosei

data + contact: amara.osei.data@gmail.com +1 (312) 555-0164 CHICAGO, IL · UTC−5