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 withsolutions, 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. Who We Are Overview of the Role 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! WhatYou’llDoat C.A. Fortune 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 Identifyopportunities 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 What You Should Bring to the Table 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 Strongexperience 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 ability to simplify complex concepts Bachelor’s degree in Data Analytics, Data Science, Business Analytics or related is required You Will Stand Out If You Have SQL experience (writing complex queries, working with large datasets) Experience with cloud data warehouses (Snowflake, Databricks, etc.) Python or R for data manipulation Experience with CPG syndicated data sources (NIQ, Circana, SPINS) Experience supporting retail media or ecommerce analytics What We Offer 11 paid company holidays 1 floating holiday 3monthsfully paid parental leave Medical, dental, and vision 401k with company match Summer hours (half-day Fridays) Hybrid work 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. #J-18808-Ljbffr