• Automated intelligence dashboards using Tableau and Power BI, allowing real-time visualization of complex marketing data for faster decision-making.• Utilized SQL and Python for ad-hoc analyses and to pull data from Redshift, creating visualizations in Tableau to deliver insights for campaign optimization as well as allow for real-time visualization of complex marketing data for faster decision-making.

• Built ETL pipelines to extract, transform, and load data from Google Ads and backend metrics, leveraging AWS services such as S3, Redshift, and EC2 for efficient data storage and processing.• Worked extensively with NoSQL databases to integrate non-relational data such as X’s tweets, trending Google keywords, Trustpilot reviews with marketing analytics, enhancing the accuracy of user behavior tracking and targeting.

• Monitored ETL pipelines using Python and SQL to manage and extract marketing data, providing actionable insights that contributed to a 40% increase in ROAS.• Defined and analyzed engagement metrics, scaled CBDRevision.com, becoming the second-highest-rated CBD blog in Mexico.

• Wrote Python scripts to scrape GitHub and LinkedIn to source the top 5% of tech candidates in North America. At peak performance, we generated 30 million new rows of data daily.• Extracted, manipulated, and cleaned data to pair LinkedIn with Github profiles and input this information into our chrome extension by collaborating with the data scientist team in creating a complex rating system.