Yash Shah

Master's

Computer Science

Getty Images

Senior Business Analyst Content Planning and Analysis

- Executed advanced SQL queries in Snowflake to handle ad-hoc data requests, frequently interacting with senior leadership and executives to deliver insightful data analysis and visualizations that support strategic decision-making - Configured and managed automated ETL jobs using Python (Snowflake & Hive) within Apache Airflow, reducing data processing time by 30% and ensuring seamless data integration - Created and maintained monthly Looker reports on content supply health and contributor royalties, identifying key improvement areas and reducing contributor attrition risk by 8 - Directed A/B testing on customer search behaviors using Python, collaborating with Product and Search teams to enhance search - Analyzed affiliate marketing conversion data to pinpoint high-converting search terms, driving a 20% increase in product downloads and subscriptions through strategic asset acquisition - Identified inefficiencies in re-download allowances, proposing changes that could save $4M annually in royalties without affecting upsell - Conducted strategic content acquisition, leveraging data analytics to achieve a 4x ROI by identifying high-value assets and optimizing - Led the categorization of editorial assets into sports leagues and entertainment event lists using Python (PySpark) in Amazon EMR Studio