Business Data Analyst
CurrentJob Responsibilities• Translated business customer requests into actionable KPIs and models• Presented key analytics content in meetings to business customers, including executive management• Architected and maintained Google Analytics, BigQuery and subscriber data sets• Regularly designed dashboards and forecast models to facilitate cross-team communication and insights• Facilitated cross-department communication by leading regular performance meetingsProject: Audience Management Platform (AMP)• Architected an Audience database with all aspects of subscriber and route data for ease of reporting• Cleaned and transformed data from multiple data sources using SSIS for ETL• Wrote complex queries to aid data insightProject: 2016 Subscriber Forecast• Data modeled projections for month by month conversions for 2016• Projected new subscriber revenue to provide company-wide financial budget and planning• Led bi-monthly goal comparison meetings to allow executives to monitor and adjust business strategyProject: Checkout Funnel• Analyzed the checkout funnel in depth to allow for conversion improvements of over 9% above goal• Suggested data-driven funnel improvements and A/B tests to increase the conversion rate• Created dashboards of funnel and conversion rate data to allow executives to monitor performance
