Campaign Analyst

Job Description

About the job

Role: D&T Analyst II

Location: Mumbai, Hybrid

budget: upto 25LPA

FMCG Giant(American MNC)

The Digital and Technology team is looking for a passionate and

enthusiastic individual to manage marketing mix initiatives at the company in capacity of D&T

Analyst II specialised in Media Marketing and Measurement. This role will report into Assistant D&T

Manager – Data Foundations, Commercial Operations in India and functionally collaborate with

Global Enterprise Team, CMI OU Leads, Multiple Media agencies and various vendor partners. It is

an Individual contributor role. In this role, the incumbent will lead efforts to harmonise media data

mapping across platforms to appropriate OU/Plans to provide leadership view on media spends &

ROI, Planned Vs actuals, Paid vs Earned impression. Additionally engage in Digital Deep Dive

initiatives and support various data steward responsibilities such as maintain Nielsen dictionary,

new products attributes and Adhoc data requests.

Role Responsibilities

• Create and sustain strong relationships/communication with a broad array of internal

stakeholders to gain business context and with external partners to ensure the data meets

business needs

• Manage multiple workstreams and lead process improvement initiatives to improve time

to value for data

• Keep track of media engagements for our brands and maintain harmonised

mapping/data validation process for weekly, bi-weekly, and monthly reporting.

• Understand how data sets are organized and structured; including what it is, the

relationships, and how it can be used for informed analysis

• Strong working knowledge of Media Data (Coupons/Social/Digital/Traditional) including

exposure on Retail Media for measurement and optimisation, comfortable in adopting new

tool/technology leveraged by us and agency partners & become an SME

• Lead Spends data collection process at desired frequency, assign spends to measures using

mapping and further align it to impressions for determining CPM, lead coordination efforts

with media agencies/MMIX leads for troubleshooting spends gap

• Champion the Media Deep Dive initiatives, facilitate adding creatives in existing process

and support onboarding new media partner with constant Ad hoc data requirements

• Apply Agile Methodology to deploy change requirements via preferred methods accounting

for priorities, time, and resources

• Effectively communicate data issues, challenges, and opportunities to business

stakeholders and as business consultant transform business requirements in easy-tounderstand

tasks and assist Tech Team/Vendor partners in data logics used across MMIX

• Should be comfortable to work on large data sets, Google Ad Manager, Google campaign

manager, Google research techniques to troubleshoot and identify data

concerns/appropriate mapping fixes

• Keep project notes and projects documents updated and verified

• End to end project management on multiple projects that are in progress and planned

Must – have technical skills and experience

• 8+ years of experience in Marketing/Advertising/Mass Media in CPG (or related) industry,

• Professional certification in Digital Marketing and Analytics/Advertising/Media Marketing

• Passion for data governance; driving data quality via data application and understanding

across an organization

• Exhibit a learning mindset and curiosity about consumer behaviour, types of consumer data

and application

• Proficiency in GCP, SQL/Big Query, Advance excel functionalities, relational databases, and

any data harmonisation tool

• Excellent analytical and prioritization skills, ability to multitask

• Ability to manage multiple stakeholders/Vendors and businesses/teams together

• Strong organizational skills, Data Management skills and attention to detail

• Continuous Improvement mindset

• Excellent communication skills- verbal and written, problem solving

Good to have skills

• Bachelors/Masters in Marketing/advertisement/mass media & communications

• Agile Scrum master certification

• Understanding of Point of Sale, Syndicated and Consumer Data

• Experience in Market Research, Market Mix Modelling is preferred

• Experience in data governance & data design frameworks

• Technologies – Google Cloud Platform, Tableau, SAP, DDL/DML, RPA, ETL/ELT , Microsoft

Azure,AWS, GCM (Google Campaign Manager)