Mediahub 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!
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 Analyst is responsible for gathering and preparing data and conducting analyses using various tools in support of the delivery of analytic solutions.
Develop a basic understanding of client’s industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs
Gain a basic understanding of the digital and media ecosystems including primary channels, digital tracking and large media platforms, and privacy requirements in media tracking
Collaborate with internal/external stakeholders on data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners
Access collected data and thoroughly QC and prepare the data for subsequent analysis
Conduct various analyses and reporting leveraging at least two of the following tools - SQL, Excel and Tableau
Demonstrate a base level of proficiency with SQL as evidenced by the ability to:
De-duplicate data in database tables using queries
Leverage database functions to calculate metrics
Demonstrate a base level of proficiency with Excel as evidenced by the ability to:
Use functions such as VLOOKUP, XLOOKUP to correct data
Use SUMIFS, SUMPRODUCT, etc. to create reports
Create pivot tables to summarize data
Demonstrate a base level of proficiency with Tableau as evidenced by the ability to:
Create basic calculated fields and basic visualizations such as tables and bar charts
Create dashboards that convey basic information and publish to a Tableau Server
Exhibit an ability to interpret/synthesize analysis findings and draw insights pertinent to the client’s business
Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables
Limited participation in the presentation of results to internal and external stakeholders
Answer questions about data sets and analyses and maintain project documentation
Document and articulate steps taken in an analysis to project managers
Effectively manage time in order to meet deadlines with high-quality outputs on a limited number (1-4) of concurrent projects / demonstrate ability to multi-task
Proactively communicate with supervisor regarding workload and the status of assignments
In addition to the execution of projects, begin to participate in project design and planning
Actively seek out opportunities to perform next level (Sr. Analyst) tasks
Develop a basic understanding of Mediahub capabilities and how analytic services fit into the broader client picture
Education: Bachelor’s degree required (e.g., Statistics, Economics, Mathematics, etc.); advanced degree typically in a quantitative discipline desired
Experience: Up to 2 years of experience (including internships) in a professional services or corporate environment; prior media analytics experience/knowledge desired
Software: Demonstrated base level of proficiency with at least two of the following tools - SQL, Excel, Tableau; Experience with Alteryx is preferred; Ability to program in other languages such as SAS, SPSS, R and Python desired
Working knowledge of MS Office; including PowerPoint, Word and Excel
Acute attention to detail (QA/QC)
Strong analytic thought process
Good verbal and written communication skills
Motivated and collaborative team player with strong interpersonal skills
Familiarity with various online and offline media channels
Other duties as assigned*
BENEFITS OF JOINING MEDIAHUB:
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:
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 accommodation for any part of the employment process due to a physical or mental disability, please send an email to: email@example.com - please include your location in the subject line of your email (BOS, NY, LA, WNS)
Mediahub is an EEO/AA M/F/Disability/Vet Employer. Mediahub participates in E-Verify.