Open to opportunities

Natalia Castillo

@nataliacastillo

Message

Programmatic Analyst and data automation specialist turning large-scale ad data into real-time, error-free insights.

Colombia

Message

What I'm looking for

I’m looking to drive programmatic performance with automation and BI—designing ETL pipelines, building dashboards, and coaching teams to deliver faster, accurate insights for clients.

I’m a results-driven Programmatic Analyst and data professional with 4+ years managing large-scale digital advertising campaigns across DV360, The Trade Desk, Google Ads, and Amazon DSP. I build automation tools (VBA, Power Query, Python, SQL, and Power BI) that reduce manual effort by up to 98% and eliminate human error at scale through robust ETL and cross-platform data reconciliation.

In my roles at Publicis Global Delivery and WPP Media, I’ve designed VBA-based ETL for DV360/TTD, implemented Power BI reporting for same-day error correction, and supported KPI-focused client operations across multiple ad platforms. I also lead enablement—coaching analysts and rolling out an AI literacy course—so teams can ship reliable reporting pipelines faster and with confidence.

Experience

Work history, roles, and key accomplishments

Current

Programmatic Analyst L2

Current

Publicis Global Delivery

Mar 2025 - Present (1 year 3 months)

Designed and deployed VBA/Excel and Python automation for DV360 geo-targeting setup, cutting manual workload by 98% across 372+ campaigns ($25M+ managed budget). Built an ETL for ad rotation management across DV360 and The Trade Desk, automating 1,362 campaigns with 100% QA accuracy and reduced manual effort by 95%.

DV360 The Trade Desk VBA (Excel Macros)Python ETL Power BI Power Query QA & Reconciliation

Programmatic Executive

WPP Media

Aug 2024 - Mar 2025 (7 months)

Managed end-to-end programmatic operations for two clients across Google Ads, DV360, The Trade Desk, Prisma (MediaOcean), and Amazon DSP, consistently meeting KPI targets including CPVC, ROAS, and CPM. Built automated pacing and creative performance reporting by integrating CM360, Google Ads, and DV360 data to improve client-facing insight delivery.

Google Ads DV360 The Trade Desk CM360 Prisma Tableau KPIs

Quality Data Analyst

TaskUs

Nov 2022 - Apr 2024 (1 year 5 months)

Automated weekly business reporting in Power BI using Power Query and Genesys data, reducing build time from 4 hours to under 5 minutes and removing two rounds of management review. Designed Looker Studio KPI scorecards for 82 agents and built Google Apps Script ETL automation that improved individual agent performance by 30%.

Power BI Power Query Looker Studio Google Apps Script ETL KPIs Genesys SLA Management Data Visualization

Junior Analyst

TaskUs

Aug 2021 - Oct 2022 (1 year 2 months)

Promoted to Quality Data Analyst by designing a cross-team real-time reporting system in Google Workspace using Google Apps Script. Reduced SLA times and enabled immediate error response through improved operational visibility and automation.

Google Apps Script Google Workspace SLA Management Operational Reporting Data Automation Google Sheets

Bilingual Virtual Assistant

Teleperformance

Feb 2021 - Jun 2021 (4 months)

Produced daily, weekly, and monthly operational reports covering finance and project tracking. Built a Google Sheets task manager with Google Apps Script and automated bulk email templates to streamline recurring operational workflows.

Google Sheets Google Apps Script Report Automation Operational Reporting Project Tracking Virtual Assistance