Francheska Guerrero

Summary

Data-focused digital strategist with 3+ years of experience bridging analytics and marketing to deliver data-driven business outcomes. Skilled in designing measurement frameworks, activating data-driven campaigns, and translating complex insights into actionable strategies. Experienced in audience segmentation, predictive modeling, and KPI-driven optimization, with proven results in client retention, revenue growth, and campaign performance. Recent certifications in Data Analytics and Python, including capstone projects in SQL, Tableau, and predictive analytics, demonstrate a strong foundation for enterprise-level data strategy.

Professional Experience

Social Media Marketing Manager – Mochee Digital, Miami, FL

May 2022 – Present

Designed and implemented data-driven measurement frameworks, aligning KPIs to client objectives and ensuring accurate reporting across platforms (SQL, Tableau, Excel).
Partnered with cross-functional stakeholders to translate complex analytics into actionable business strategies, guiding campaign adjustments and ROI improvements.
Led audience segmentation and funnel analysis to optimize campaigns, driving a 25% increase in client retention and 15% increase in upsells.
Executed data-driven marketing activations, including AI-powered paid media optimization and A/B testing, achieving a 3.94 ROAS for a national film festival campaign.
Developed integrated multi-channel messaging frameworks, leveraging insights to increase campaign reach by 1,567% and impressions by 2,238%.
Synthesized performance data to provide strategic recommendations, enabling proactive decision-making during high-pressure client crises.
Collaborated on trend analysis and predictive modeling projects, identifying actionable patterns to inform future marketing and business strategy.

Education

Brainstation – Data Analyst Certification (DAC™)

January – March 2025

Capstone: Analyzed 20+ years of Canada’s trade data using Excel, SQL, and Tableau, evaluating tariff impacts on GDP and trade balance to model policy outcomes.

Brainstation – Python Certification (PPC™)

March – April 2025

Capstone: Built Python workflows in Jupyter to clean/analyze e-commerce data. Identified purchase trends, product popularity, and review sentiment to guide future ML recommendations.

University of Florida, Gainesville, FL

August 2018 – May 2022

BS, Media Production, Management, and Technology, Magna Cum Laude, GPA: 3.6

Skills

Data Strategy & Analytics: Measurement frameworks, KPI alignment, audience segmentation, predictive modeling, trend analysis, A/B testing, campaign optimization.
Technical Tools & Languages: SQL, Python, Tableau, Excel (pivot tables), Jupyter, Google Analytics, Brandwatch, Meta Ads Manager, Google Ads.

Consulting & Communication: Stakeholder reporting, data storytelling, cross-functional collaboration, campaign recommendations.
Languages: English (native), Spanish (fluent), Italian (conversational)