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