Senior Category Analyst - Paid Media

What We Do 

At C.A. Fortune, we aspire to maintain our position as the nation’s leading consumer brands agency. We realize how fortunate we are (pun intended) to offer comprehensive solutions to our clients. From sales management to marketing, all the way down to insights and e-commerce, our boutique service model offers a breadth of services to our clients. 

Who We Are 

People. Passion. Purpose. Our people are the core of our business. Our unique boutique service model allows our people to follow their passions with a purpose, all while delivering excellent services to our clients. At C.A., we live and breathe our values. We are fearless and curious innovators who lead with solutions, empower others, and do the right thing, always. We are a family-first organization and recognize the importance of a healthy and flexible work-life balance, a positive support system, and the power of diversity and inclusion. 

Overview of the Role 

• The C.A. Fortune Paid Media team manages retail media spend across Amazon, Amazon DSP, Instacart, Walmart Connect, The Trade Desk, Kroger, and other emerging networks. This role will own the build-out and ongoing maintenance of enterprise-grade, cross-channel reporting in Power BI. This is a highly technical, execution-focused role that will power our largest and most complex client relationships. 
• Fully remote but if local to Chicago, IL will observe a hybrid schedule of 3 days in office
• Salary range $75,000 - $85,000 based on experience, qualifications and skills. 
• 5-10% travel requirements to aid in client presentations and team meetings 
• At C.A. we’re not looking for perfection, just people that want to commit to a us and grow their careers long-term. We are on a mission to build better brands that inspire healthier lifestyles for consumers and their families. If you’re looking for a sign to apply, here it is!  

What You’ll Do at C.A. Fortune 

Cross-Channel Reporting Architecture & Automation 

• 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). 

Advanced Amazon Marketing Cloud (AMC) Integration 

• Develop recurring and ad-hoc AMC models 

Ad-Hoc & Rapid-Turn Analysis 

• 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. 

What You Should Bring to the Table 

• 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 

You Will Stand Out if You Have 

• 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 

Perks  

• 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  

Come As You Are  

C.A. is committed to making our company more inclusive. Diversity fuels our innovation and better connects us to our clients, our colleagues, and our communities. Based on research, we know that women and other marginalized groups tend to apply to roles only when their experience perfectly matches the job description. That said, we encourage you to apply if you meet the majority of qualifications, especially if this role aligns with your career trajectory.