Senior BI & Data Quality Lead (Remote)

WPP Media; México; Hybrid; MXN 480,000 - 720,000; Full time

Benefits offered by this job

Medical insurance

Paid time off

Retirement plan

Vision & dental insurance

Job summary

WPP Media in Mexico City is seeking a Senior BI Analyst to ensure partner and campaign data are accurate, complete, and ready for business intelligence reporting. You will own the data update process from intake to QA and dashboard validation to support reliable decision-making.

Responsibilities include consolidating partner data, validating fields, executing Alteryx workflows, querying SQL, and monitoring Azure Data Factory pipelines that feed Tableau dashboards.

Qualifications

• Professional BI/data ops/marketing analytics experience.
• Strong Excel/Sheets for large datasets.
• Hands-on Alteryx workflow troubleshooting.
• SQL to query/validate data across tables.
• Ability to run/monitor Azure Data Factory pipelines.
• Tableau dashboard review experience.
• Familiarity with Adverity or similar tools.
• Experience with FileZilla/FTP tools.
• Knowledge of Facebook Ads and Reddit Ads data.
• Solid data validation, reconciliation, QA processes.

Responsibilities

• Receive, review, and consolidate Partner Data files (Excel/ Sheets/Drive).
• Validate key data fields against master/reference tables.
• Consolidate into historical first-party data repository.
• Run Alteryx QA workflows; resolve flags and inconsistencies.
• Upload approved files via FileZilla/FTP.
• Monitor Azure Data Factory pipelines for SQL load.
• Create/run SQL queries for data validation.
• Review Tableau dashboards for accuracy; report inconsistencies.
• Configure Adverity connections for missing campaign data.
• Perform recurring QA checks across Facebook/Reddit Ads.

Skills

Excel & Google Sheets

Alteryx

SQL

Azure Data Factory

Tableau

Adverity

FileZilla/FTP

Facebook/Reddit Ads data

Data validation

English proficiency

Job description

WPP Media in Mexico City is seeking a Senior BI Analyst to ensure partner and campaign data are accurate, complete, and ready for business intelligence reporting. You will own the data update process from intake to QA and dashboard validation to support reliable decision-making.

Responsibilities include consolidating partner data, validating fields, executing Alteryx workflows, querying SQL, and monitoring Azure Data Factory pipelines that feed Tableau dashboards.