Jonathan Y. J. Wang Email & Phone Number

Barcelona, Catalonia, Spain

• Provided cross functional (300+ colleagues in total) ad hoc support, data cleaning and training on Looker. Managed database, automation tools (airflow), and led ETL/ELT processes to ensure data integrity for high-quality analysis.• Collaborated with sales, finance and product managers to construct and maintain advanced SQL queries infrastructure, streamlining monthly sales reports and the implementation of growth strategy, helping sales team save hours per week from the manual work.•… Show more • Provided cross functional (300+ colleagues in total) ad hoc support, data cleaning and training on Looker. Managed database, automation tools (airflow), and led ETL/ELT processes to ensure data integrity for high-quality analysis.• Collaborated with sales, finance and product managers to construct and maintain advanced SQL queries infrastructure, streamlining monthly sales reports and the implementation of growth strategy, helping sales team save hours per week from the manual work.• Aligned key performance indicators (KPIs), built scalable data models, pipelines and dashboards to monitor key clients representing the majority of company's shipments.• Engaged with sustainability projects to produce annual carbon footprint report for external auditing that contributed to the award. Show less

Barcelona, Catalonia, Spain

• Facilitated the ETL and ELT process. Involved in cross-department collaboration to maintain robust data systems, ensuring informed decision-making and effective business control.• Analysed warehouse-to-delivery distances to evaluate and enhance operational efficiency. Automated data extraction via web API, integrated data into BigQuery, and utilized Looker for automated reporting, which was then presented to the C-suite executives and hundreds of staffs, influencing strategic decisions… Show more • Facilitated the ETL and ELT process. Involved in cross-department collaboration to maintain robust data systems, ensuring informed decision-making and effective business control.• Analysed warehouse-to-delivery distances to evaluate and enhance operational efficiency. Automated data extraction via web API, integrated data into BigQuery, and utilized Looker for automated reporting, which was then presented to the C-suite executives and hundreds of staffs, influencing strategic decisions regarding warehouse openings and closures.• Collaborated with the transportation team for an A/B testing project to investigate the efficiency of the application. Helped debug and optimize a complex Python-based routing algorithm, improving the accuracy and efficiency of route determinations. Show less

Barcelona, Catalonia, Spain

• Leveraged data analytics (Tools: R, Excel) to help an NGO optimise donors classification, define performance metrics, and maximize fundraising outcomes.

Valls, Catalonia, Spain

• Analysed competitions, customer behaviours and industry 4.0 opportunities, and delivered solutions to improve the efficiency and flexibility of the organisation.• Co-created an APP prototype, estimated worth 30,000 EUR, for digital working schedule and internal administration.

Taipei City, Taiwan

• Drafted summary of international affairs and visualized data as a clear news coverage• Published 3 analytic reports chosen as headlines of Line Today News, a news platform with over 40 million views on average every day

Beijing, China

• Conducted investment project researches for Chinese corporations valued more than 500 million USD.• Assisted in organising an African public welfare activity in China attended by hundreds including the UN officials.

Taipei City, Taiwan

• Managed advertising and digital content; measured and analyzed data of viewership• Initiated a Facebook advertising and content refreshing campaign, leading to a 55% increase in subscription

Master'S Degree, International Management

• The Economist MIM Ranking (2019): #8. • Relevant course work: Process planning and optimisation, Macroeconomics in emerging markets

Master Of Science - Ms, International Management

• QS Management Ranking (2021): #6. • Relevant course work: Corporate finance, Geopolitics and non-market strategies, Global operations.

Master'S Degree, Cems Exchange

• FT Management Ranking (2021): #5. • Relevant course work: Consumer marketing research, Valuation, Financial information and decision.

Bachelor Of Arts - Ba, Ciencia Política

Courses: Derecho internacional público (International law), Política internacional (World politics).

Bachelor Of Arts - Ba, Diplomacy

Courses: Politics and economics, International law, Negotiations, International trade and finance, Macroeconomics, Quantitative methods.