Cathy Yin

Marketing Data Analyst @Menusifu

New York, NY, US

Utilized Python to process 1M+ monthly Yelp restaurant records from internal crawlers and data vendors, addressing missing attributes via K-means imputation and standardizing inconsistent city and date formats. Applied Isolation Forest to detect outliers in rating, review, and growth metrics, improving data reliability and reducing noise in market acquisition analyses.2. Queried and analyzed datasets including Ads, and CRM data using BigQuery and SQL, extracting features such as category growth rates and conversion funnels. Applied segmentation and trend analysis to identify high-potential cities and cuisine segments, directly informing sales targeting, ad budget allocation, and go-to-market strategy recommendations. Led website and advertising performance analysis using Google Analytics, tracking impressions, CTR, CPC, conversion rate, and user engagement. Conducted A/B testing and content performance analysis to guide blog topic selection and SEO optimization, improving organic traffic growth through data-driven content and keyword strategy refinement.4. Built Tableau dashboards to monitor restaurant market size, category trends, competitor positioning, and sales funnel performance. Conducted cohort and trend analyses to uncover demand patterns and whitespace opportunities. Enhanced dashboard drill-down filters across city, cuisine, and customer segments, improving market evaluation efficiency by 70%.5. Automated personalized reporting pipelines using Python and Databricks to generate and distribute Excel reports covering market trends and competitive movements. Developed reusable functions for metric calculation and report formatting, ensuring timely insight delivery and strengthening leadership decision-making on market expansion and resource allocation.

Fordham University

Master of Science - MS, Marketing Intelligence

Hohai University

Bachelor of Arts - BA, English Language and Literature & Business Administration