Senior BI & Data Quality Analyst — Remote/Hybrid

WPP Media; Bogotá ciudad; Híbrido; COP 186.840.000 - 280.260.000; Jornada completa

Descripción de la vacante

WPP Media is hiring a Senior BI Analyst to ensure partner and campaign data is accurate, complete, and ready for business intelligence reporting. You will manage the partner data update process from receipt and validation through QA, pipeline execution, and final dashboard verification.

Your work will directly support reliable data for campaign reporting and decision-making. Responsibilities include consolidating partner data files, validating fields, executing Alteryx QA workflows, loading data

Formación

• Professional experience in Business Intelligence, data operations, marketing analytics, data quality assurance, or reporting.
• Strong proficiency in Excel and Google Sheets, including consolidating large datasets.
• Hands-on experience with Alteryx workflows.
• Experience using SQL to query, validate, and reconcile data.
• Experience executing or monitoring data pipelines in Azure Data Factory.
• Experience reviewing dashboards in Tableau and data integration tools like Adverity.

Responsabilidades

• Receive, review, and consolidate Partner Data files via Excel, Sheets, email, or Drive.
• Validate data fields against master and reference tables.
• Consolidate information into historical data repository while preserving history.
• Run QA workflows, investigate flags, and resolve inconsistencies.
• Prepare final files and upload to server via FTP tools.
• Monitor Azure Data Factory pipelines loading data into SQL tables.
• Create SQL queries to validate information and fetch reference data.
• Review Tableau dashboards for accuracy and report discrepancies.
• Set up data connections with Adverity as needed.
• Perform recurring data quality checks across Facebook Ads and Reddit Ads.
• Coordinate with partners and stakeholders to resolve reporting issues.
• Adapt QA frequency per client needs (weekly, quarterly, etc.).
• Maintain Alteryx workflows and update calculations as needed.

Conocimientos

BI analytics

Data operations

Marketing analytics

Data quality assurance

Reporting

Herramientas

Alteryx

SQL

Tableau

Azure Data Factory

FileZilla

Adverity

Descripción del empleo

WPP Media is hiring a Senior BI Analyst to ensure partner and campaign data is accurate, complete, and ready for business intelligence reporting. You will manage the partner data update process from receipt and validation through QA, pipeline execution, and final dashboard verification.

Your work will directly support reliable data for campaign reporting and decision-making. Responsibilities include consolidating partner data files, validating fields, executing Alteryx QA workflows, loading data