Data Analyst
Current
Feb 2024 - Present
AeroLeads people directory · profile
Yiran Yan Email & Phone Number
Data Analyst | Proficient in Python, R, SQL & Data Visualization
at
XSUNT Corporation
LinkedIn matched
✓ Verified May 2026
3 data sources
Profile completeness 86%
Current company
Role
Data Analyst | Proficient in Python, R, SQL & Data Visualization
Location
New York City Metropolitan Area, United States, United States
Company size
Who is Yiran Yan? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Yiran Yan is listed as Data Analyst | Proficient in Python, R, SQL & Data Visualization at XSUNT Corporation, a company with 12 employees, based in New York City Metropolitan Area, United States, United States. AeroLeads shows a matched LinkedIn profile for Yiran Yan.
Yiran Yan previously worked as Data Analyst at Xsunt Corporation and Marketing Data Analyst at Kantar. Yiran Yan holds Master Of Business Analytics, Business from Lehigh University.
Company email context
Email format at XSUNT Corporation
This section adds company-level context without repeating Yiran Yan's masked contact details.
XSUNT Corporation
Review company-level records connected to Yiran Yan before choosing the right outreach path.
Profile bio
About Yiran Yan
A skilled Data Analyst trained at Lehigh University, with hands-on experience at XSUNT and Kantar Group. Proficient in Python, R, SQL, and visualization via Tableau and Power BI. Fluent in English and Chinese Mandarin. I adeptly translate data insights across diverse teams. Passionate about continuous learning, I'm updated with the ever-evolving analytics sphere. Let's connect and explore collaboration opportunities!
Current workplace
Yiran Yan's current company
Company context helps verify the profile and gives searchers a useful next step.
Xsunt Corporation
5 roles
Yiran Yan work experience
A career timeline built from the work history available for this profile.
Marketing Data Analyst
- Designed a Data Cleaning Pipeline within R and executed ETL (Extract, Transform, Load) processes for the Tencent Video Streaming project, utilized SQL queries to organize viewers' demographic and behavior data.
- Engaged in a beverage market research project, conducted sentiment analysis on 500 open-ended survey responses, leveraged the ChatGPT API within Python and validated the results using the TextBlob which leaded to a.
- Analyzed complex qualitative data derived from 8 focus groups, distilled unique user engagement traits across diverse scenarios, and effectively presented the findings to the Consulting division.
- Supported in conducting desk research for market research projects, including industry background investigations and analysis of interview locations, streamlined the research process and enhancing overall project.
May 2023 - Aug 2023
Graduate Teaching Assistant For Department Of Decision And Technology Analytics
· Grading of weekly assignments of BIS 244 (Business Analytics II) and BUAN348/448 (Predictive Analytics in Business)· Hold weekly office hours to assist students· Assist with developing of assignments/problems · Assist with the maintaining grades and managing Course Site
Jan 2023 - May 2023
Data Analysis Intern
· Investigated the impact of the 2008 Financial Meltdown on Freddie Mac by collecting and analyzing data on fixed-rate mortgages from 2008 to 2009 on its website.· Managed datasets by uploading them to Google Colab, used matplotlib for visualization.· Prepared weekly progress reports for project manager to ensure project objectives were met.
Jun 2020 - Aug 2020
Financial Market Analyst
- Analyzed financial data of 3 unissued trust products, calculated risk level, and evaluated the investment potential.
- Supported investment strategy adjustments by using Vintage analysis and mobility models to deal with post-investment data of 4 issued trust products, providing valuable insights that led to more effective asset.
- Organized fiduciary agreements for investors and cooperated with account managers to write 3 application reports
Jun 2019 - Jul 2019
Team & coworkers
Colleagues at XSUNT Corporation
Other employees you can reach at xsunt.com. View company contacts for 12 employees →
SQ
Stanke Qin
Colleague at Xsunt Corporation
China, China
View →
MF
Mengyang F.
Colleague at Xsunt Corporation
New York City Metropolitan Area, United States
View →
VM
Việt Mai
Colleague at Xsunt Corporation
Ho Chi Minh City, Vietnam, Viet Nam
View →
秦
秦海雷
Colleague at Xsunt Corporation
Putuo District, Shanghai, China, China
View →
RP
Rushil Patel
Colleague at Xsunt Corporation
Bucks County, Pennsylvania, United States, United States
View →
SS
Shangyi Sun
Colleague at Xsunt Corporation
Princeton, New Jersey, United States, United States
View →
VS
Vasyl Stolyarchuk
Colleague at Xsunt Corporation
Ukraine, Ukraine
View →
AN
Anh-Duc Nguyen
Colleague at Xsunt Corporation
Vietnam, Viet Nam
View →
EC
Eugene Chepurko
Colleague at Xsunt Corporation
Ukraine, Ukraine
View →
TW
Tracy Wu
Colleague at Xsunt Corporation
Greater Philadelphia, United States
View →
Stanke Qin
Colleague at Xsunt Corporation
China, China
View →
MF
Mengyang F.
Colleague at Xsunt Corporation
New York City Metropolitan Area, United States
View →
VM
Việt Mai
Colleague at Xsunt Corporation
Ho Chi Minh City, Vietnam, Viet Nam
View →
秦
秦海雷
Colleague at Xsunt Corporation
Putuo District, Shanghai, China, China
View →
RP
Rushil Patel
Colleague at Xsunt Corporation
Bucks County, Pennsylvania, United States, United States
View →
SS
Shangyi Sun
Colleague at Xsunt Corporation
Princeton, New Jersey, United States, United States
View →
VS
Vasyl Stolyarchuk
Colleague at Xsunt Corporation
Ukraine, Ukraine
View →
AN
Anh-Duc Nguyen
Colleague at Xsunt Corporation
Vietnam, Viet Nam
View →
EC
Eugene Chepurko
Colleague at Xsunt Corporation
Ukraine, Ukraine
View →
TW
Tracy Wu
Colleague at Xsunt Corporation
Greater Philadelphia, United States
View →
2 education records
Yiran Yan education
Master Of Business Analytics, Business
Bachelor Of Business Administration - Bba, Business Administration, Business Analytics
FAQ
Frequently asked questions about Yiran Yan
Quick answers generated from the profile data available on this page.
What company does Yiran Yan work for?
Yiran Yan works for XSUNT Corporation.
What is Yiran Yan's role at XSUNT Corporation?
Yiran Yan is listed as Data Analyst | Proficient in Python, R, SQL & Data Visualization at XSUNT Corporation.
Where is Yiran Yan based?
Yiran Yan is based in New York City Metropolitan Area, United States, United States while working with XSUNT Corporation.
What companies has Yiran Yan worked for?
Yiran Yan has worked for Xsunt Corporation, Kantar, Lehigh University, Accenture, and Shanghai Pudong Development Bank.
Who are Yiran Yan's colleagues at XSUNT Corporation?
Yiran Yan's colleagues at XSUNT Corporation include Stanke Qin, Mengyang F., Việt Mai, 秦海雷, and Rushil Patel.
How can I contact Yiran Yan?
You can use AeroLeads to view verified contact signals for Yiran Yan at XSUNT Corporation, including work email, phone, and LinkedIn data when available.
What schools did Yiran Yan attend?
Yiran Yan holds Master Of Business Analytics, Business from Lehigh University.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trialPeople with similar names
Check these profiles if this is not the Yiran Yan you were looking for.
View similar profiles
