Jake Milstein

Senior Analyst, Advanced Analytics @Horizon Media

NY, US

Clients: Impossible Foods, Vytalogy, Kohls•Manage ETL pipelines (using Knime) that handle the ingestion and cleaning of media data before entering databases •Ensure database integrity by managing lookup tables and primary key consistency across all tables•Create interactive Tableau dashboards that track our client’s campaign performance and KPI efficiencies across Search, Social, and Programmatic channels•Build data models to assist with our Marketing Mix Model analysis that provides insight into media planning and buying for our clients.•Run SQL queries in our SQL Server database to retrieve specific cuts of data for client reporting requests