Senior Analyst

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

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