Senior Analyst, Analytics

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, Data Science, Social Sciences, Business Analytics, Marketing/Advertising or related field
• 2+ years of experience working with large data sets or conducting quantitative analysis
• Advanced Excel (pivot tables, index/match, string parsing formulas)
• Experience working with relational databases, SQL
• Ability to derive insight from data and develop data stories
• Ability to communicate complex ideas to internal clients
• Ability to respond to feedback from internal stakeholders
• Demonstrated strong project management skills
• Attention to detail, proactivity, and dependability

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

• Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.