Senior Analyst, Business Intelligence

Smucker Retail Foods, Inc. is seeking a Senior Analyst, Business Intelligence to support its Commercial organization with analytics and reporting across its brand portfolio. The role develops and maintains Tableau dashboards, data models, and reporting solutions, analyzes commercial trends, and partners with business and data teams to enable decision-making.

Responsibilities:

• Design, develop, and maintain curated data models and reporting objects in the Databricks Platinum layer to support enterprise BI and analytics use cases
• Develop, support and enhance Tableau dashboards by ensuring underlying data structures are optimized for performance and usability
• Build scalable, reusable data assets that enable Tableau dashboards and self-service reporting
• Create, maintain, improve, and analyze CAS/Trade Funds and consumption reporting dashboards with internal and external syndicated data sources
• Partner with Commercial stakeholders to translate business questions and requirements into scalable reporting, analytics, and data visualization solutions
• Collaborate with Information Services, data engineering, business analysts, and data partners to translate reporting requirements into well-structured data models, curated reporting objects, and semantic definitions
• Analyze, design, code, test, and implement systematic solutions to meet customer requirements through reporting and data visualization
• Serve as a subject matter expert for BI development best practices, data modeling, and reporting enablement
• Contribute to the establishment and enforcement of data governance, naming standards, and development lifecycle practices
• Strong cross-functional collaboration through information sharing to improve efficiency and effectiveness across the broader analytics team
• Serve as liaison to external data vendors on behalf of the Commercial organization, setting priority for data delivery and ensuring standard reporting meets needs of organization
• Adhere to business intelligence development lifecycle and design principles, including best practices

Requirements:

• Bachelor's Degree in a relevant field
• 3+ years business experience in BI development
• Experience developing in BI tools such as Tableau, including data preparation for visualization
• Strong experience with Databricks or similar cloud data platforms, including data transformation and pipeline development
• Experience in SQL-based languages (e.g., SQL Server, Oracle SQL, or MySQL) for data extraction, transformation, and analysis across complex datasets
• Strong analytical, interpretive, & problem-solving skills
• Creative thinker with ability to generate, communicate and promote ideas
• Experience using syndicated data and business reporting systems
• Excellent communication skills: strength in influencing management decisions & engaging with sales managers
• Communicate complex quantitative analysis in a clear, precise, and actionable manner
• Self-motivated and ability to handle multiple/diverse tasks
• Team Oriented
• Ability to build relationships across the Company
• Experience leveraging generative AI (GenAI) tools to improve analytics, reporting, development, documentation, or business-process efficiency
• Consumer Package Goods industry experience
• Experience analyzing sales reports for retail or a CPG company