Senior Analyst, Business Intelligence

J.M. Smucker; United States; Remote; USD 90,000 - 140,000; Full time

Job summary

J.M. Smucker is seeking a Senior Analyst, BI to partner with Commercial teams, translating business questions into scalable analytics and dashboards.

You will own Tableau reporting, data modeling, and data governance with close collaboration across Information Services and data partners. You will design and optimize data assets, deliver insights on shipments, trade spending, profitability, pricing, and promotions, and mentor peers in BI best practices.

Qualifications

• 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.
• Limited travel required (1 trip per year on average)

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.

Skills

BI development

Tableau

Databricks

SQL

Communication

Data modeling

Education

Bachelor's degree in a relevant field

Tools

Databricks

Tableau

SQL

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.