13 Π΄Π½Π΅ΠΉ Π½Π°Π·Π°Π΄
Analytics Associate (Marketing Analytics)
ΠΡΡΡ & Π‘ΠΎΠΏΡΠΎΠ²ΠΎΠ΄
ΠΠ»Ρ ΠΌΡΡΡΠ° Ρ ΡΡΠΎΠΉ Π²Π°ΠΊΠ°Π½ΡΠΈΠ΅ΠΉ Π½ΡΠΆΠ΅Π½ Plus
ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ Π²Π°ΠΊΠ°Π½ΡΠΈΠΈ
Π’Π΅ΠΊΡΡ:
TL;DR
Analytics Associate (Marketing Analytics) (SQL/dbt/BI): Maintaining reliable analytics data, dashboards, reporting, and marketing measurement workflows for PMGβs Alli platform with an accent on data quality, reporting accuracy, and measurement support. Focus on troubleshooting discrepancies, maintaining dbt tests and transformations, preparing data for media mix modeling and lift studies, and supporting analytics platform enhancements.
Location: Mexico City, Mexico
Company
is a global independent platform company combining business strategy, media, creative, and data through its proprietary Alli operating system.
What you will do
- Maintain accurate analytics data, reporting, measurement workflows, and Alli platform capabilities.
- Create and maintain dashboards, reports, trackers, and recurring analytics deliverables.
- Maintain data transformations and dbt tests while monitoring source freshness and data quality.
- Investigate discrepancies, resolve reporting issues, perform data-quality fixes and backfills, and escalate complex problems.
- Prepare data for marketing measurement initiatives, including media mix modeling, LiftLab, lift studies, and related workflows.
- Support Alli upgrades, testing, documentation, onboarding, training, and ongoing user support.
Requirements
- 1β2 years of experience in analytics, data analytics, marketing analytics, business intelligence, or a related field, plus a bachelorβs degree or equivalent experience.
- Foundational SQL knowledge for querying, validating, transforming, and analyzing data.
- Familiarity with Amazon Redshift, BigQuery, or Snowflake, and with dbt tests or data-quality validation.
- Experience creating or maintaining dashboards and reports with Tableau, Power BI, or Looker.
- Familiarity with digital marketing, media, advertising data, and marketing measurement concepts such as media mix modeling, lift testing, incrementality, attribution, or experimentation.
- Strong attention to detail, troubleshooting, communication, documentation, and collaboration skills.
Nice to have
- Familiarity with Python or R for analysis, automation, or data workflows.
- Exposure to ETL/ELT pipelines, workflow automation, marketing technology, ad tech, or measurement platforms.
Culture & Benefits
- Learning and development programs, mentorship, and career advancement support.
- Paid time off, holiday allowances, paid parental leave, and retirement or pension plans with contribution matching.
- Healthcare, fertility and family support, pet insurance, lifestyle spending accounts, and commuter benefits, depending on geography.
- Annual bonus eligibility and eight paid give-back hours for volunteering.
- AI Enterprise accounts and weekly AI training sessions.
- Inclusive, collaborative culture focused on continual learning, customer success, innovation, and employee well-being.
ΠΡΠ΄ΡΡΠ΅ ΠΎΡΡΠΎΡΠΎΠΆΠ½Ρ: Π΅ΡΠ»ΠΈ ΡΠ°Π±ΠΎΡΠΎΠ΄Π°ΡΠ΅Π»Ρ ΠΏΡΠΎΡΠΈΡ Π²ΠΎΠΉΡΠΈ Π² ΠΈΡ ΡΠΈΡΡΠ΅ΠΌΡ, ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΡ iCloud/Google, ΠΏΡΠΈΡΠ»Π°ΡΡ ΠΊΠΎΠ΄/ΠΏΠ°ΡΠΎΠ»Ρ, Π·Π°ΠΏΡΡΡΠΈΡΡ ΠΊΠΎΠ΄/ΠΠ, Π½Π΅ Π΄Π΅Π»Π°ΠΉΡΠ΅ ΡΡΠΎΠ³ΠΎ - ΡΡΠΎ ΠΌΠΎΡΠ΅Π½Π½ΠΈΠΊΠΈ. ΠΠ±ΡΠ·Π°ΡΠ΅Π»ΡΠ½ΠΎ ΠΆΠΌΠΈΡΠ΅ "ΠΠΎΠΆΠ°Π»ΠΎΠ²Π°ΡΡΡΡ" ΠΈΠ»ΠΈ ΠΏΠΈΡΠΈΡΠ΅ Π² ΠΏΠΎΠ΄Π΄Π΅ΡΠΆΠΊΡ. ΠΠΎΠ΄ΡΠΎΠ±Π½Π΅Π΅ Π² Π³Π°ΠΉΠ΄Π΅ β