Register
Employer sign In
Job Seeker sign InYour resume is now live and active. Below is what employers will see.
Please review your resume posting.
If you find an error, click on the "Edit Resume"
button above and make any necessary changes.
30 Morningside Drive
New York, New York United States
Phone: 6174592306
Email: hb2857@columbia.edu
Send Private Message
Data journalist
Objective
Haiyi Bi is a data journalism student and multimedia storyteller at Columbia University, whose reporting focuses on arts and culture, with an interest in public records and data-driven investigations. She previously earned a bachelor’s degree in journalism at Boston University, where she reported on culture and immigration in Boston. She reported and wrote an Associated Press investigation on privately sponsored congressional travel and the ethics blind spots that allow lawmakers’ families to join trips paid for by outside groups. That work won the 2024 Investigative Reporters and Editors (IRE) Awards in Student – Large. She enjoys writing, data visualization, video production and storytelling. She is from Beijing, China and has lived in Toronto and Boston. She speaks Mandarin, English and French.
Education:
Data Journalism
Master’s Degree
Journalism
Bachelor’s Degree
Work Experience:
Columbia University – Graduate School of Journalism |
Boston University Arts Initiative |
Managed a weekly newsletter for 12,000+ subscribers using Mailchimp and updated content in WordPress.
Filmed TikTok-style videos for an Instagram account with 3,000+ followers and wrote captions for posts.
Photographed arts events and student workshops and delivered edited images for marketing and social content.
Beijing Radio & Television Station |
Wrote and managed five social media posts daily based on BRTV news articles, focusing on local topics like sports and travel; posted them on Weibo, TikTok, WeChat video channel, and other Chinese social media platforms, increasing engagement by 10%.
Reported at major events in Beijing, such as the college entrance exam (gaokao), ensuring timely and accurate coverage.
Edited short videos daily, achieving peak views of around 100,000 on one post, enhancing audience engagement and visibility.
Columbia News Service |
Reported and wrote a business story on Molly Tea’s New York trademark dispute, using court filings, company statements, on-site reporting, and customer interviews.
Total Years Experience:
4 yearsSkills:
Data Analysis: Python, pandas, SQL
Data Scraping: BeautifulSoup, Playwright, Selenium
Data Mapping: QGIS
Data Visualization: Altair, Datawrapper, Adobe Illustrator, ai2html
Web: GitHub Pages, HTML/CSS, JavaScript
Languages: English, Mandarin (native), French