Data Enablement & Reporting Lead

Wppmedia; New York (NY); Hybrid; USD 75,000 - 180,000; Full time

Benefits offered by this job

Competitive medical

Group retirement plans

Vision

Dental insurance

Significant paid time off

Preferential partner discounts

Employee mental health awareness days

Job summary

WPP Media in New York is seeking a senior data enablement and reporting leader to own end-to-end data-to-dashboard workflows for the Wendy’s business, overseeing data integration, quality, and governance with onshore and offshore teams.

You will guide SQL, ETL, and modeling practices, oversee dashboards, and partner with analytics, activation, planning, data science, and clients to deliver reliable insights.

Qualifications

• 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, media analytics, data engineering, or a related technical discipline.
• Advanced, hands-on experience with Power BI, including dashboard development, maintenance, visualization, and reporting delivery.
• Strong SQL skills, including joining datasets, querying multiple data sources, and evaluating appropriate data integration approaches.
• Meaningful experience with extract, transform, and load (ETL) processes, data transformation, reporting pipelines, and data modeling, including schemas, fact tables, and dimension tables.
• Professional experience with paid media, digital advertising, marketing data, media analytics, ad technology, or agency reporting environments.
• Strong data quality and governance capabilities, including validation, reconciliation, data hygiene, taxonomy, mapping, parsing, documentation, and root-cause analysis.
• Experience working with data from search, social, Amazon, Google, demand-side platforms, or other digital media and advertising environments.
• Experience leading, mentoring, or managing reporting or analytics professionals, including collaboration with onshore and offshore teams.
• Exposure to Python, BigQuery, Google Cloud Platform, dbt, application programming interfaces (APIs), Tableau, Looker, or comparable data and reporting technologies is preferred.

Responsibilities

• Lead the end-to-end data-to-dashboard workflow, from media platform extraction and data transformation through quality assurance, reporting delivery, and handoff to analytics teams.
• Oversee the development, maintenance, and continuous improvement of reporting infrastructure, dashboards, visualizations, and recurring deliverables.
• Guide the reporting team in using SQL, data modeling, extraction, transformation, and data engineering practices to deliver stable and scalable solutions.
• Establish and maintain robust data quality, validation, reconciliation, mapping, parsing, taxonomy, and governance processes for paid media data.
• Investigate reporting discrepancies, conduct root-cause analysis, and recommend or implement solutions across source platforms, data models, transformation logic, and dashboards.
• Define requirements for new data sources and lead the team in evaluating effective approaches for data connections, joins, and reporting integration.
• Oversee reporting production and quality assurance, ensuring deliverables are accurate, consistent, timely, and aligned with business objectives.
• Manage and develop an onshore and offshore team of reporting professionals through clear priorities, coaching, collaboration, and effective work allocation.
• Serve as a trusted partner to Wendy’s clients and internal stakeholders, explaining reporting solutions and technical concepts clearly to both technical and non-technical audiences.
• Maintain comprehensive documentation and identify process improvements that streamline repetitive tasks, strengthen delivery standards, and improve reporting operations.

Skills

Power BI

SQL

ETL

Data modeling

Data governance

Data quality

Python

BigQuery

Tableau

Looker

APIs

Google Cloud Platform

Education

Bachelor's degree or equivalent

Tools

dbt

Tableau

Looker

Job description

WPP Media in New York is seeking a senior data enablement and reporting leader to own end-to-end data-to-dashboard workflows for the Wendy’s business, overseeing data integration, quality, and governance with onshore and offshore teams.

You will guide SQL, ETL, and modeling practices, oversee dashboards, and partner with analytics, activation, planning, data science, and clients to deliver reliable insights.