Responsibilities

• Collect data from various 3rd -party ad servers, like Google Campaign Manager and others, to feed a centralized database
• Pull digital media performance data (e.g., programmatic and social) from a centralized database utilizing SQL
• Clean and analyze the data to derive actionable insights for media performance reports
• Write clear concise PowerPoint presentations summarizing data insights including their outcomes and implications in a straight-forward and actionable way
• Cross-functional team coordination and communication (Advertising Operations, Media Strategy and Investment, Creative Partners, etc.)
• Manage and use our proprietary business intelligence tools (e.g., Power BI, Tableau, Datorama, Looker)

Requirements

• B.A. or B.S., preferably in Mathematics, Statistics, Computer Science, Marketing/Advertising or related field
• 2+ years of experience working with large data sets or conducting quantitative analysis
• Knowledge of Digital Media, Marketing/Advertising industries highly preferred
• Experience working with relational databases, SQL
• Strong communication, storytelling, and presentation skills
• Ability to speak and write professionally
• Ability and comfort with client presentations, both online and in-person Page 2 of 2
• Ability to independently manage projects, prioritize competing deadlines, and drive work forward with minimal oversight
• Proficiency in Microsoft Office software such as Word, Excel and PowerPoint or G Suite (Docs, Sheets, Slides)
• Ability to service clients, partners and internal stakeholders by understanding needs, translating those needs into creative solutions, and delivering on those solutions with diligence and a sense of urgency

Preferred

• Agency experience highly preferred
• Knowledge of digital media, marketing/advertising industries
• Knowledge of digital media metrics (Impressions, Clicks, CTR, CPM, etc.)
• Experience in managing or analyzing online advertising media channels, especially Display, Video, Programmatic, and Social
• Familiarity with ad-servers (e.g., Google Campaign Manager, DSPs, Social platforms)
• Experience with third-party research partners such as Nielsen, ComScore, Millward Brown Digital, GfK, or Dynata
• Experience in BI tools (PowerBI, Tableau, Datorama, Looker)
• Knowledge of basic statistics (descriptive, linear regression)

Benefits

• medical coverage
• dental
• vision
• disability
• 401K
• parential and family care leave
• family forming assistance
• tuition reimbursement
• flexible time off