As Digital Marketing Analyst, you will be responsible for reporting and analyzing paid, earned, and owned media data, with an emphasis on paid media investments. This role requires a balance of analytical and interpersonal skills that will facilitate more effective media investments and better merchandising of marketing impact to our clients.
Responsibilities:
- Provide a range of reporting, including individual posts, campaign performance, monthly digital performance, audience insights, competitive analysis, and custom reporting as needed
- Liaise with areas of subject expertise (creative, site, paid media, social, etc.) to support them in understanding, summarizing, and driving insights from campaign executions
- Analyze and trend large data sets of both qualitative and quantitative information from all major social media and digital platforms, along with first party data, to present a holistic view of performance across channels
- Gather metrics, create data visualizations, and present clear analyses for collaboration with internal teams and for client presentations
- Manage data and API connections for seamless data integration
- Maintain and update the company’s tagging workflows and contribute to best practices.
- Identify opportunities to improve data pipeline efficiency, review existing and develop new reporting approaches and visualizations
- Ensure data integrity and accessibility; ensure timeliness of delivery of all reporting
- Troubleshoot issues with data queries, pipeline failures and irregularities in data output.
- Identify optimization opportunities based on key performance indicators
- Implement and manage tracking tags for paid media campaigns and for site performance
- QA UTM codes
Qualifications
- Bachelor’s degree: a major in Business, Advertising, Marketing, Economics, or Sociology are preferred
- Experience with data analysis and data manipulation with large data sets
- Advanced proficiency in Excel, Word, and PowerPoint – knowledge of advanced Excel capabilities is preferred (Power Queries, nested functions, macros, etc.)
- Proficiency in SQL and data visualization tools (Domo, Looker, PowerBI, Tableau)
- A curiosity to explore and test variables to improve future performance, as well as the ability to clearly convey results through insightful reporting practices
- Highly developed organizational skills with strong attention to detail and accuracy
- Comfort working with internal stakeholders at all levels in a way that fosters both partnership and results
Preferred Qualifications
- 2+ years of experience in Digital Marketing for a Brand or Agency, with understanding of marketing technologies (e.g., pixels, DSPs, site analytics), and marketing channels (display, search, social, video, SMS, email, etc.)
- Experience with tools and platforms such as Site Analytics (e.g., Adobe Analytics, Google Analytics 4, Google Tag Manager), DSPs, CRM (Active Campaign), SEO (AdWords), and Social (Meta Business Manager, Muck Rack, Reddit, TikTok, LinkedIn), Looker Studio, Domo
- Adobe or Google certifications on site analytics, DSP, or SEO