beBee background
Professionals
>
University City
Shu Miao

Shu Miao

Marketing Analyst

Marketing / Advertising / Public Relations

University City, Township of Hadley, Saint Louis

Social

About Shu Miao:

Actively seeking for an opportunity of Marketing Analyst, currently a graduate student at Washu

Experience

Shanghai Kaytune, Shanghai, China Data Analysis Intern

June 2022 - August 2022

December 2024

May 2023

Led seven successful marketing campaigns of summarizing and promoting of brand on JD and Taobao platforms by leveraging historical strategies and sales information.

Conducted comprehensive analysis of new products in the market, including competitor analysis, user profiling, and product evaluation, using data analysis skills with business visualization techniques in Excel, including VLOOKUP and pivot table, to extract insights and inform marketing strategies.

Analyzed conversion rates and market share in comparison to competitors, utilizing analytics dashboard design skills in machine learning to present key performance metrics to stakeholders.

Researched market penetration rates and trends across Europe and Asia to gain insights into market dynamics, combining data analysis and visualization skills to identify strategic opportunities.

Explored the relationship between brand search demand and conversion rates through product sales analysis, employing SQL to clean and analyze user data on various advertising channels and thus made insight about next year's marketing strategy.

Rapidamic LLC, Remote February 2021 – August 2021 Operational Assistant

Helped promote and operate the company's official social media account by composing promotional articles for the official account and editing video clips.

Proficiently imported Excel data into SQL to enhance efficiency in managing students, including removing duplicates, handling missing values, and performing format conversions, which reduce manual operations and errors.

Education

EDUCATION
WASHINGTON UNIVERSITY IN ST LOUIS, OLIN BUSINESS SCHOOL,St. Louis, MO Master of Science in Business Analytics - Customer Analytics (STEM with 3 years OPT)

• Relevant courses: Database Design and SQL, Data Science and Python, Machine Learning.

 University of Nottingham,Ningbo, China (one semester in UK)
Bachelor of Science in FAM (Finance, Management, Accounting)

• Relevant courses: Database Design and Implementation, Computer Science, Quantitative Methods, Econometrics.

Professionals in the same Marketing / Advertising / Public Relations sector as Shu Miao

Professionals from different sectors near University City, Township of Hadley, Saint Louis

Other users who are called Shu

Jobs near University City, Township of Hadley, Saint Louis

  • This role sits within a high-impact Marketing Analytics function, driving insight across large-scale healthcare programs that support consumer acquisition, retention and long-term growth. You'll partner closely with Marketing, · Product and Business teams to turn complex data int ...

    St. Louis

    4 weeks ago

  • Work in company

    Digital Business Analyst

    Jobs via Dice

    Digital Business Analyst will play a pivotal role in analyzing data across various domains to identify requirements and develop high-quality data products. · ...

    St. Louis

    1 month ago

  • Work in company

    Business Analyst – Enterprise Systems

    Really Great Reading

    We exist to make literacy possible for every learner, in every classroom, everywhere. We're looking for an Enterprise Business Analyst who connects the dots between Finance, Sales, Marketing, Customer Success and IT to make that movement smarter. · Partnering with teams to build ...

    Greater St. Louis

    1 month ago