Senior Associate, Marketing Effectiveness

dentsu; Illinois; Hybrid; USD 68,000 - 80,000; Full time

Benefits offered by this job

Medical, vision, dental insurance

Life insurance

Disability insurance

401k

Flexible PTO

15+ paid holidays

Paid sick and safe leave

Paid parental leave

Job summary

dentsu seeks a Senior Associate, Media Effectiveness to support analytics and data operations. You will ensure data quality, enable reporting, and provide day-to-day analytical support across data pipelines and media analytics.

The role spans data engineering, QA, and client-ready insights. Ideal candidates have 1+ years in analytics, strong Excel and SQL, familiarity with CM360/TTD, and experience presenting findings.

Qualifications

• Bachelor's degree in Statistics, Economics, Data Science or related quantitative field.
• 1+ years of experience in analytics, data operations, or media reporting.
• Advanced proficiency in Microsoft Excel, including pivot tables and VLOOKUPs.
• Hands-on exposure to SQL.
• Knowledge of digital media platforms (e.g., CM360, TTD, DSP/partner data).
• Strong data QA skills with cross-source consistency checks.
• Familiarity with Tableau; ability to make minor modifications.
• Strong communication skills; client-facing exposure is a plus.

Responsibilities

• Gather and prepare data for recurring attribution solution on a weekly basis and quarterly MMM inputs, coordinating with media and strategy teams.
• Weekly, monthly and quarterly insights reporting on a channel and tactic level.
• Populate and QA weekly reports, ensuring accuracy and consistency across deliverables.
• Provide data compilation and visualization for client deliverables.
• QA and maintain taxonomy standards across media channels to ensure consistency and accuracy of reporting.

Skills

SQL

Excel pivot tables

VLOOKUPs

Tableau

Data QA

Media analytics

Data visualization

Communication

Client-facing

Education

Bachelor's degree in Statistics, Economics, Data Science or related quantitative field

Tools

CM360

TTD

DSP/partner data

Job description

Job Description: Location: open to remote candidates - must be able to work ET hours.

Overview The Senior Associate, Media Effectiveness will support our analytics and data operations by ensuring data quality, enabling seamless reporting, and providing day-to-day analytical support. This role will focus on data engineering and pipeline management and media analytics and reporting. The ideal candidate is detail-oriented, proactive, and comfortable working across multiple platforms and datasets.

Key Responsibilities

Media Analytics

• Gather and prepare data for recurring attribution solution on a weekly basis and quarterly MMM inputs, coordinating with media and strategy teams.
• Weekly, monthly and quarterly insights reporting on a channel and tactic level.
• Populate and QA weekly reports, ensuring accuracy and consistency across deliverables.
• Provide data compilation and visualization for client deliverables.
• QA and maintain taxonomy standards across media channels to ensure consistency and accuracy of reporting.

General Responsibilities

• Maintain high standards of data accuracy and integrity across all deliverables.
• Collaborate with onshore analytics and media teams to ensure timely and accurate delivery of reporting and insights.
• Proactively flag data anomalies, pipeline issues, or reporting gaps.
• Support process documentation and contribute to workflow improvements.

Qualifications

• Bachelor's degree in Statistics, Economics, Data Science or related quantitative field.
• 1+ years of experience in analytics, data operations, or media reporting.
• Advanced proficiency in Microsoft Excel, including daily use of pivot tables, VLOOKUPs, and other data analysis functions.
• Hands-on exposure to SQL.
• Knowledge of digital media platforms (e.g., CM360, TTD, DSP/partner data).
• Strong data QA skills, with the ability to identify discrepancies across sources.
• Excellent attention to detail, time management, and problem-solving abilities.
• Familiarity with Tableau; ability to make minor modifications a plus.
• Strong communication skills; client-facing exposure is a plus.

The annual salary range for this position is (68,000-$80,000).

Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• Medical, vision, and dental insurance,
• Life insurance,
• Short-term and long-term disability insurance,
• 401k,
• Flexible paid time off,
• At least 15 paid holidays per year,
• Paid sick and safe leave,
• Paid parental leave.

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies.

For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

At dentsu, we believe great work happens when we’re connected. Our way of working combines flexibility with in-person collaboration to spark ideas and strengthen our teams.

Employees who live within a commutable distance of one of our hub offices, currently located in Chicago, metro Detroit, Los Angeles, and New York City, are required and expected to work from the office three days per week (two days per week for employees based in Los Angeles). Dentsu may designate other Hub offices at any time. Those who live outside a commutable range may be designated as remote, depending on the role and business needs. Regardless of your work location, we expect our employees to be flexible to meet the needs of our Company and clients, which may include attendance in an office.

Location: USA - Remote - Illinois

Brand: Carat

Time Type: Full time

Contract Type: Permanent

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law.

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to [e-mail] by clicking on the link to let usknow the nature of your accommodation request and your contact information. We are here to support you.

About dentsu

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us Who we are Our Social Impact Our work