Senior Category Analyst - Paid Media
Listed on 2026-01-09
-
IT/Tech
Data Analyst, Data Engineer, Ecommerce
Senior Category Analyst – Paid Media
Join C.A. Fortune’s Paid Media team to manage retail media spend across Amazon, Amazon DSP, Instacart, Walmart Connect, The Trade Desk, Kroger, and emerging networks.
Overview of the roleThis highly technical, execution‑focused position owns the build‑out and ongoing maintenance of enterprise‑grade, cross‑channel reporting in Power BI, supporting our largest and most complex client relationships. The role is fully remote (hybrid 3 days in office for Chicago, IL employees). Salary range $75,000–$85,000. 5–10% travel for client presentations and team meetings.
Key responsibilities- Ingest, clean, and standardize raw data exports from major retail media platforms.
- Design and maintain unified data models across networks.
- Build and own weekly, monthly, quarterly, and annual client‑facing Power BI dashboards, expanding automation over time.
- Develop recurring and ad‑hoc AMC (Amazon Marketing Cloud) models.
- Perform Excel / Power Pivot deep dives for one‑off requests and deliver quick‑turn data pulls and visualizations.
- Maintain automated reporting systems for multiple stakeholders.
- 5+ years of analytic experience (Advertising, Ecommerce, or CPG).
- Advanced Power BI development (Power Query, DAX, data modeling, row‑level security, custom visuals).
- Database management, normalization of multi‑source data.
- Expert‑level Excel + Power Pivot / Power Query.
- Experience building and maintaining automated reporting systems.
- Strong SQL; experience with Amazon Athena or similar large‑data query engines.
- Python or R for data manipulation.
- Experience with Amazon Marketing Cloud, Snowflake, Databricks, or other cloud data warehouses.
- Previous Advertising or Ecommerce experience.
- 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 coverage.
- Paid company life insurance.
- 401(k) with company match.
- Summer hours (half‑day Fridays from Memorial Day through Labor Day).
- Work‑from‑home flexibility.
C.A. is committed to diversity and inclusion. We encourage applicants who meet the majority of qualifications, especially those whose career trajectory aligns with this role.
Employment InformationSeniority level: Mid‑Senior level |
Employment type: Full‑time |
Job function: Marketing and Sales |
Industries: Business Consulting and Services
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).