Sarah Will Email & Phone Number

Cupertino, California, Us

Cupertino, California, Us

- Promoted to newly created position to oversee and lead the path for News Org analytics team’s growing reporting needs. Focused on increasing analyst productivity through reporting process optimizations and increasing data actionability among business stakeholders by improving report accessibility - Productionized reports for other analysts in an internal consultant role, focusing on query optimization to reduce code run time and streamlining output structure to minimize manual data manipulation- Established org’s first Tableau Server site, overseeing site administration and creating and publishing Tableau dashboards to increase team’s bandwidth for report generation- Served as team liaison to Data Engineering team, creating requirements and guiding execution of analytics-focused projects, including data and automation job validation during Hadoop cluster migration- Guided multiple sub-teams supporting different business stakeholders in KPI creation, ad hoc analysis direction, and report structure, focusing on clear distillation of analytic insights for senior management and executive consumption

Cupertino, California, Us

- Part of the startup phase of the analytics team supporting the first party iOS app News, launched in Fall 2015, participating in all aspects of the data cycle, from requirements gathering, data instrumentation, warehousing, and data quality assurance to analysis, reporting, and visualization- Managed ongoing requirements for executive-level daily and weekly reporting, proactively adjusting metrics as business conditions warranted and enhancing KPIs based on continual user feedback- Primary analyst for numerous product features, responsible for determining KPIs based on detailed knowledge of app function and business objectives. Performed feature performance analyses through aggregation billions of records using SparkSQL and created executive-level presentations that succinctly conveyed data findings and business recommendations - Served as the analytics lead for three Editorial teams, including two internationally-based teams. Used data expertise to recommend appropriate metrics to address both day-to-day workflow improvements and longterm business goals. Created standard reporting frameworks and automated outputs for recurring needs, and designed and executed ad hoc analyses for pre/post analyses of changing business strategies- Managed project to bring online a data aggregation system to support externally-facing customer dashboard, designing appropriate data collection structures while balancing distributed data systems collection best practices with data querying speeds to support the real-time requirements

Alexandria, Virginia, Us

- Primary Data Analyst for Email Operations team, focused on improved email performance through standardized and ad hoc reporting. Performed a comprehensive email segmentation analysis, identifying and outlining numerous customer segments to target differently based different behaviors. Coordinated with operations team to design testing plans, analyze A/B test results, and plan test iterations based on findings- Used SQL to aggregate large datasets and Microsoft Excel pivot tables and advanced functions to perform complex analyses and set up dashboards using ODBC connections- Created data visualizations and dashboards in Tableau while pioneering centralized data reporting for improved data communication- Implemented a data request prioritization system to handle the data needs of over 70 employees- Oversaw production of and maintained a suite of product affinity models and helped guide marketing decisions based on model results- Fostered an environment of appreciation for data, ranging from training other employees to use SQL, creating documentation and leading classes about the structure of internal databases, and formation and curation of an internal listserv of SQL and Excel tips

Charlottesville, Va, Us

- Lead Analyst and Project Lead for multiple fraud detection models, balancing the needs of multiple clients and projects at the same time- Used SAS Enterprise Guide and Base SAS to gather, cleanse, and manipulate data and perform open-ended analyses of large data sets- Designed, implemented, and maintained unsupervised, semi-supervised, and supervised modelsImplemented software deployment strategies for custom tools- Served as business liaison between the software engineering team and the client to design custom dashboards for predictive models, balancing internal capabilities with customer needs and expectations- Assisted in writing project proposals in response to RFPs, including outlining, editing the final draft, and assembly of complex proposal packets

Washington, Dc, Us

- Analyzed and manipulated large datasets using Base SAS- Worked daily in SAS to gather data and perform analyses. Worked with Base SAS, SAS/STAT, and SAS/GRAPH

Philadelphia, Pennsylvania, Us

- Wrote grant proposal for and implemented test pilot of reusable to-go containers from dining halls- Designed and carried out study of napkin usage with different napkin dispenser configurations- Spear-headed and implemented plan to reduce waste by switching to bulk condiment dispensers- Organized pilot food waste composting program for largest dining hall on campus