Job description
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!
The Media Data Sciences team partners with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending.
The Analyst supports all aspects of data processing for subsequent analysis and performance reporting.
Roles & Responsibilities
- Assist in the development of SQL stored procedures, views, functions, performance tables, and well-tuned queries. Analyze and profile data contained in relational databases using both SQL query language and DBMS business tools.
- Monitor and manage data quality processes and data integrations. Perform corrective and evolutive maintenance of all the data exchange and data solution processes. Make sure the data platforms and processes are running well, both in data collection, integration and processing.
- 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 to manage data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners. Proactively identify and communicate barriers to complete work requirements.
- Collaborate in the development of dynamic reports that enable end users to define numerous parameters that allow users to filter and aggregate data as required. Create custom reports that allow end users to drill down on dimensions for more detail.
- Coach, guide and support the team of data management and insights analysts. Make sure that knowledge transfer flows in both directions, establish the protocols to guarantee knowledge transfer.
Minimum Qualifications
- Demonstrate a good level of proficiency with SQL as evidenced by the ability to:
- Execute advanced SQL queries and Stored Procedures to process and automate data.
- Optimize query performance, improve processes, diagnosis problems.
- Implement best-practices on database schemas and ETL processes using Talend ETL suite
- Bachelor's degree typically in a quantitative discipline (e.g., Statistics, Economics, Mathematics, Engineering)
- Minimum of 1 year of experience in a professional services or corporate environment
- Higher level of proficiency with the following tools - SQL, Excel, Adverity, Domo, Talend
- 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
- Familiarity with various online and offline media channels
- Knowledge of programming languages such as Python.
Desirable Qualifications
- Advanced degree typically in a quantitative discipline
- Prior media analytics experience/knowledge
- Greater ability to program in Python and Java
- Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design
The salary range for this position is $70,000.00 - $90,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
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: disabilityaccommodations@mediahubww.com - 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
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.