Melanie Rose

Data Analyst • Project Manager • Growth Marketing Manager • New York, NY, US

Web Analytics

Google Ads

Digital Marketing

Compliance

Tableau

Microsoft Excel

Facebook Ads

Figma

SEO

HTML/CSS

MySQL

UI/UX Design

Search Engine Marketing

G-Suite

Data Entry

Google Analyics

Basic Finance

Available for hire fromNegotiable

Contracts

Data-Driven Analyst with Expertise in Performance Reporting and Process Improvement

Hi, my name is Mel, and I’m a results-driven professional with a background in Business Administration and expertise in data reporting within digital marketing. I’ve developed skills in creating performance reports, auditing advertising expenses, and using tools like Google Analytics, Google Ads, and Meta Ads to drive results. Outside of work, I’m passionate about continuous learning and exploring new interests.

Projects

UX Design Food Menu App

I created a food menu app for a food truck. The target users for this app are busy individuals who are looking to quickly order food between their daily activities. I conducted user research, built a persona and user journey map, created wireframes, mockups and prototypes, conducted usability studies, and iterated on my designs. Figma was used to build the designs. See More

Cyclistic Bike-Share Case Study

I utilized powerful R packages like tidyverse, lubridate, and ggplot2 to effectively process, clean, and visually represent extensive historical bike trip data. Through in-depth analysis, I delivered three actionable recommendations to the marketing team, enabling them to convert casual riders into annual riders and drive significant profit growth. See More

Covid-19 Data Exploration

I utilized my expertise in MySQL to efficiently import and analyze data, uncovering vital insights into infection rates by country, total deaths per continent, and global cases and deaths. By leveraging Tableau, I transformed these findings into visually compelling presentations, empowering the public to gain a comprehensive understanding of the far-reaching impacts of the pandemic. Here is the code: https://github.com/melnc/PortfolioProjects/blob/main/covidportfolioproject.sql See More

Work History

Digital Support Specialist

PCG DigitalGathered and analyzed performance data, built dashboards, and created reports using Google and Meta Ads to optimize paid social, SEO, and SEM campaigns for 60+ clients, contributing to improved ROI across channels Compiled and organized documentation for automotive advertising reimbursements, including invoices, keyword reports, campaign screenshots, and promotional requirements, ensuring timely and accurate submissions Audited advertising charges and documentation for accuracy and brand compliance, reducing reimbursement errors and aligning campaigns with manufacturer guidelines and sales event criteria

Junior SEO Analyst

Static MediaAug 2023 - Nov 2023 • 4 mosAnalyzed search data and generated comprehensive keyword reports using tools like Google Trends, SEMrush, and Ahrefs, resulting in increased organic search traffic within 3 months Leveraged Google Trends to guide writers toward topics that resonated with target audiences, boosting search rankings and increasing click-through rates (CTRs) Utilized data metrics such as traffic, average time on page, and demographic analysis to identify evergreen content opportunities, which increased engagement and satisfaction

Education

University of Massachusetts Amherst

Bachelors Degree, Business Administration

Similar Pangeans

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!