Zhihang Zhao | Insta360

About Me

I’m a Data Analyst at Insta360, building BI systems and delivering insights that drive growth.

If you desire to view additional content from me, kindly visit my blog.

Skills

Data Analysis & Visualization: SQL, Python, Tableau, Excel.
Data Platforms & Cloud Services: Alibaba Cloud DataWorks, AWS.
AI & Agent Workflows: Claude Code, OpenAI Codex, ChatGPT, Agentic Workflow.
Research & Development Tools: Stata, R, Git, Linux, Markdown, $\LaTeX$.
Languages: Chinese (Native), English (Fluent).

Education

The University of Warwick, Coventry, UK 09/2022 – 09/2023

MSc Economics and International Financial Economics
Relevant Courses: Advanced Macroeconomics, Advanced Microeconomics, Advanced Econometrics, Topics in Global Finance, The Economics of Financial Markets, Game Theory

Central University of Finance and Economics, Beijing, China 09/2018 – 07/2022

Bachelor of Economics National Economic Management
Relevant Courses: Python Programming (83), Econometrics (89), Mathematical Economics (98), Intermediate Macroeconomics(93), Intermediate Microeconomics (86), Real Analysis (94) etc.
Awards: National Encouragement Scholarship, Academic Research and Innovation Excellence Scholarship

Experience

Insta360 Jul. 2024 – Present

Full-time, CEO Management Trainee

Data Analyst, BI Team

Built BI systems and analytical frameworks to support decisions across marketing, product, and e-commerce.

Built end-to-end BI dashboards and metric frameworks for paid media analysis, covering the full funnel from impression to click, add-to-cart, and payment, improving campaign monitoring, attribution, and review efficiency.
Designed and implemented a workforce analytics solution using Python and Feishu OpenAPI, automating data collection, cleaning, and budget-vs-actual labor analysis to improve resource planning accuracy.
Developed funnel analysis for cloud storage incentives, tracking exposure, claim, retention, and payment to identify conversion bottlenecks and support incentive strategy optimization.
Built the data infrastructure for a new drone business from 0 to 1, covering serial-level logistics and activation tracking, revenue and attach-rate analysis, real-time sales monitoring, market exposure, and after-sales dashboards.

Advertising & Growth Analytics, Ads Team

Supported paid media growth through attribution analysis, campaign optimization, and reporting automation.

Built monitoring and attribution frameworks for TikTok campaigns across creatives, audience segments, and budget allocation, helping increase ROI from 6 to 10+ and drive 290% revenue growth.
Partnered with product, operations, and engineering teams to build the advertising funnel for the cloud storage app from scratch, defining conversion paths, tracking logic, budget allocation, and reporting structure.
Led analytics support for Black Friday and Christmas campaigns by rebuilding the tracking framework and creating automated dashboards for daily monitoring, anomaly detection, and performance review.
Standardized weekly reporting workflows and automated creator ad naming conventions, improving attribution consistency and reducing manual effort by 80%.

Beijing Xiaomi Technology Co., Ltd Feb. 2022 – Apr. 2022

Internship, Investor Relations Specialist
Assisted in daily operations of Xiaomi’s Investor Relations Department.

Assisted in producing a detailed comparative company research report on Transsion, where I analyzed complex issues related to the company’s financial performance and industry competition using data analysis.
Developed comprehensive report and presentation materials focusing on the electric vehicle industry, encompassing an in-depth analysis of the primary product development cycles of leading companies in the electric vehicle sector.
Tracked analyst expectations, quarterly performance, and operational status of various comparable companies. Contributed to the production of Xiaomi’s quarterly reports.

CUFE Course Thesis Template Jul. 2021

$\LaTeX$, Personal Project
A Chinese LaTeX Template for Central University of Finance and Economics Course Thesis

Adapted Word format to LaTeX using ElegantPaper, based on course requirements.
Open-sourced template on GitHub for fellow students to use.

2020 Contemporary Undergraduate Mathematical Contest in Modeling Nov. 2020

$\LaTeX$, Team leader. Won the First Prize in Beijing.
Optimized Strategy for “Through the Desert” Problem

Utilized dynamic programming to determine the optimal strategy for the problem and analyzed player revenue based on game details.
Used game theory to develop asynchronous strategy for multiple players, verified for rationality as player count increased.

Admissions Program Research Dec. 2019 – Feb. 2020

Python, Excel, Research Assistant
Organized Shanxi Province’s admissions data in the admissions guide using Excel.

Developed a Python program using xlrd, openpyxl, and pandas modules to process OCR-scanned photos into Excel tables, and used Excel macros to split the tables as required.
Improved efficiency by nearly 10 times compared to manual entry, processing over 3,000 data items at a time. Recommended processing 1,000 to 2,000 data items at a time for convenience of troubleshooting.

Honors and Awards

The 30th Beijing College Student Mathematics Competition (Economics), $2^{nd} Prize$ Dec. 2019
The 11th National College Student Mathematics Competition (non-mathematics), $2^{nd} Prize$ Nov. 2019