Analytics Associate: Data-Driven Marketing Insights

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

Ventajas ofrecidas por este puesto de trabajo

Professional Development

Generous Time Off

Parental Leave

Retirement & Pension Plans

Fertility and Family Support

Healthcare

Pet Insurance

Lifestyle Spending Accounts

Commuter Benefits

Annual Bonus

Volunteering Opportunities

AI Enterprise License

Descripción de la vacante

PMG in Mexico City is seeking an Analytics Associate to support dashboards, data quality, and measurement workflows across marketing analytics initiatives.

You will collaborate with Analytics, Data Science, Engineering, and client teams to ensure reliable data and actionable insights. 1–2 years of experience, SQL and dbt skills, and experience with Redshift/BigQuery/Snowflake are expected.

Formación

• 1–2 years of experience in analytics or related field.
• Bachelor’s degree or equivalent work experience.
• Experience with SQL for querying, validating, transforming, and analyzing data.
• Familiarity with data warehousing platforms (Redshift, BigQuery, Snowflake).
• Experience creating dashboards using Tableau, Power BI, or Looker.

Responsabilidades

• Support internal teams and customers by maintaining accurate analytics data, reporting, and workflows.
• Create, update, and maintain dashboards, reports, trackers, and recurring analytics deliverables.
• Maintain analytics workflows and dbt tests for reliable reporting.
• Monitor data quality and source freshness; resolve discrepancies and issues.
• Support data-quality fixes, backfills, and reloads as needed.
• Prepare data for marketing measurement initiatives (MMM, lift studies).
• Assist with Alli platform upgrades, testing, and maintenance.
• Troubleshoot analytics and reporting; escalate complex issues as needed.
• Collaborate with Analytics, Media, Client Strategy, Data Science, and Engineering teams to fulfill requests.

Conocimientos

Analytics

SQL

Python/R

Educación

Bachelor's degree or equivalent

Herramientas

SQL

Redshift

BigQuery

Snowflake

dbt

Tableau

Power BI

Looker

Descripción del empleo

PMG in Mexico City is seeking an Analytics Associate to support dashboards, data quality, and measurement workflows across marketing analytics initiatives.

You will collaborate with Analytics, Data Science, Engineering, and client teams to ensure reliable data and actionable insights. 1–2 years of experience, SQL and dbt skills, and experience with Redshift/BigQuery/Snowflake are expected.