Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Hello! I'm Shaodong ZHANG, a trilingual professional skilled in business intelligence (BI) and data analytics, with hands-on experience building Power BI dashboards, designing ETL pipelines, and applying machine learning using Python, R, Power BI and SQL. I thrive on turning complex data into clear, actionable insights and collaborating with cross-functional teams to drive data-driven decisions. My background in International Relations complements my analytical work with strong communication and consultancy skills. I am currently the Statistics and Information Management Officer at IOM in Geneva, where I develop semantic models and dashboards to monitor migration flows, build ETL pipelines, and lead data quality control. My previous roles include BI and Data Analyst Intern at IATA, Power BI Dashboard Development Intern at ITU, and a Capstone Consultant with the Embassy of Canada to Spain, all of which sharpened my ability to translate policy needs into data-driven solutions. Outside of work I have founded an online IR tutoring service and taught international law, blending policy expertise with data and technology.…Hello! I'm Shaodong ZHANG, a trilingual professional skilled in business intelligence (BI) and data analytics, with hands-on experience building Power BI dashboards, designing ETL pipelines, and applying machine learning using Python, R, Power BI and SQL. I thrive on turning complex data into clear, actionable insights and collaborating with cross-functional teams to drive data-driven decisions. My background in International Relations complements my analytical work with strong communication and consultancy skills. I am currently the Statistics and Information Management Officer at IOM in Geneva, where I develop semantic models and dashboards to monitor migration flows, build ETL pipelines, and lead data quality control. My previous roles include BI and Data Analyst Intern at IATA, Power BI Dashboard Development Intern at ITU, and a Capstone Consultant with the Embassy of Canada to Spain, all of which sharpened my ability to translate policy needs into data-driven solutions. Outside of work I have founded an online IR tutoring service and taught international law, blending policy expertise with data and technology.

Shaodong Zhang

Data Scientist, Data Analyst, Data Visualizer, +2





Hello! I'm Shaodong ZHANG, a trilingual professional skilled in business intelligence (BI) and data analytics, with hands-on experience building Power BI dashboards, designing ETL pipelines, and applying machine learning using Python, R, Power BI and SQL. I thrive on turning complex data into clear, actionable insights and collaborating with cross-functional teams to drive data-driven decisions. My background in International Relations complements my analytical work with strong communication and consultancy skills. I am currently the Statistics and Information Management Officer at IOM in Geneva, where I develop semantic models and dashboards to monitor migration flows, build ETL pipelines, and lead data quality control. My previous roles include BI and Data Analyst Intern at IATA, Power BI Dashboard Development Intern at ITU, and a Capstone Consultant with the Embassy of Canada to Spain, all of which sharpened my ability to translate policy needs into data-driven solutions. Outside of work I have founded an online IR tutoring service and taught international law, blending policy expertise with data and technology.…Hello! I'm Shaodong ZHANG, a trilingual professional skilled in business intelligence (BI) and data analytics, with hands-on experience building Power BI dashboards, designing ETL pipelines, and applying machine learning using Python, R, Power BI and SQL. I thrive on turning complex data into clear, actionable insights and collaborating with cross-functional teams to drive data-driven decisions. My background in International Relations complements my analytical work with strong communication and consultancy skills. I am currently the Statistics and Information Management Officer at IOM in Geneva, where I develop semantic models and dashboards to monitor migration flows, build ETL pipelines, and lead data quality control. My previous roles include BI and Data Analyst Intern at IATA, Power BI Dashboard Development Intern at ITU, and a Capstone Consultant with the Embassy of Canada to Spain, all of which sharpened my ability to translate policy needs into data-driven solutions. Outside of work I have founded an online IR tutoring service and taught international law, blending policy expertise with data and technology.

Available to hire

Hello! I’m Shaodong ZHANG, a trilingual professional skilled in business intelligence (BI) and data analytics, with hands-on experience building Power BI dashboards, designing ETL pipelines, and applying machine learning using Python, R, Power BI and SQL. I thrive on turning complex data into clear, actionable insights and collaborating with cross-functional teams to drive data-driven decisions. My background in International Relations complements my analytical work with strong communication and consultancy skills.

I am currently the Statistics and Information Management Officer at IOM in Geneva, where I develop semantic models and dashboards to monitor migration flows, build ETL pipelines, and lead data quality control. My previous roles include BI and Data Analyst Intern at IATA, Power BI Dashboard Development Intern at ITU, and a Capstone Consultant with the Embassy of Canada to Spain, all of which sharpened my ability to translate policy needs into data-driven solutions. Outside of work I have founded an online IR tutoring service and taught international law, blending policy expertise with data and technology.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Intermediate

Language

English

Advanced

Japanese

Advanced

Work Experience

Statistics and Information Management Officer at International Organization for Migration (IOM)

November 1, 2024 - Present

Developed Power BI semantic models and dashboards to monitor migration flows for operational reporting. Engineered an ETL pipeline to ingest, clean, and load data into SQL databases for downstream analytics and ML. Built a Python ML text-classification workflow to label 6,500+ country-office IT queries, improving triage efficiency. Led data quality control, reconciling records against QC reports and resolving discrepancies with a 99% correction rate. Managed ICT support tickets, maintaining a 95% closure rate within 48 hours. Coordinated with country offices and ICT teams on MiMOSA database patches, updates and enhancements.

BI and Data Analyst Intern at International Air Transport Association (IATA)

July 1, 2024 - October 1, 2024

Built Power BI dashboards to visualize pilot results and benchmark participating airlines against industry peers. Analyzed survey data from 25 airline pilots using Excel and Power BI to assess airlines’ retailing knowledge maturity. Designed and deployed a SharePoint-based pilot platform, achieving a 4.4/5 satisfaction rating from 22 users. Coordinated end-to-end onboarding for 15 airlines (27 participants) from invitation through pilot completion.

Power BI Dashboard Development Intern at International Telecommunication Union (ITU)

October 1, 2023 - July 1, 2024

Built BI dashboards and query interfaces to integrate data from SQL Server, MS Access, SharePoint and Confluence. Mapped and documented 20+ satellite database relationships, enabling accurate joins and reliable downstream analysis. Supported operational reporting through daily SQL-based satellite data extractions in MS Access.

Capstone Project Consultant at Embassy of Canada to Spain

January 1, 2023 - June 1, 2023

Conducted a comparative analysis of Canada’s and Spain’s foreign policy priorities toward China.

Teaching Assistant at Center for Education in Liberal Arts and Sciences, Osaka University

October 1, 2020 - March 1, 2021

Created handouts on International Law and checked grades for 100+ undergraduate students. Assisted lecturers to carry out 15 online Zoom courses.

Founder and Consultant at Online Tutoring School of International Relations

August 1, 2020 - August 1, 2023

Delivered over 20 consultancy services on International Relations (IR) and attained 100% customer satisfaction. Collected feedback data from 34 clients, analyzing trends using Excel for better customer-oriented learning materials. Scaled IR educational content via social media, reaching 95,000+ views and expanding audience engagement.