Analytics Senior Executive, GOC

wppmedia; Deutschland; Hybrid; EUR 15.000 - 28.000; Vollzeit

Benefits dieser Stelle

Remote or hybrid work

Comprehensive benefits package

Significant paid time off

Mental health days

Zusammenfassung

wppmedia is seeking a Business Intelligence professional to support Analytics and Media teams by maintaining reliable dashboards, recurring reports, and data quality processes that improve marketing efficiency. The role sits within the BI function of a global media operating unit, collaborating with onshore and offshore teams across markets.

You will production and enhance dashboards using Power BI, Tableau, and Looker, extract data from multiple platforms, and ensure data governance and timely

Qualifikationen

• 2+ years of analytics or BI with large datasets.
• Hands-on Power BI; Tableau/Looker desirable.
• Experience with digital media data and analytics tools (GA, CM360, etc.).
• Advanced Excel skills (pivot tables, lookups, charts).
• Strong quantitative, analytical, and problem-solving abilities.
• Excellent written and verbal communication across teams.
• Must overlap with NY time zone (EST/CST) for 3+ hours, up to 6 hours.
• Authorized to work in Mexico or Colombia, role performed from within those countries.

Aufgaben

• Maintain dashboards, recurring reports, and data quality processes to improve marketing efficiency.
• Produce weekly, monthly, quarterly reports using Power BI, Tableau, and Looker.
• Extract data from multiple media platforms and perform data cleaning and quality control.
• Conduct daily and weekly data quality assurance; resolve discrepancies across outputs.
• Ensure compliance with data governance and taxonomy requirements.
• Onboard and integrate new data sources; map, troubleshoot, and perform root-cause analysis.
• Coordinate with BI/Data Ops teams to implement fixes for data integration issues.
• Support intake and QA of partner-provided performance data.
• Document data processes and business logic for knowledge sharing.
• Support project timelines and communicate progress, risks, dependencies, and delivery issues.

Kenntnisse

Power BI

Tableau

Looker

Excel

Data analysis

Communication

Problem solving

SQL

Jobbeschreibung

Role overview

This Business Intelligence role supports Analytics and Media teams by maintaining reliable dashboards, recurring reports, and data quality processes that improve marketing efficiency. The position sits within the BI function of a global media operating unit, partnering closely with onshore and offshore teams across multiple markets.

Responsibilities

• Support the implementation, maintenance, enhancement, and issue resolution of paid media performance dashboards, ensuring accuracy and responsiveness to feedback.
• Produce recurring weekly, monthly, quarterly, and campaign wrap-up reports using Power BI, Tableau, and Looker.
• Extract data from multiple media platforms and perform data cleaning, hygiene, and quality control.
• Conduct daily and weekly data quality assurance, investigating and resolving discrepancies across reporting deliverables.
• Ensure compliance with established data governance and taxonomy requirements.
• Support onboarding and integration of new data sources, including parsing, benchmarking, mapping, troubleshooting, and root-cause analysis.
• Coordinate with BI and Data Operations teams to implement fixes and resolve data integration issues.
• Support intake and quality assurance of partner-provided performance data.
• Maintain accurate documentation of data processes, business logic, and workflows to promote consistency and knowledge sharing.
• Support project timelines and reporting schedules, communicating progress, risks, dependencies, and delivery issues.

Requirements

• 2+ years of professional experience in Analytics or Business Intelligence working with large, complex datasets.
• Hands-on experience with Power BI; knowledge of Tableau or Looker is highly desirable.
• Experience working with digital media data, including Google Campaign Manager/CM360, major digital and social platforms, and web analytics tools such as Google Analytics or Adobe Analytics.
• Advanced proficiency in Excel, including pivot tables, lookups, charts, and complex data manipulation.
• Strong quantitative, analytical, and problem-solving skills.
• Understanding of common media metrics and buying models such as CPV, VCR, and GRP, and how they connect to business outcomes.
• Ability to independently manage day-to-day workstreams within large analytical projects with limited guidance.
• Excellent written and verbal communication skills, especially when collaborating across offshore and onshore teams.
• Availability for a minimum three-hour morning overlap with New York (EST or CST); up to six hours of overlap preferred.
• Legal authorization to work in Mexico or Colombia, with the role performed from within one of those countries.

Nice to have

• Experience with SQL, Python, or R, or with tag management or application coding.
• Statistics or data modeling experience.
• Previous experience working directly with US-based teams.

Benefits and work setup

• Remote or hybrid work modality, performed from any location within Mexico or Colombia.
• Competitive medical, group retirement, vision, and dental insurance, significant paid time off, preferential partner discounts, and mental health awareness days.
• Hybrid approach with teams in-office around four days a week where applicable.
• Equal opportunity employer with an inclusive culture and multiple employee resource groups.