Senior Analyst, Business Intelligence Tools

At C.A.,we aspire tomaintainour 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.

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. We are committed toliving outour values. We are fearless and curious innovators wholead 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.

• The Senior Analyst, BI Tools will lead the development, standardization, and scaling of dashboarding and reporting solutions across the organization. This role sits at the intersection of data engineering, analytics, and business storytelling—owning the infrastructure and outputs that power insights across sales, category, and paid media teams.
• This is a highly technical, high-impact role responsible for building enterprise-grade Power BI solutions, creating scalable data models, and enabling self-service analytics across stakeholders. The ideal candidate will act as both a builder and a thought partner, helping define how data is structured, accessed, and visualized across the business.
• Fully Remote but if local to Chicago, IL (within 1 hour) will observe a hybrid schedule 3 days in office
• Travel Required:
  
  5–10% - i.e. client meets, Insights Team meetings, and/ or any other events.
• Salary Range: $70,000 – $75,000 based on experience, qualifications and skills.
• 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!

• Design, build, andmaintainscalable Power BI dashboards used across internal teams and client engagements
• Establish standardized templates and best practices to ensure consistency across all reporting outputs
• Translate complex datasets into intuitive, actionable visualizations for business users
• Develop and manage robust data models that integrate multiple data sources (POS, syndicated, retail media, internal systems)
• Clean, transform, and standardize raw datasets using Power Query and other ETL processes
• Ensure data accuracy, governance, and consistency across dashboards and reporting environments
• Automation & Scalability
  • Build automated reporting pipelines that reduce manual work and improve speed to insight
  • Create repeatable frameworks for weekly, monthly, and quarterly reporting
  • Identify opportunities to streamline workflows andeliminateinefficiencies
• Cross-Functional Enablement
  • Partner with Insights, Sales, and Media teams to understand reporting needs and translate them into scalable BI solutions
  • Act as the internal expert on BI tools and visualization best practices
  • Train and enable team members on dashboard usage and self-service capabilities
• Ad-Hoc Analysis & Support
• Support rapid-turn analysis requests for client meetings, business reviews, and leadershipasks
• Develop custom views and deep dives to answer specific business questions

• 4 – 7+ years of experience in BI, analytics, or data visualization roles (CPG, retail, or ecommerce preferred)
• Advanced Power BIexpertise(DAX, Power Query, data modeling, performance optimization)
• Strong experience with cloud-based data platform, Snowflake
• Strong experience inintegrating and managing multiple data sources
• Advanced Excel skills (Power Pivot, complex formulas, large dataset manipulation)
• Experience building automated reporting systems used by multiple stakeholders
• Strong analytical mindset with the ability to translate data into business insights
• Excellent communication skills with…