Senior Analyst, Business Intelligence Tools

C.A. Fortune is a leading consumer brands agency dedicated to comprehensive solutions for clients. The Senior Analyst, Business Intelligence Tools will develop and standardize dashboarding and reporting solutions, leveraging data engineering and analytics to drive insights across various teams.

Responsibilities:

• Design, build, and maintain scalable 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
• 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 and eliminate inefficiencies
• 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
• Support rapid-turn analysis requests for client meetings, business reviews, and leadership asks
• Develop custom views and deep dives to answer specific business questions

Requirements:

• 4 – 7+ years of experience in BI, analytics, or data visualization roles (CPG, retail, or ecommerce preferred)
• Advanced Power BI expertise (DAX, Power Query, data modeling, performance optimization)
• Strong experience with cloud-based data platform, Snowflake
• Strong experience in integrating 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
• 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