Skip to main content
HimalayasHimalayas logo
jiayi sunJS
Open to opportunities

jiayi sun

@jiayisun

Economics graduate and CFA candidate; data analyst focused on financial modeling, SQL/Python insights, and actionable reporting.

United States
Message

What I'm looking for

I’m looking for a role where I can apply SQL/Python and financial modeling to solve business problems with rigorous analysis. I want to collaborate with teams that value clear reporting, good communication, and data-driven decision making.

I’m an Economics graduate and CFA candidate with a strong focus on financial modeling, business analysis, and data-driven decision making. I enjoy turning complex data into clear, actionable insights through reporting and trend analysis.

In my current role as a Data Analyst at Next Innovation LLC, I analyze offensive strategy patterns using play-by-play data to compare structured set plays versus random possessions. I also perform model selection to identify the best GLM framework for predicting player development outcomes and support my recommendations with statistical reasoning.

Previously, as an Internship of Business Analysis at Microsoft, I analyzed Azure operational and subscription data with SQL and Excel to investigate discrepancies between membership growth and monthly revenue across subscription tiers and billing status. I gathered and organized public financial data and market research for product areas including Azure, Microsoft 365, and Xbox, and helped prepare data-driven PowerPoint presentations with clear visualizations.

My experience also includes a Product Analyst Intern role at Jiangsu Huaxi Securities Co., LTD., where I supported client advisory work by researching market trends and assisting in the preparation of tailored investment suggestions based on risk profiles. In projects, I’ve built analytical tools and forecasting models using VBA/Excel and performed policy impact research in Stata with OLS and fixed-effects regression.

Experience

Work history, roles, and key accomplishments

NL
Current

Data Analyst

Next Innovation LLC

Sep 2025 - Present (8 months)

Analyzed NCAA and NBA play-by-play data to compare structured set plays versus random possessions, identifying differences in tactical reliance and execution efficiency. Selected an appropriate GLM regression framework for predicting player development outcomes and consolidated 38,000+ contact records into a 25,000-record master dataset to improve data quality for outreach.

MI

Business Analysis Intern

Microsoft

May 2024 - Jun 2024 (1 month)

Used SQL and Excel to analyze Azure operational and subscription data, investigating discrepancies between membership growth and monthly revenue across subscription tiers and billing status. Built data-driven PowerPoint materials summarizing multi-year revenue and margin trends to support internal discussions for Azure, Microsoft 365, and Xbox.

JL

Product Analyst Intern

Jiangsu Huaxi Securities Co., Ltd.

Jul 2023 - Aug 2023 (1 month)

Learned stock market operations and regulatory frameworks, including order types, trading mechanisms, and compliance guidelines through hands-on case-based training. Researched market trends and stock performance to support client advisory, helping tailor investment suggestions based on customer risk profiles and preparing financial analysis reports.

Education

Degrees, certifications, and relevant coursework

Pennsylvania State University logoPU

Pennsylvania State University

Bachelor of Economics, Economics

2021 - 2025

Bachelor of Economics at Pennsylvania State University (Aug 2021–Aug 2025), with coursework including micro/macro economics and statistical foundations for econometrics.

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan