Junior Data Analyst

Junior Data Analyst

Who we are?

Publicis Groupe Mexico is a prominent advertising and integrated communications agency that offers creative and strategic solutions in digital marketing, media, ecommerce, OFF marketing, and Data. Part of the global conglomerate Publicis Groupe, it specializes in technology and large-scale data management to innovate and help brands transform and grow their businesses through marketing, data, and technology.

About the position

We are looking for a Junior Data Analyst to join our team. You will be responsible for analyzing and transforming data into solutions that facilitate decision-making, using SQL, visualization tools, and automation. You will participate in database analysis, dashboard development to meet client needs. The vacancy is aimed at analytical and technological profiles, with a high capacity for organization and effective communication to solve problems.

What will you do?

• Database analysis using SQL, creation of views and new columns (ILIKE, SPLIT, CASE, REGEX functions, etc.)
• Dashboarding to meet our clients' diverse needs
• Service and support to internal account teams for project development
• Collaboration with Data Engineering and Development teams
• Automation of data processing and own operational tasks
• Analysis and generation of findings for understanding consumer behavior through various tools.

What we are looking for

• Degree in Marketing, Systems Engineering, Actuarial Science, Informatics, and/or Computer Systems and/or demonstrable experience in Cloud Technology and Data Analysis.
• Proficiency in SQL (Structured Query Language)
• Regular use of artificial intelligence tools
• Data visualization and BI tools (PowerBI, Tableau, Looker, or similar)
• Experience with Python for automation and data processing tasks (pandas, csv module, or similar)
• Knowledge of ETL tools (Pandas, Alteryx, Databricks Visual, or similar)
• Experience working in the Cloud (AWS, GCP, or Azure)
• Experience working with agile, scrum, or similar methodologies.

It will be a plus if you have familiarity and understanding of media and the marketing industry.

Location: Mexico City

Modality: Hybrid