Logo for The J.M. Smucker Co.

Senior Analyst, Business Intelligence

Role overview

Summary

The Senior Analyst, Business Intelligence supports the Commercial organization by providing strategic analytics and reporting solutions. This role focuses on translating business questions into actionable insights and developing reliable data models and dashboards, collaborating with various stakeholders to enhance decision-making across the organization.

Qualifications

  • Bachelor’s Degree in a relevant field.
  • 3+ years business experience in BI development.
  • Strong experience with Databricks or similar cloud data platforms.
  • Experience in SQL-based languages for data extraction and analysis.
  • Excellent communication skills with strength in influencing management decisions.

Responsibilities

  • Design, develop, and maintain curated data models and reporting objects in the Databricks Platinum layer.
  • Develop, support and enhance Tableau dashboards by optimizing underlying data structures.
  • Analyze, design, code, test, and implement systematic solutions for reporting and data visualization.
  • Serve as a subject matter expert for BI development best practices and data modeling.

Key facts

Hard skills

Other skills

  • Communication
  • Problem Solving
  • Teamwork
  • Relationship Building

About the company

The J.M. Smucker Co. logo

The J.M. Smucker Co.

  • Food & Beverage
  • XLarge
  • 5,001–10,000
At The J.M. Smucker Co., it is our privilege to make food people and pets love by offering a diverse portfolio of brands available across North America. We are proud to lead in the Coffee, Consumer Foods, Dog Snacks and Cat Food categories by offering brands consumers trust for themselves and their families each day including Folgers®, Dunkin’®, Café Bustelo®, Jif®, Smucker’s® Uncrustables®, Smucker’s®, Milk-Bone® and Meow Mix®. Through our unwavering commitment to producing the highest quality products, operating responsibly and ethically and delivering on our Purpose, we will continue to grow our business while making a positive impact on society. For more information, please visit jmsmucker.com.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Your Opportunity as the Senior Analyst, BI

The Senior Analyst, Business Intelligence serves as a strategic analytics and reporting partner for the Commercial organization, supporting the full brand portfolio across customers and channels. This role translates business questions and reporting requirements into scalable, trusted, and intuitive business intelligence solutions that enable decision-making across sales, finance, category, and leadership teams. The Senior Analyst owns the design, development, testing, deployment, and enhancement of Tableau dashboards and related reporting solutions, while partnering closely with Information Services, data partners, and business stakeholders to ensure the underlying data models, curated reporting objects, and semantic definitions are reliable, performant, and aligned to business needs. The role also analyzes consumption, shipments, trade spending, profitability, forecasting, pricing, promotion, and share trends; communicates actionable insights; promotes BI development and governance standards; and provides informal coaching and project leadership to peers.

Location: Working Remote USA

In this role you will:

  • 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

What we are looking for:

Minimum 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
  • Limited travel required (1 trip per year on average)
  • Self-motivated and ability to handle multiple/diverse tasks
  • Team Oriented
  • Ability to build relationships across the Company

Additional skills and experience that we think would make someone successful in this role (not required):

  • 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

The Right Place for You 

We are bold, kind, strive to do the right thing, we play to win, and we believe in a strong community that thrives together. Our culture is rooted in our Basic Beliefs, and we believe in supporting every employee by meeting their physical, emotional, and financial needs. 

Stay connected with us on LinkedIn® 

We're an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, genetic information, age, national origin, disability status or protected veteran status. 

Related jobs

See all Business Intelligence Analyst jobs

Other jobs at The J.M. Smucker Co.