The purpose of this role is to deliver analysis inline with client business objectives, goals, and to maintain, develop and exceed client performance targets.

Quick Summary -

• Marketing Analyst with 2-3 years of experience in technical field
• Programming Language – SQL/Python/R
• BI/Data Viz. – Preferably Power BI (Tableau can be good to have)
• Media Platforms experience across Search, Social, Display, Programmatic (you can use keywords like Google Ads, Meta, DCM, DV360, SA360 etc. )        
• Analytics Experience in Data Reporting, QA, Marketing Measurement framework, Digital KPIs, Insight Generation

Job Description:

Analyst will use in-depth knowledge in Technical Analytics skills and an understanding of media channel based KPIs to build media campaign reporting, analyze key trends, and provide insights & recommendations. Core responsibilities also include database management, data QA and reviewing adherence to aligned data taxonomies to maintain reporting source of truth.

Key Responsibilities

• Analyze media spend, ROI, and performance metrics across key digital platforms such as Google Ads, Facebook/Instagram, DCM, DV360 and translating data into actionable insights.
• Develop and maintain advanced dashboards and reports that provide actionable insights and visualizations to stakeholders at different levels of the organization.
• Maintain, create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues.
• Work with various internal and external stakeholders to develop project plan, manage the day-to-day tasks and meet project deadlines

Required Skills

• Completion of Bachelor’s or higher educational degree
• Minimum 2-3 years of applicable working experience in a technical field
• 2+ years of experience as a Marketing Analyst
• Foundational knowledge of at least one data programming language (SQL, Python, or R dependent on existing business need)
• Intermediate proficiency in BI/Visualization tools, specifically PowerBI
• Intermediate proficiency in core Office products (Excel, Powerpoint)

• Understanding of marketing measurement frameworks and relevant KPIs
• Strong written and oral communication skills, in writing insights and delivering analysis
• Familiarity with Digital Media and Platform data sources across Search, Social, Display, Programmatic media and strong understanding of Digital KPIs
• Familiarity of relational databases (e.g., Snowflake, GCP)
• Expertise in both data connection and visual UX design of dashboards in PowerBI
• Familiarity with dentsu Connect’s Data Refinery to establish Connectors to common media platforms, build Recipes to transform data & schedule Data Serves
• Familiarity with common media platforms to QA between UIs & processed data in dentsu Connect
• Attention to detail when exporting & manipulating data for reports
• Optional: Willingness/ability to flex work hours to have some overlap with US-based teams