Ziyue Huang

A data-driven professional with 4+ years of experience in business analytics and digital marketing across the US and China. Passionate about turning data into actionable insights, I specialize in Python, SQL, Power BI, and digital marketing analytics. Skilled in A/B testing, audience segmentation, and building dashboards that support smarter decisions. Malta Permanent Resident, authorized to work without sponsorship.

Paid Media Specialist ｜Rito Agency, Shanghai, China

Duration: March 2025 - April 2025

• Executed user growth campaign setup for ByteDance’s Lemon8 app in the Canadian market via TikTok Ads, managing a monthly budget of $100K and achieving a daily CPI between $3.5–4 and CPM around $2
• Designed daily budget plans based on monthly targets, built and launched ad campaigns, and conducted real-time monitoring and performance analysis. Adjusted bidding strategies daily based on CPI, CPM, and market trends to optimize audience targeting and ad performance
• Tracked daily/weekly/monthly KPIs and ad spend for performance review. Assessed creative performance across content categories and coordinated with the other internal team to analyze ad content effectiveness and develop high-performing creative assets based on data trends

Data Analyst | Alawi Global Studio, Virginia, US

Duration: February 2024 – February 2025

• Developed a travel website using Python Flask with HTML/CSS, connected HTML Sign-up form to MySQL database using PHP
• Designed and implemented a real-time Power BI dashboard to monitor KPIs (impressions, reach, CPC, CTR), optimizing ad strategies for female audiences aged 35+, resulting in a 15% increase in media engagement
• Built a Python-based ETL pipeline to extract, transform, and clean data from multiple sources including internal CRM and Meta Ads, centralizing it into database, enabling 500+ subscriber profiles
• Utilized k-means clustering with Python to refine audience segment strategy and boost subscriptions by 3%

New York University, New York, NY

September 2022 – May 2024

University of Technology Sydney, Sydney, Australia

September 2018 - June 2022