C.A. Fortune ยท 4 days ago
Senior Category Analyst - Paid Media
United States
Full-time
Hybrid
Mid, Senior Level
$75K/yr - $85K/yr
5+ years expC.A. Fortune is a leading consumer brands agency that offers comprehensive solutions to its clients. The role of Senior Category Analyst - Paid Media focuses on managing retail media spend and developing cross-channel reporting in Power BI, requiring a strong technical background in data analytics and reporting.
AdvertisingFood and Beverage
Responsibilities
Ingest, clean, and standardize raw data exports from major retail media platforms (e.g., Amazon, Instacart, Walmart, Kroger, and others)
Design and maintain data models that unify campaign metrics across retail media networks
Build and own weekly, monthly, quarterly, and annual client-facing Power BI dashboards (leveraging existing templates and expanding automation over time)
Develop recurring and ad-hoc AMC models
Perform Excel / Power Pivot deep dives for one-off requests (e.g., impact analyses, category-level reporting)
Deliver quick-turn data pulls and visualizations to support client meetings, new business opportunities, and planning initiatives
Qualification
Required
5+ Years of Analytic Experience (Advertising, Ecommerce, or CPG is a plus)
Advanced Microsoft Power BI development (Power Query, DAX, data modeling, row-level security, custom visuals, etc.)
Database management including normalizing disparate data sources (e.g., schema design, and governance for multi-source datasets)
Expert-level Excel + Power Pivot/Power Query for ad-hoc analysis
Proven experience building and maintaining automated reporting systems that serve multiple stakeholders
Preferred
Strong SQL (writing complex queries from scratch; experience with Amazon Athena or similar big-data query engines is a big plus)
Python or R for data manipulation
Amazon Marketing Cloud, Snowflake, Databricks, or other cloud data warehouses
Previous Advertising or Ecommerce Experience
Benefits
PTO & Sick Days
11 paid company holidays per year
2 paid volunteer days per year
3 months fully paid parental leave (regardless of gender)
Medical, dental, and vision
Paid company life insurance
401k with company match
Summer hours (half day Fridays from Memorial Day thru Labor Day)
Work from home flexibility
Company
C.A. Fortune
C.A.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Tyler Lowell
Managing Partner & CEO
Andrew Bell
Senior Vice President of Sales
Recent News
2025-03-01
Business Journals
2024-03-11
Company data provided by crunchbase