Greater New York City Area
Crucial contributor to internal Data Reporting Platform based on Looker. Model supported over a dozen separated clients, and included Explores for Financial Reconciliation, Pacing, Platform-specific reporting, and Cross-Platform Daily Reporting. Maintained data integrity and performance using newest Looker techniques.
Worked very closely with Finance team to create custom Explores which allowed them to move off of long-standing Excel reports for Reconciliation and Billing-monitoring tasks saving them dozens of man-hours per week and improving consistency of analysis.
Ran Looker introductory workshops in the NY office. Held smaller team-based introductions and QA sessions discussing how Looker could help Media and Client Service teams perform tasks. Created documentation outlining how to navigate our models, which explores to use, and tips to more efficiently use the product. Acted as an ambassador promoting Looker as the preferred data analysis tool.
Acted as the go-to guy for solving data issues. Created dashboards and Looks in Looker to highlight data issues, created technical documentation demonstrating systemic issues and recommending engineering solutions. Advised on best practices for data ingestion and how to monitor for data inconsistency.
Embraced the role of SQL/ database expert for ad-hoc investigations and data pulls. Coached junior team-members in familiarizing themselves with our tools and systems.