Senior Analyst, Business Intelligence

The J.M. Smucker Company; Orrville (OH); Remote; USD 90,000 - 120,000; Full time

Job summary

The J.M. Smucker Company is seeking a Senior Analyst, BI to partner with Commercial teams across brands and channels. You will design and maintain Tableau dashboards, optimize data models in Databricks, and translate business questions into scalable analytics solutions.

You will collaborate with Information Services and data partners to ensure reliable data and actionable insights. You will analyze consumption, trade funds, profitability, forecasting, pricing and promotions, while promoting BI

Qualifications

• Bachelor's degree in a relevant field.
• 3+ years of BI development experience.
• 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, and problem-solving skills.
• Creative thinker with ability to generate, communicate and promote ideas.
• Experience using syndicated data and business reporting systems.
• Excellent communication skills with ability to influence management decisions and engage with sales managers.

Responsibilities

• Design, develop, and maintain curated data models and reporting objects to support enterprise BI and analytics use cases.
• Develop, support and enhance Tableau dashboards with optimized underlying data structures.
• Build scalable, reusable data assets that enable Tableau dashboards and self-service reporting.
• Create, maintain, improve, and analyze reporting dashboards with internal and external syndicated data sources.
• Partner with stakeholders to translate business questions into scalable reporting and data visualization solutions.
• Collaborate with IS, data engineering, analysts, and partners to translate reporting requirements into data models 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 data governance, naming standards, and development lifecycle practices.
• Foster cross-functional collaboration to improve efficiency across the analytics team.
• Liaise with external data vendors to prioritize data delivery and ensure reporting meets needs.

Skills

Tableau

SQL

Data modeling

Data visualization

Cross-functional collaboration

Problem solving

Education

Bachelor's degree

Tools

Databricks

Tableau

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.