Recent Grads on How They Landed Internships and Jobs


Past Interns

 
Minghao Dai

Minghao Dai

Minghao Dai, data analyst, Ipsos

“Most of my daily work was cleaning and analyzing data sets related to healthcare. I used R most of the time, extracted the relevant information from the data and then arranged them in a more clear way. I also did hypothesis testing, regression and prediction with the data. In general, I think my statistical knowledge and coding skills are the two essential parts of my internship.”

Daitong Li

Daitong Li

Daitong Li, summer intern, Gooroo

“I spent the summer interning at Gooroo, a fast-paced education technology start-up offering on-demand tutoring service. I joined the business development team where I worked creatively on digital marketing campaigns. Moreover, I offered tutoring and consulting services to clients on various statistics courses and projects. I found the internship through the department weekly email, it linked me with the resources and contacts I was looking for.”

Lu Zhang

Lu Zhang

Lu Zhang, intern, Compass

“My job included pricing/valuation of selected condos and coops, analysis of rental and sales data and management of ownership database. I got familiar with the real estate market in the midtown and downtown Manhattan as well as Williamsburg in Brooklyn. It was exciting!”

Eric Zhang

Eric Zhang

Eric Zhang, data scientist, Johnson & Johnson

“I was a member of a special group in the J&J IT Application Services division called DataLabs, which focused on fast prototyping of machine learning/data science/analytics solutions to problems in the healthcare technology space. We received work requests from various business units within J&J, and then given a set of data and project requirements, we determined the best way to attack the problem and then built a proof of concept solution in 3 weeks using a variety of tools (including R, Python, and Tableau). We essentially functioned as internal consultants for the wider organization, where we were paid to deliver specific analyses to managers and directors in other J&J departments. My role in each project was a combination of data gathering/cleaning, analysis, visualization, and demoing/pitching to the client each week.”

Yunyi Zhang

Yunyi Zhang

 

Yunyi Zhang, intern, Quantitative Equity Research Department, Delaware Investments

“My daily job was related to factor analysis, portfolio attribution and backtesting. I also presented the results of our research to other investment teams, wrote reports and automated some models and functions we developed. Statistics background provided me with a quantitative perspective when viewing financial issues and great ideas in constructing and examining models.”

Chi Zhi

Chi Zhi

Chi Zhi, quantitative research intern, OmniMarkets

“I participated in developing an application by which investors could access to multiple consumer lending platforms and choose assets picked up by underlying algorithms to invest. I did most of the back-end work, including data collection, database schema design, and algorithm development. I enjoyed and learned a lot from it.”
Nisha Khilnani

Nisha Khilnani

Nisha Khilnani, marketing analytics intern, Experian Consumer Services

“On a day-to-day basis, I extracted data using SQL Redshift, performed statistical analyses through SAS, and also developed and maintained weekly reports through MS Excel. These analyses consisted of a variety of topics, from analyzing marketing campaign efficiency, to understanding and identifying correlations between survey data responses, and membership subscription activity. My capstone project towards the end delved deeper into our Salesforce data and internal subscription data. The goal was to identify High Quality Engagements (or activities that led to conversions) within our call centers, online links, and email marketing efforts using statistical techniques. During my last week at Experian, I was given the opportunity to present this analysis to several executives, including the Chief Marketing Officer, the VP of Digital Marketing, and the Senior Director of Ad Operations and Analytics. This overall experience allowed me to use statistical methods learned in our courses here at Columbia, as well as gain additional skills, such as marketing strategies and communicating to individuals outside of the statistical realm.”

Yuhan Sun

Yuhan Sun

Yuhan Sun, Data Analyst Intern, UNICEF (United Nations Children’s Fund)
 
“My job involves two parts. One is to upgrade the Child-Mortality Estimation Shiny App and help develop the IMR Shiny App. Another one is to support the data analysis and visualization of a report on refugee and migrant children which is for the 71st General Assembly. R (especially Shiny), Tableau, javascript were the main tools I used in my work. This internship was a perfect match  for my background.”