Data Analyst/Sr.Analyst - IPG Mediabrands - US Shift- Pune Location

Greetings from IPG Mediabrands!!

IPG Mediabrands

Pune, India

Analytics & Reporting

Mediabrands is a leading marketing services company, providing clients expertise in the full spectrum of communication needs. We are currently looking for a Campaign Executive to join the Ad Operations team who will be responsible for servicing some of the premium brands across several industries. Ad Operations plays a key role in driving technology, innovation and insights within the digital landscape. The successful candidate will be someone who works well in a fastpaced dynamic environment and understands the sense of urgency and attention to detail inherent in delivering successful media campaigns.

Position Overview

Combines data, analytics and tech approaches to help clients improve marketing ROI. Determines how, where and when clients should invest in marketing levers. Creates a clear and differentiated competitive advantage by combining best-inclass data, measurement and analytics, as well as media buying and investment expertise. Identifies, activates, and measures against high-value audiences. Analyzes holistic omnichannel business performance. Optimizes media for future performance. Provides continued analysis to drive positive business outcomes.

Responsibilities

• Pulls requisite data from multiple sources using automated approaches. Cleans and ensures the integrity and accuracy of data using standard processes. Performs regular data quality checks including comparison. Responsible for data processes such as ETL (extract, transform and load)
• Builds and updates presentations, analytical dashboards and simulation applications to support clients and internal teams. Leverages existing data reporting templates and routines.
• Loads models into optimization platform. Runs optimizations and simulations, as directed.
• Writes scripts to automate or process data, with guidance. Relatively new to programming languages (e.g., Python and SQL)
• Participates in and is prepared for client meetings. Takes notes in meetings. • Documents processes and follows best practices.

Required Skills and Experience

• Data Analysis: Summarizes large quantities of quantitative and qualitative information to discover useful information and conclusions that can be used to form insights (Basic)
• Minimum 1 to 3 years’ experience in SQL, Excel and Tableau.
• Working knowledge of various audience software and applications, including data visualization applications and statistics packages (Basic)
• Communication: Communicates clearly and succinctly in both verbal (e.g., small group presentations) and written formats (e.g., research papers) (Basic)
• Business Process: Knowledge about the motivation behind Mediabrand processes, reasons for their existence, and the process structure and logic, including the required resources for their execution (Basic/Limited)
• Domain Expertise: Knowledge of data science and modeling and application within media and marketing industry (e.g., how media planning/buying works and entire media landscape) (Basic
• Comfortable to work in the US shift (09:00 PM to 06:00 AM)