Data Analyst, Social + Paid Media

Company Description Pereira O’Dell is an independent creative agency that lives for the big swings. We believe that it’s in that pursuit of finding something bigger - something better than what exists - where we discover what really matters to people and brands. At Pereira O'Dell, we bring big ambitions to life. For the past 15 years, we’ve been pioneers at the intersection of technology, advertising and entertainment – and when these cultures collide, incredible things happen. Founded in 2008 by Andrew O’Dell and PJ Pereira, Pereira O'Dell is a full-service creative agency with offices in San Francisco and New York. Clients include IHOP, Midea, Zelle, Fifth Third Bank, General Mills, ABInBev, Simplisafe, and The Nature Conservancy. Pereira O'Dell has amassed over 100 respected Advertising and entertainment awards including Cannes Lions, Clios, D&AD, One Show, ANDY, Effie, and an Emmy Award. Job Description Position Summary The social + media data analyst role is responsible for pulling, transforming, and analyzing data sets (from organic social/media/website/campaign) to provide actionable insights and aid with data-driven strategies. The role will be responsible for the development of forward-thinking insights derived from social media data, digital/paid media data, publisher reporting, and social listening tools to help guide strategy and creative, as well as contributing to the development of the holistic measurement approach for assigned clients and projects. This is a hybrid position in our NYC or SF offices; the role will be responsible for aiding both NY and SF office accounts. Preference for hybrid candidates based in the NY / tri-state area (or secondarily SF or LA). Remote options open for discussion. Essential Duties & Responsibilities • Identify and ensure alignment on key performance indicators for organic social and paid media campaigns • Develop and execute monitoring and measurement plans based on objectives and agreed-upon KPIs • Gather data from third-party tools as well as owned channels and native platforms to generate ongoing performance reports and dashboards • Analyze data sets (social media–organic/paid, paid media, etc.) to pull actionable insights and help evolve the overall social and media strategies • Structure and analyze informative reports and dashboards to aid organic social teams and digital/paid media teams in campaign optimizations • Work with publishing partners to structure reporting cadences and delivery dates • Collaborate across departments to communicate insights and findings • Present key findings and insights to clients throughout reporting cycles Required Knowledge, Skills, and Abilities • 1-3 years of professional work experience within an agency or brand setting • Must have a background in analyzing data (social media, media, website) and generating reports, as well as using social listening and monitoring tools to derive insights • Ability to translate your research & observations into clear, insightful and visually stimulating presentations that tell a compelling story • Ability to clearly and convincingly present findings and insights in a way that demonstrates the value of the data and analysis to clients • Experience using social listening tools and content publishing tools (i.e. Brandwatch, Meltwater, Sprinklr, Emplifi, etc.) • Experience with reporting dashboard tools like Tableau, Domo, and Power Bi • Excellent written and verbal communication skills with ability to present ideas and information clearly; keen eye for detail also required • Experience and comfort level presenting to clients and key agency stakeholders Nice to Have • Experience using platforms such as Meta Business Suite • Experience with Google Analytics and/or Adobe Analytics • Experience brand health partners like Kantar Millward-Brown and Nielsen Additional Information The annual salary range for this position is $65,000 - $85,000. The salary an employee or prospective employee is paid within this range will depend on factors such as but not limited to: internal compensation of current employees in similar roles, market considerations, budgetary considerations, level of responsibility, background, experience, and qualifications. In addition to base salary, this position is eligible for an incentive bonus structure. Full-time employees enjoy a competitive benefits package for you and your dependents to ensure a healthy lifestyle. Our benefit offering includes: medical, dental, vision, basic and supplemental life & AD&D, 401(k) with company match, short-term and long-term disability, HSA, FSA, and maternity/parental leave. Pereira O'Dell is an Equal Opportunity Employer and participant in the US Federal E-Verify program. At this time, we are not accepting resumes or candidates from third-party vendors.