Research & Data Analyst at Shanghai Baosteel Packaging - Baowu Group • Produced weekly, monthly, and quarterly Market Intelligence briefings on macroeconomics, politics, and the beverage industry (FMCG focus) across multiple countries, especially Southeast Asia.
- Monitored Key Macro Indicators including GDP growth, consumer price index (CPI), and policy developments such as excise tax, sugar tax, extended producer responsibility (EPR), and foreign direct investment (FDI).
- Tracked capacity moves and investment plans by beverage companies, including new facilities, plant expansions, new lines, and changes in utilization rates.
- Synthesized complex data into strategic implications and evidence-based recommendations for senior leadership.
- Conducted Customer and Competitor Research on beverage giants (Swire Coca-Cola, CCEP, PepsiCo) and brewers (Carlsberg, Heineken, Sabeco, ABI).
- Mapped plants, capacities, production lines, and supply strategies to produce integrated company and country profiles synthesizing financial health and packaging consumption trends.
- Integrated internal and external research data into a Governed Data Repository with standardized terminology and data structures.
- Established Data Quality Rules and engineered End-to-End Extraction, Transformation, and Loading (ETL) workflows using SQL and Power Query to cleanse, deduplicate, normalize, and restructure large datasets.
- Developed and maintained Automated Dashboards in Google Looker Studio and Excel to visualize country-level indicators and competitor plant capacity utilization.
- Worked with the Sales department and other functions to gather market and customer information, estimate volumes, and validate assumptions.
- Organized and participated in client dinners and informal conversations to enrich datasets, verify information, support business development.
