Responsibilities

• Manage data ETL to analyze the state of our clients’ businesses across a variety of systems, channels and data sources (paid search, display media, website, social media, advertising campaigns, offline media, brand sales and brand equity)
• Generate thoughtful and fully supported insights to illustrate a larger story surrounding media metrics and data trends
• Apply independent, critical thinking and reasoning to data to uncover media and marketing communications opportunities that generate business results
• Employ compelling storytelling to create reports and presentations for internal and external stakeholders
• Ensure accuracy of the data across the team
• Evaluate the effectiveness and performance of paid campaign advertising
• Support the creation and communication of KPIs, research studies and measurement plans
• Apply syndicated and proprietary research tools in support of agency and client stakeholders

Requirements

• 3+ years of experience in data reporting, analytics or ad research
• Understanding of measurement resources across media planning and placement
• Experience in written and verbal client presentations for analytic results, recommendations, POVs or predictions
• Passion for working with databases and experience developing marketing insights that advance reporting and client deliverables
• Understanding of data operating models, key media metrics, KPIs and industry standard data sources including databases, DCM and Google Analytics
• Understanding of current state-of-the-industry norms, tools and innovations
• Inductive and deductive reasoning skills
• Understanding of research fundamentals such as sample sizes, methodology and respondent weighting
• Demonstrated commitment to accuracy and strict QA processes
• Strong proficiency in Microsoft suite of products particularly PowerPoint and Excel, including knowledge of PivotTables and complex formulae

Preferred

• Solid understanding of visualization tools, SQL, Python, Google Analytics and Campaign Manager (DCM) preferred
• AdTech (ad servers, DSP, SSP), MarTech (Salesforce, Adobe), Database (AWS, SQL Server, Snowflake) preferred
• Experience in media research/analytics within an agency