Kaylee Hooper · Marketing & Data Analyst | 3+ years SQL, GA4, Tableau & Power BI

About

I'm a marketing and data analyst with an MS in Business Analytics from Tulane and 3+ years of experience across marketing, operations and CRM data. I don't treat strategy and analytics as separate jobs: I write SQL, build dashboards in Tableau, Power BI and Looker Studio, and turn what I find into clear recommendations on where budget goes and which metrics matter. I'm known for finding the root cause when data looks wrong, like spam leads inflating ad conversions or GA4 missing 58% of a client's sales, and for cleaning up systems so teams can trust them again. I'm looking for a full-time marketing or data analyst role, remote or in Chicago or New York City.

Looking for

Experience: 1 year
Time zone: Central Time (US & Canada)

Skills

Advanced

Data Analysis Data Quality Data Reconciliation KPI Definition / KPI Analysis Microsoft Excel Root-cause analysis Stakeholder communication

Intermediate

A/B Testing Dashboards & Recurring Reporting Data Modeling Data cleaning ETL Funnel Analysis Google Analytics (GA4) Looker Studio Microsoft SQL Server Power BI SQL Tableau

Beginner

Statistical Modeling & Forecasting

Experience

Paid Media Manager Serving Good Vibes 08/2026 – 10/2026
• Ran a $2K Meta campaign for a music festival, building 21 ads across 6 ad sets and shifting budget toward single-day tickets; the top ad set hit $35.33 per purchase vs. a $49.95 average.• Ran a creative A/B test and analyzed results by theme, finding lineup and urgency ads drove 75% of purchases.• Reconciled Wix, Meta and GA4 data and found GA4 missed wallet orders that made up 58% of sales, so the client saw the real result: 373 paid tickets and $13.8K revenue.
Data Analyst Matthews Landscape & Pest 03/2025 – 09/2026
• Traced reporting errors to their source, finding Google Ads and web form conversions inflated by spam leads and a flawed revenue-forecasting setup, and rebuilt reporting leadership could trust.• Partnered with Operations, Marketing, Sales and Finance to define the metrics that mattered, introducing lead-quality KPIs and full-funnel reporting from website visits to leads, opportunities and closed jobs.• Fixed data quality at the source by designing a clean data model (accounts → service addresses → contacts) and enforcing naming conventions in the CRM and every form feeding it.• Built ETL pipelines to pull, clean and join data from 7+ systems into a single CRM (Zoho One).
Project Coordinator NEC Corporation of America 11/2024 – 02/2025
• Joined data from legacy, UPS and 3PL systems into a single source of truth, powering recurring real-time dashboards for executive leadership and cutting reporting time.• Answered weekly operational questions with trend and anomaly analyses on hardware failures and repair cycles, driving quality improvements that reduced downtime.
Data Analyst Prize Foundation 06/2023 – 07/2023
• Managed organic and paid social across 12 Meta and LinkedIn accounts for 10 initiatives, tracking performance against registrations, ticket sales, donations and grant funding.• Ran segmented Mailchimp email campaigns to drive registrations and event attendance.• Pulled and cleaned data from state databases, school-board records and surveys for attrition analysis and grant reporting.
Intern Eustis Mortgage Corporation 06/2022 – 08/2022
• Wrote SQL Server queries, views and stored procedures with joins, filters and aggregations for leadership reporting.• Built recurring Excel reports and pivot tables, and refactored legacy SQL for accuracy and readability.
Marketing Analyst New Orleans Saints & Pelicans 08/2021 – 12/2021
• Analyzed fan engagement data using R & Tableau and presented insights to inform the teams' joint social media marketing strategy.

Education

Tulane University Master's · Business Analytics, Specialization: Marketing & Management Class of 2022
University of Louisiana at Lafeyette Bachelor's · General Studies Class of 2020

Languages

English: Fluent