Kai Nakamura

Junior Data Analyst

Austin, TX, United States

Professional Summary

Detail-oriented Junior Data Analyst in Austin who turns messy data into clear decisions for marketing and operations teams. Skilled in SQL, Python, Tableau, Excel, dbt, and A/B testing, with a track record of improving reporting speed, data quality, and activation outcomes.

Employment History

Junior Data Analyst

Hill Country Analytics · Austin, TX

Aug, 2023 · Present

Build weekly Tableau dashboards for marketing CAC/LTV, cutting reporting time by approximately 40%. Write SQL against Postgres for cohort retention analysis; flagged a 12% churn spike in the SMB segment. Partner with operations to automate CSV pulls into dbt models, reducing manual data-entry errors by 30%.

Data Analyst Intern

Lone Star Fintech · Austin, TX

May, 2022 · Jul, 2023

Cleaned and validated transaction datasets with Python and pandas, improving the record-match rate to 98%. Prepared an A/B test readout for onboarding emails that delivered an 8% activation lift in the treatment group. Documented metric definitions and ownership in Notion for more than 15 KPIs, improving cross-team consistency.

Research Assistant

University of Texas at Austin · Austin, TX

Sep, 2021 · Apr, 2022

Scraped and structured public datasets for a faculty-led urban mobility study, processing more than 50,000 records. Produced charts and summary statistics for faculty presentations, reducing analysis turnaround by 25%. Maintained reproducible Jupyter notebooks and documented data-cleaning steps for future research assistants.

Education

B.S. Statistics

University of Texas at Austin · Austin, TX

Aug, 2018 · May, 2022

Coursework: Statistical Modeling, Regression, Experimental Design, Database Systems, and Data Visualization. Built reproducible analyses in Python and R; graduated with strong preparation for analytical roles.

Skills

SQL

Python

Tableau

Excel

dbt

A/B testing

Data storytelling