• Build out scalable data models to structure data and analyze key parts of the HubSpot business and own and improve key reporting for Marketing stakeholders• Build and maintain data infrastructure and develop, define, and document actionable metrics for Marketing and Revenue Operations teams to make data-driven and business decisions• Collaborate with the Business Intelligence and Data Engineering teams to transform data using dbt and implement ETL data pipelines to support automated reporting• Perform a variety of on-demand ad-hoc analytical requests and ensure data integrity and prevent discrepancies by validating data for new and existing models and reporting• Work cross-functionally to connect and train with the wider business and coordinate efforts on data, analytics and automation projects

• Identified optimization opportunities through data analysis and provided actionable insights into the products, marketing funnels, and business KPIs• Built and designed critical reporting frameworks using a mixture of analytical and visualization techniques to derive actionable insight from data using BI tools like Looker and Reportz• Developed and improved proprietary algorithms through statistical methods and scientific analysis to predict and measure outcome and consequences of design to fit user needs• Performed ad-hoc data analyses and developed data pipelines and codebase frameworks to support short-term business priorities across all functions and ensure not just the accuracy of analysis, but the accurate interpretation by team members• Partnered and collaborated with the Senior Marketing, Senior Operations, Supply Chain, Wholesale, Product Management, Merchandising, and Artist Relation teams in addition to channel owners

⦁ Improved user experience by extracting structured data from HTML documents using XPath, JavaScript, and Regex within a proprietary tool⦁ Performed qualitative analysis for user data across various Yahoo platforms including Search, Mail, and News to make product feature suggestions based on the competitive landscape and user climate⦁ Conducted Quality Assurance on team members’ work, collaborated with project leads, and contributed key insights derived from editorial work⦁ Classified and categorized diverse unstructured data and provided judgments for improving the performance of the categorizer’s algorithm

⦁ Cleaned, organized, and analyzed raw sensor data from hospital reports using MATLAB⦁ Visualized and reported systolic blood pressure and diastolic blood pressure data of each patient

⦁ Managed Statistical Yearbook database including GDP, population, and retail sales, etc. for all the cities in China and updated the database using in Excel ⦁ Provided research and operational support to senior staff to ensure the on-time and high-quality delivery of services to internal and external clients

⦁ Pre-processed the data for further research by plotting the distribution of missing values on the map for each case and removing the cases in the tail of the distribution, reducing more than 1000 cases⦁ Visualized city expansion in three different phases by drawing their boundaries on map with three different colors and showing areas and population

⦁ Managed a client relationship management database and developed digital marketing strategies⦁ Clustered the students and universities according to their information by using k-means clustering and matched student and university groups by fitting a propensity model