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.
This person will be responsible for: - 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 - 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 and 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
Success in this role looks like: The successful candidate must thrive in a dynamic, fast paced setting and to able to provide high-quality analytical skills under tight, constantly shifting deadlines. At least two years of experience (including internships) in a professional services or corporate environment.
- Four-year degree. Preferably in statistics, economics, or mathematics. - 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
Demonstrated base level of proficiency with at least two of the following tools - SQL, Excel, 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 - Join tables
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
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)
MullenLowe is an EEO/AA M/F/Disability/Vet Employer. MullenLowe participates in E-Verify.