Mediahub is one the hottest and fastest growing media shops in the U.S. We’ve been honored as Ad Age's Media Agency of the Year, a Leader in Forrester's first-ever wave of major media shops, and Adweek's U.S. Media Agency of the Year.
Mediahub's Analytics group applies analytic rigor, data-driven and fact-based reasoning to guide the development and execution of advertising and marketing strategies for clients. Specifically, we adopt statistical modeling methodologies and performance insight techniques to maximize the ROI of marketing and advertising across offline and digital channels. We seek entrepreneurial individuals with a background in business and marketing performance analysis and a passion for translating data into actionable insight. This role will be exposed to online display advertising, search marketing, social media, site analytics, consumer insights, brand equity analytics, and market/audience segmentation.
The Sr. Data Analyst takes on an expanded role and supports all aspects of data processing for subsequent analysis and performance reporting.
Roles & Responsibilities
Collaborate with internal/external stakeholders and manage media data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners.
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.
Conduct more in-depth analyses and reporting leveraging the following tools - SQL, Talend and Tableau.
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 to other data analysts.
Build large-scale batch and real-time data pipelines with data processing platforms like Adverity, Domo, Datorama, AWS RDS and Google Cloud Platform.
Help drive media optimizations by integrating data from different media sources. data testing and validation to improve campaign insights quality.
Make sure the data platforms and processes are running well, both in data collection, integration and processing. • Monitor and manage data quality processes and data integrations. Perform corrective and evolutive maintenance of all the data exchange and data solution processes.
Success in this role looks like:
The successful candidate has the ability to juggle multiple projects and should be driven, detail-oriented, amicable, a strong collaborator and hungry to do great work.
Four-year degree. Preferably in statistics, economics, or mathematics
Two to four years of media analytics experience
Greater familiarity with various online and offline media channels
Experience with data management and visualization tools, preferably Tableau and SQL is a MUST
Attention to detail and time management to deliver high quality work for multiple projects across several client engagements while meeting deadlines.
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
Demonstrate a greater 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 Adverity, Domo or other ETL and data aggregation tools.
Advanced degree typically in a quantitative discipline
Greater ability to program in other languages such as SAS, SPSS, R and Python
Must be presently authorized to work in the U.S. for any employer without current or future need for visa sponsorship. Reimbursement for relocation not offered. MullenLowe does not accept agency resumes and is not responsible for any fees associated with unsolicited resumes.
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.