On Ads Monetization at Spotify, I lead a team of five analysts in New York and London that manages a suite of a dozen daily, weekly, and monthly reports. Using Excel, VBA, Powerpoint, BigQuery, and QlikSense, we pull and transform data from a SQL Server-based data warehouse into reports for an audience that includes sales teams, sales leads, and senior and C-level leadership in Operations and Finance. I am also responsible for driving longer-term projects with our financial systems team and ads automation team that integrate new sources of data into our data warehouse for use in downstream reporting.
Previous to Spotify, I worked at Novantas, a consulting firm that focused on retail banks. I used Excel, VBA, SQL, and PowerPoint to process large data sets and synthesize the results of these data analyses into recommendations that I presented to retail bank executives.