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 and facilitating informed decision-making for effective mitigation strategies. Here is the code: https://github.com/melnc/PortfolioProjects/blob/main/covidportfolioproject.sql See More

Work History

Digital Support Specialist

PCG DigitalContract EmployeeGathered data and built reports using Google Ads and Meta Ads Manager to analyze paid social, SEO, and SEM performance for 60+ clients, resulting in increased ROI for campaigns Provided critical insights by tracking car manufacturer advertising compliance changes, brand identity changes, and sales events, resulting in increased campaign effectiveness and proper reimbursement of claims during key events Reconciled client advertising campaigns and prepared invoices, ensuring precision and compliance, which reduced errors and discrepancies with clients

Junior SEO Analyst

Static MediaFreelancerAug 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 three months Leveraged Google Trends data to guide writers in selecting topics that resonated with specific site audiences, which enhanced search engine rankings and increased 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!