Apply on Employer Site

C.A. Fortune · 4 days ago

Senior Category Analyst - Paid Media

Chicago, IL

Full-time

Hybrid

Mid, Senior Level

$75K/yr - $85K/yr

5+ years exp

C.A. Fortune is a leading consumer brands agency focused on providing comprehensive solutions to clients in sales management, marketing, and e-commerce. The Senior Category Analyst - Paid Media will manage retail media spend, build and maintain reporting systems in Power BI, and perform data analysis to support client initiatives.

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

Microsoft Power BIData modelingSQLExcelPythonAmazon Marketing CloudDatabase managementAd-hoc analysisEcommerce experienceAdvertising experience

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.

Founded in 1983

Elk Grove Village, Illinois, USA

501-1000 employees

http://cafortune.com

Funding

Current Stage

Late Stage

Leadership Team

Tyler Lowell

Managing Partner & CEO

Andrew Bell

Senior Vice President of Sales

Recent News

citybiz

C.A. Fortune Elevates Mariah Calderon to Chief Client Officer

2025-03-01

PRNewswire

C.A. Fortune Announces Monumental Transaction with SRW Agency, Creating a National Powerhouse in Consumer Brand Sales and Marketing

2024-03-11

Business Journals

C.A. Fortune acquires SRW in deal between local agencies

2024-03-11

Company data provided by crunchbase