Lead BI Developer

The J.M. Smucker Company; Akron (OH); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Hybrid work model

Mentorship opportunities

Professional development

Job summary

The J.M. Smucker Company is seeking a Lead BI Developer to work within their Information Services - Corporate Administration team in Orrville, Ohio. This role will drive the development of business intelligence solutions utilizing Databricks and Tableau to optimize data transformations and reporting.

The ideal candidate will have over 5 years of experience in BI development, along with a Bachelor’s degree in a relevant field. The position offers a hybrid work model with a minimum onsite requirement of 9 days per month.

Qualifications

• 5+ years of experience in BI development or analytics engineering.
• Strong experience with data transformation development.
• Ability to design scalable and maintainable data solutions.

Responsibilities

• Lead the design and development of BI solutions and reporting objects.
• Mentor junior team members on BI best practices.
• Implement performance tuning for large-scale data processing.

Skills

Data visualization

Databricks

SQL

Data governance

Agile methodologies

Performance optimization

Tableau

Education

Bachelor's degree in a STEM discipline or specialized training in IT/Data Analytics

Tools

Databricks

Tableau

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.