Senior Category Analyst – Paid Media
C.A. Fortune
full-time
Posted on:
Location Type: Hybrid
Location: Illinois • United States
Visit company websiteExplore more
Salary
💰 $75,000 - $85,000 per year
Job Level
About the role
- 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.
Requirements
- 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.
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data ingestiondata cleaningdata standardizationdata modelingPower BIPower QueryDAXExcelPower Pivotautomated reporting