Data Analytics Associate - Dashboards & Marketing Metrics

PMG; Ciudad de México; Presencial; MXN 300.000 - 420.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare

Annual bonus

Parental leave

Pension plans

Fertility & family support

Commuter benefits

Descripción de la vacante

PMG is seeking an Analytics Associate in Mexico City to support analytics data, reporting, and measurement workflows using the Alli platform. You will build dashboards and maintain data quality, collaborating with analytics, media, and client teams to drive reliable insights.

The role focuses on data transformations, dashboards, and ongoing reporting for marketing measurement initiatives such as MMM and lift studies, with opportunities to grow skills in Python or R and ETL/ELT pipelines.

Formación

• 1–2 years in analytics, data analytics, marketing analytics, BI, or related field.
• Bachelor’s degree or equivalent.
• Experience with SQL for querying, validating, transforming, and analyzing data.
• Familiarity with data warehousing platforms like Redshift, BigQuery, or Snowflake.
• Experience with dashboards/reports in Tableau, Power BI, or Looker.

Responsabilidades

• Maintain accurate, reliable analytics data, reporting, and Alli platform capabilities.
• Create, update, and maintain dashboards, reports, trackers, and recurring analytics deliverables.
• Ensure data quality and monitor source freshness, resolve discrepancies and reporting issues.
• Support data-quality fixes, backfills, reloads, and maintenance activities.
• Prepare data for marketing measurement initiatives including MMM and lift studies.
• Collaborate with Analytics, Media, Client Strategy, Data Science, and Engineering teams.

Conocimientos

SQL queries

BigQuery

dbt

Tableau

Power BI

Looker

Python/R

ETL/ELT

Marketing analytics

Data quality

Educación

Bachelor's degree or equivalent

Herramientas

Redshift

Snowflake

BigQuery

dbt

Tableau

Power BI

Looker

Descripción del empleo

PMG is seeking an Analytics Associate in Mexico City to support analytics data, reporting, and measurement workflows using the Alli platform. You will build dashboards and maintain data quality, collaborating with analytics, media, and client teams to drive reliable insights.

The role focuses on data transformations, dashboards, and ongoing reporting for marketing measurement initiatives such as MMM and lift studies, with opportunities to grow skills in Python or R and ETL/ELT pipelines.