Lead BI Developer

The J.M. Smucker Co.•Orrville, OH

10d•Hybrid

About The Position

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.

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.

Nice To Haves

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.

Responsibilities

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.