Lead BI Developer

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

Job summary

The J.M. Smucker Company is seeking a Lead BI Developer for its Information Services team in Orrville, Ohio. This role involves designing and developing scalable business intelligence solutions, including data transformations and visualizations to drive insights and business outcomes.

The ideal candidate will have over 5 years of BI development experience, a relevant Bachelor's degree, and strong skills in Databricks and Tableau. This hybrid position allows for some remote work and requires excellent communication to collaborate with various stakeholders.

Qualifications

• 5+ years of experience in BI development or analytics engineering.
• Bachelor's degree in a relevant field or specialized IT training.
• Experience with data transformation in Databricks or similar platforms.
• Strong knowledge of SQL-based languages for data manipulation.
• Excellent communication skills for technical translation.

Responsibilities

• Design and develop scalable BI solutions in Databricks.
• Lead the creation of Tableau dashboards and resolve business requirements.
• Optimize data processing and ensure quality governance practices.
• Mentor junior team members on BI best practices.

Skills

BI development

Data transformation

Tableau

SQL

Data governance

Databricks

Performance optimization

Education

Bachelor's degree in STEM

Tools

Databricks

Tableau

Python

Job description

Your Opportunity as the Lead BI Developer, Information Services - Corporate Administration

The Smucker Information Services (IS) department enables technology solutions for capabilities that help our business perform, transform and grow. The Lead BI Developer on the IS Corporate Administration Team realizes this purpose by designing, developing, and maintaining scalable business intelligence solutions that provide enterprise-grade reporting and analytics. The Lead BI Developer will drive the building and optimization of data transformations and curated reporting objects within the company-standard data lakehouse architecture (Databricks), ensuring high-quality, consumable datasets for analytics. This role emphasizes visualization delivery, BI solution development, and data platform best practices. The Lead BI Developer serves as an advisor and subject matter expert to business stakeholders and IS partners, providing a clear vision for downstream reporting via trusted and reusable data assets.

Location: Orrville, Ohio (Close proximity to Cleveland/Akron)

Work Arrangements: Hybrid - onsite a minimum of 9 days a month primarily during core weeks as determined by the Company; maybe more as business need requires

In this role you will:

• Partner directly with internal business customers of varying analytics maturity and data literacy to plan and deliver opportunities for business intelligence and insights that drive business outcomes. Influence and contribute to capability and technology roadmaps within business areas, particularly pertaining to reporting and analytics.
• Lead the design, development, and maintenance of curated data transformations, scalable data assets and reporting objects in the Databricks Platinum layer to support enterprise BI and analytics use cases.
• Lead the design, development and maintenance of Tableau dashboards and other visualizations by ensuring alignment to architectural standards and optimization for performance and usability.
• Influence and clarify business requirements that lead to efficient, well-structured data transformations and semantic layers.
• Implement performance tuning and optimization strategies for large-scale data processing and BI workloads.
• Influence the design and operation of data pipelines, partnering with Enterprise Data Platform teams on their delivery of data engineering, modeling and governance activities.
• Provide expert knowledge and support to audit and compliance activities involving BI reports. Serve as an escalation point for analytics resources within business functions.
• Influence and steward data governance, naming standards and development lifecycle practices.
• Lead improvements to BI architecture, tooling, and development processes that support data quality, consistency and reliability across curated datasets.
• Mentor junior team members and provide subject matter expertise on BI development and visualization best practices as well as reporting enablement.

What We Are Looking For:

Minimum Requirements:

• 5+ years of experience in BI development, analytics engineering or related roles.
• Bachelor's degree in a STEM discipline (Business, Engineering, MIS, Computer Science, or related field) or specialized training in Information Technology and/or Data Analytics.
• Experience delivering assignments independently under limited guidance within formal delivery methodologies/frameworks (Agile, Traditional/Waterfall, DevOps).
• Familiarity with modern data architecture concepts such as Lakehouse, ELT frameworks, and data orchestration tools.
• Strong experience with Databricks or similar cloud data platforms, including data transformation development.
• Experience with preparing data and developing visualizations in tools such as Tableau.
• Experience making decisions and guiding approach on applying SQL-based languages (e.g., SQL Server, Oracle SQL, or MySQL) for data extraction, transformation, and analysis across complex datasets.
• Knowledge of CI/CD practices within data and analytics development.
• Advanced understanding of performance optimization techniques for large datasets. Experience navigating trade-offs between design approaches and fulfillment of requirements.
• Ability to design scalable, maintainable, and well-documented data solutions. Experience influencing designs and improving documentation processes.
• Advanced problem-solving and technical troubleshooting skills.
• Excellent communication skills with ability to translate technical concepts to non-technical stakeholders.

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

• Experience working in CPG-related analytics environments or supporting administrative functions such as Finance, Accounting, Human Resources, Communications, Legal, Enterprise Risk, Ethics & Compliance.
• Experience integrating Databricks with enterprise BI ecosystems.
• Experience with Python or other scripting languages for data processing.
• Experience applying artificial intelligence (AI) capabilities and technology toward solution development and analytics use cases.
• Experience implementing data governance and metadata management practices, including use of platforms such as Atlan.
• Demonstrated ability to train, mentor or manage work of other resources (internal or contracted) on business intelligence topics.
• Knowledge of modern IT concepts such as Cloud Computing and Infrastructure as Code.

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.