Shiqi Cheng

Experience

• 

  ZEW - Leibniz Centre for European Economic Research

  Oct 2020 - Apr 2021

  • Supported in preparing and analyzing• Assisted the economic models analysis and mathematical calculations• Support with database management and download facilities. - Data preparation and visualisation for research projects with python and R code.- Contribution to the creation of new databases, for instance via webscraping.- Support with database management and download facilities.

  • Student Research Assistant

    Feb 2021 - Apr 2021

  • Intern

    Oct 2020 - Jan 2021
• 

  Emma – The Sleep Company

  May 2021 - Sept 2021

  Intern Business Development Greater China

  Data integration and analysis• Collaborate data between on-site and off-set to simulate consumer journey, in order to optimizepurchasing and usage behaviour as well as the conversion funnel.• analyse all marketing relevant KPI and derive recommendations for action and present theresults to all relevant stakeholders.Marketing activities• Responsible of design and control of marketing Implementation, especially for social mediainfluencers promotion cooperation.• Follow up promotion executions, including product delivery, advertisement content review,promotion data analysis, etc.SEO&SEM• SEO: Responsible for SEO optimization of the website, to achieve optional keywords ranking.• SEM: Develop website paid ads strategy to increase site traffic and generate more traffic toonline store. Show less

• 

  AUTO1 Group

  Jan 2022 - Jun 2022

  Business Intelligence Intern - Finance
• 

  AUTO1 Group

  Sept 2022 - now

  - Established and maintained an inventory audit system, training teams andsupporting annual audits.- Build ETL pipelines to integrate financial data from various sources, automating monthly report distribution via GitHub and dbt.- Produce highly-optimized SQL queries about Inventory payment for B2Conline retail plat-form, performing data quality checks to detect abnormalities and outliers in production tables.- Migrate legacy ETL jobs to Python, developing advanced Python codingskills in the process. Show less

  • Business Intelligence Manager

    Jul 2023 - now

  • Junior Business Intelligence Manager

    Sept 2022 - Jun 2023