Looking for a job

Júlia Rea

@jliarea

Data Analyst at AlmapBBDO integrating paid media data into dashboards for campaign and budget decisions.

At AlmapBBDO, I analyze paid media data across Search, Social, and Programmatic, using SQL and BigQuery to monitor performance, optimize campaigns, and investigate root causes. I integrate platforms including Google Ads, Meta Ads, DV360, Amazon Ads, and Mercado Livre Ads into a consolidated performance view, and develop Looker Studio dashboards for KPI tracking.

At Víssimo Group (Evino), I implemented automated data pipelines that increased operational efficiency by 25% and built data structures with AWS Redshift and S3. I also analyzed CRM, subscription club, and franchise data to track repurchase and retention, and used A/B testing in affiliate and email campaigns that increased conversion rates by 15%.

Experience

Work history, roles, and key accomplishments

Current

Mid-Level Data Analyst

Current

AlmapBBDO

Nov 2024 - Present (1 year 11 months)

Managed and analyzed paid media data for strategic accounts, performing data extraction, processing, and modeling via SQL and BigQuery. Developed executive reports and Looker Studio dashboards to track KPIs and performance goals.

SQL BigQuery GCP Looker Google Ads Meta Ads DV360 Amazon Ads Mercado Livre Ads Data Modeling ETL Executive Reporting

Junior Data Analyst

Víssimo Group

Feb 2023 - Oct 2024 (1 year 8 months)

Implemented automated data collection and processing pipelines, increasing operational efficiency by 25%. Built data engineering structures using AWS Redshift and S3, and analyzed CRM, subscription club, and franchise network data for customer analytics.

AWS RedShift S3 ETL Data Engineering Looker CRM Customer Analytics SQL Python

Growth Marketing Intern

Víssimo Group

May 2022 - Feb 2023 (9 months)

Managed affiliate and email marketing campaigns, achieving a 15% increase in conversion rates through A/B testing. Conducted campaign performance analysis via Looker, leading to a 20% growth in efficiency.

Affiliate Marketing Email Marketing A B Testing Looker SQL Python CAC LTV Retention

Media Planning Intern

The Media Trade

Oct 2021 - Apr 2022 (6 months)

Provided commercial support for offline and online media planning and buying, including radio, OOH, print, and digital. Consulted clients and partners on media formats, reach, costs, and strategies.

Media Planning Media Buying Offline Media Online Media Client Consulting