Hybrid Data Analyst: Marketing Analytics & Dashboards

Clear Destination Inc.; Ciudad de México; Híbrido; MXN 420.000 - 540.000; Jornada completa

Descripción de la vacante

Clear Destination Inc. in Mexico City is seeking a Data Analyst to lead cross-functional reporting and campaign performance data aggregation across partner and brand initiatives.

You will pull and consolidate metrics from internal exports and partner platforms to build post-mortem summaries and automated dashboards for ROI and SLA tracking. This hybrid role requires translating raw data into executive-ready insights, maintaining Looker and Power BI dashboards, and delivering QBRs.

Formación

• 4–6 years of experience in data/marketing/BI analytics for multi-channel campaigns, agency networks, or tech accounts.
• Bachelor’s degree in a quantitative field such as Data Analytics, Statistics, Finance, Marketing Analytics, or Business Administration.

Responsabilidades

• Aggregate and synthesize performance metrics across partner channels, localized brand campaigns, and external retail footprints.
• Extract, clean, and consolidate marketing data from internal exports and self-serve partner-facing platform metrics.
• Maintain a centralized performance data repository to ensure cross-functional visibility into marketing performance and ROI.
• Build post-mortem summaries and automated dashboards that track KPIs against SLAs.
• Translate complex metrics into executive-ready business reviews (QBRs) and summaries.
• Identify historical trends and data anomalies, providing actionable data-driven recommendations for future campaigns.
• Maintain, update, and optimize Looker and Power BI dashboards, ensuring performant semantic layers and correct LookML/DAX.
• Execute ad-hoc SQL (CTEs, window functions, dynamic pivoting) in BigQuery and Snowflake; wrangle data with Python or R; use RegEx for extractions.

Conocimientos

SQL

Python

R

JavaScript

Google Apps Script

BigQuery

Snowflake

Looker

Power BI

Google Sheets

Excel

RegEx

Data lineage

Data hygiene

Bilingual Spanish/English

Educación

Bachelor’s degree in Data Analytics, Statistics, Finance, Marketing Analytics, Business Administration, or related quantitative field

Herramientas

Looker

Power BI

BigQuery

Snowflake

Google Apps Script

JavaScript

Python

R

RegEx

Google Sheets

Excel

Descripción del empleo

Clear Destination Inc. in Mexico City is seeking a Data Analyst to lead cross-functional reporting and campaign performance data aggregation across partner and brand initiatives.

You will pull and consolidate metrics from internal exports and partner platforms to build post-mortem summaries and automated dashboards for ROI and SLA tracking. This hybrid role requires translating raw data into executive-ready insights, maintaining Looker and Power BI dashboards, and delivering QBRs.