New York Seasonal Jobs

Job Information

Mullen Lowe Senior Analyst, Campaign Insights in New York, New York

Mediahub Worldwide is a global media planning and buying company with over 900 employees worldwide. We are an award-winning agency built for challenger brands - those disrupting the status quo and looking to reinvent how to reach consumers and measure success. Our smart and nimble team consists of key verticals including Insights + Action (Comms), P3 (Search, Paid Social & Programmatic), and our creative media group, the R+D (Radical + Disruptive) Lab, which specializes in working with avant-garde media partners to develop ideas that consumers seek out, share and talk about.

As one of the three major Interpublic media agencies (NYSE: IPG), we are powered by the buying and intelligence power of Magna Global and the data and tech backbone of Kinesso. We're proud to have been named Adweek's 2018 U.S. Media Agency of the Year and Ad Age's 2019 and 2020 Media Agency of the Year.

Our mission? To be an agency that attracts, retains, and promotes outstanding employees of all backgrounds, perspectives, and abilities while fostering an accepting, antiracist culture and atmosphere where all employees can do their best work and feel safe, fulfilled and appreciated. We hope you will join us!

Position Overview

The Campaign Insights team partners with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending. The Senior Analyst takes on an expanded role and supports all aspects of analytic initiatives from conception to completion.
Responsibilities

Develop a deeper understanding of client's industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs

Help develop measurement plans tying KPI's to business objectives at a tactical level

Build an understanding of digital and media ecosystems including challenges of data tracking with cookies/SDK's, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options available

Collaborate with internal/external stakeholders and manage data logistics - including data specifications, structures, rules and transfers from numerous media channels and partners

Act as a project manager on analyses of limited scope/complexity, delegating select tasks such as data prep and QC to Analysts and reviewing their work / Serve as a mentor

Conduct more in-depth analyses and reporting leveraging at least two of the following tools - SQL, Excel and Tableau

Demonstrate a greater level of proficiency with SQL as evidenced by the ability to:

Execute advanced SQL queries such as Stored Procedures to process and automate data

Optimize query performance, improve processes, diagnosis problems

Implement best-practices on database schemas and ETL processes

Demonstrate a greater level of proficiency with Excel as evidenced by the ability to:

Create macros to clean data from different workbooks and automate repetitive tasks

Use IF, THEN, SUMPRODUCT, OFFSET, etc to create more advanced reports

Pull data from external data sources using Excel's ODBC connectors

Create more advanced pivot tables using calculated fields

Demonstrate a greater level of proficiency with Tableau as evidenced by the ability to:

Perform data blending procedures directly in Tableau

Use calculated fields and parameters to create interactive visualizations

Build advanced visualizations. (e.g. graphs with multiple axes, mapping geographic data to perform segmentation analysis, etc)

Exhibit problem-solving capability and an ability to work more independently

Demonstrate a deeper ability to interpret/synthesize analysis findings and draw insights pertinent to the client's business; show ability to develop actionable recommendations

Play an expanded role in the development of report content (Word, Excel, PowerPoint) in support of deliverables

Greater participation in the presentation of results to internal and external stakeholders

Handle some of the day-to-day contact and interaction with internal and external stakeholders associated with project work

Effectively manage time in order to meet deadlines with high-quality outputs on a larger workload; demonstrate greater ability to multi-task

Take on broader responsibility and independence in project design and planning - including resource scoping and timelines and the identification of potential bottlenecks and risks

Actively seek out opportunities to perform next level (Manager) tasks

Develop a deeper understanding of Mediahub capabilities and how our analytic services fit into the broader client picture

Qualifications

Education: Bachelor's degree required (e.g., Statistics, Economics, Mathematics, etc.); advanced degree typically in a quantitative discipline desired

Experience: Minimum of 2 years of experience in a professional services or corporate environment; prior media analytics experience/knowledge desired

Software: Higher level of proficiency with at least two of the following tools - SQL, Excel, Tableau; Greater ability to program in other languages such as SAS, SPSS, R and Python desired

Greater facility of MS Office; including PowerPoint, Word and Excel

Experience with ad-serving platforms such as Google Campaign Manager; web analytics tools such as Google Analytics and Adobe Analytics, and tag management tools such as DTM/Launch, GTM and Tealium

Excellent verbal and written communication skills

Highly motivated and collaborative team player with strong interpersonal skills

Greater familiarity with various online and offline media channels

Experience with DMPs such as Adobe Audience Manager; familiarity with MTA providers such as Visual lQ (Nielsen), Neustar, C3 desired

Experience with audience tools such as SCOUT (Mediahub quantitative surveying), Comscore, MRI, Exact Target; creative/brand evaluation and tracking tools like Kantar Millward Brown, Nielsen Brand Effects, YouGov, Dynata, Survata; search tools like Adwords, Kenshoo; social tools like Crimson Hexagon, Netbase desired

Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design desired

The salary range for this position is $90,000.00 - $120,000.00.

Where you are paid within this range depends on, among other factors, actual ranges for current/former employees in the subject position; market considerations; budgetary considerations; tenure and standing with the company (applicable to current employees); as well as your background, pertinent experience, and qualifications.

Here at Mediahub Worldwide, we believe that being together in person creates an energy that allows for innovation and collaboration. With that said, we are committed to remaining flexible and embrace different ways of working. As of January 2023, Mediahub Worldwide has adopted a flex work model in which employees work from their dedicated office at least one day per week.

BENEFITS OF JOINING Mediahub Worldwide:

One of our primary goals is to support the health and well-being of you and your family. Our compensation plan includes the following benefits, in addition to many others:

We believe that being together in person creates an energy that allows for innovation and collaboration. With that said, we are committed to remaining flexible and embrace different ways of working. Mediahub Worldwide has adapted a flex work model which requires you to be within commutable distance of your dedicated company office (within 2 hours).

Healthcare Options

Medical

Dental

Vision

Prescription Coverage

Dependent and Health Care Flexible Spending Accounts

401(k) savings plan with company match

Unlimited PTO and year-round "Summer Fridays"

Paid family leave

Health and wellness support including an Employee Assistance Program, Calm/Headspace discounts, parenting resources and more

On-demand professional coaching

Legal Assistance Plan

Employee Stock Purchase Plan

Exclusive discounts on cell phones, gyms, and everyday purchases

Employees must be fully vaccinated against COVID-19 and, if hired, present proof of vaccination prior to start date, unless eligible for a medical or religious accommodation or other accommodation required under applicable law.

You must be eligible to work in the United States to be considered for this role.

This job description is subject to change at any time.

Work is regularly performed in a professional office environment and routinely uses standard office equipment. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

ACCESSIBILITY NOTICE: If you need a reasonable accommodations for any part of the employment process due to a physical or mental disability, please send an email to: - please include your location in the subject line of your email (BOS, NY, LA, WNS, MPLS)

Mediahub Worldwide is an EEO/AA M/F/Disability/Vet Employer.
Mediahub Worldwide participates in E-Verify.

https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf

https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pd

MullenLowe is an EEO/AA M/F/Disability/Vet Employer. MullenLowe participates in E-Verify.

DirectEmployers