Associate Director, Data Enablement & Reporting (Power BI)

Location: New York, United States. Hybrid work with teams in the office around four days a week.

Salary: $75,000–$180,000 USD base salary per year.

Company

WPP Media is an AI-driven media operating unit of WPP that combines media, data, partnerships, and marketing technology to support personalized media investment and growth.

What you will do

• Lead the end-to-end data-to-dashboard workflow, including media platform extraction, transformation, quality assurance, reporting delivery, and handoff to analytics teams.
• Oversee reporting infrastructure, dashboards, visualizations, recurring deliverables, and continuous operational improvements.
• Guide the use of SQL, data modeling, extraction, transformation, and data engineering practices to build stable and scalable reporting solutions.
• Establish data quality, validation, reconciliation, mapping, parsing, taxonomy, documentation, and governance processes for paid media data.
• Investigate reporting discrepancies, perform root-cause analysis, and lead integration of new data sources and reporting connections.
• Manage and develop onshore and offshore reporting professionals while partnering with Wendy’s clients and technical and non-technical stakeholders.

Requirements

• Bachelor’s degree in computer science, information technology, engineering, business analytics, data science, marketing, or a related field, or equivalent professional experience.
• 5–7+ years of experience in business intelligence, reporting, data enablement, marketing or media data, data engineering, or a related technical discipline.
• Advanced hands-on experience with Power BI for dashboard development, maintenance, visualization, and reporting delivery.
• Strong SQL skills, including joining datasets, querying multiple data sources, and evaluating data integration approaches.
• Experience with ETL processes, data transformation, reporting pipelines, data modeling, schemas, fact tables, and dimension tables.
• Experience with paid media, digital advertising, marketing data, media analytics, ad technology, agency reporting, and leading reporting or analytics professionals.

Nice to have

• Exposure to Python, BigQuery, Google Cloud Platform, dbt, APIs, Tableau, Looker, or comparable data and reporting technologies.

Culture & Benefits

• Hybrid environment focused on collaboration, creativity, and connection.
• Medical, dental, vision, and group retirement plans.
• Significant paid time off and preferential partner discounts.
• Employee mental health awareness days and employee resource groups.
• Opportunities for professional development, networking, and access to WPP Media and WPP resources.