Analyst, Media Measurement | Involved Media | NYC

Responsibilities

• Develop and maintain dashboards in Tableau, Power BI, and Looker Studio to track marketing performance metrics and flag pacing issues.
• Use SQL queries and Excel formulas to manipulate, segment, and aggregate large data sets from platform APIs and ad-tech networks.
• Summarize technical charts and campaign results in clear performance reporting for internal and external stakeholders.
• Manage campaign pacing data and update predictive budget tracking models.
• Monitor campaign and efficiency metrics, flag performance dips, and identify media optimization opportunities for senior leadership.
• Establish data quality controls and QA validation processes to isolate tracking anomalies and reporting discrepancies.
• Maintain detailed documentation of client reporting assets, tracking links, and data taxonomy mappings for internal teams.
• Work with cross-functional teams to streamline project timelines, document technical workflows, and standardize best practices.
• Use scripting to automate analysis, data cleansing, and data integration tasks.

Requirements

• 1–3 years of experience in marketing analytics, performance marketing, advertising, or a related field preferred.
• Hands-on experience with data visualization tools such as Tableau, Power BI, and Looker Studio, with strong Excel and SQL skills for data manipulation.
• Strong written and verbal communication skills, including the ability to summarize technical charts as logical business notes.
• Ability to use scripting to automate analysis, data cleansing, and data integration tasks.
• Strong interest and ability to translate data and research into strategic insights and recommendations.
• Exposure to attribution frameworks and measurement methodologies, alongside core media metrics.
• Experience with site analytics and social platforms, including Adobe Analytics and Google Analytics.
• Enthusiasm for marketing and media, a detail-oriented and self-motivated approach, strong organizational skills, and a commitment to learning and taking initiative.

Benefits

• AMS offers a very competitive benefits package inclusive of medical coverage, dental, vision, disability, 401k, paid time off, community engagement opportunities, great colleagues, and great learning opportunities.
• Hybrid work schedule in NYC.