Aoxuan

About Aoxuan

BI & Data Analyst with over 2 years of experience translating complex data into strategic insights that empower executive decision-making. Expert in SQL and Python with a proven ability to engineer end-to-end data solutions on cloud platforms like GCP. Proficient in building scalable data pipelines, developing robust data models with dbt, and creating interactive Tableau and Power BI dashboards to support cross-functional teams.

Experience

1. Data Analyst

   PassiveLogic

   Jul 2023 — Present · Salt Lake City, UT, US

   Engineered and owned the company\'s primary BI reporting suite, developing standardized Tableau and Power BI dashboards that provided leadership with self-service analytics and real-time visibility into departmental KPIs, enabling each department to track KPIs, monitor trends, and drive strategic initiatives through data-informed decision-making- Provided critical cross-functional support by collaborating with stakeholders from Sales, Marketing, HR, Finance, and Project Management teams to gather requirements and deliver data-driven recommendations, leading to the identification of sales opportunities, targeted marketing outreach, and a reduction in employee attrition- Architected and automated end-to-end ETL pipelines on GCP, utilizing Cloud Run jobs for containerized data processing, Workflows for orchestration, and Cloud Scheduler for timely execution- Implemented an event-driven data ingestion framework using Pub/Sub to automatically trigger the transfer of processed files from Google Cloud Storage (GCS) into the BigQuery data warehouse- Utilized dbt to develop, test, and deploy data transformations within BigQuery, building analytics-ready fact and dimension tables. Designed and implemented star and snowflake schemas to create robust, scalable data models that serve as the single source of truth for BI reporting- Conducted geospatial and sales analysis using Python and Tableau to map partner locations, evaluate pipeline performance, and identify growth opportunities across North America- Created interactive marketing performance dashboards, leading to increased website traffic and user engagement- Developed Tableau dashboards for HR to monitor hiring funnels, turnover trends, and workforce composition- Supported Finance with dashboards to visualize budget variance, revenue trends, and cost control, streamlining planning and forecasting.

Education

• University of Southern California

  Master's degree

  2021 — 2023

• Tongji University

  Bachelor's degree

  2016 — 2020