Lead BI Developer

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

About the role

The Lead BI Developer on the IS Corporate Administration Team designs, develops, and maintains scalable business intelligence solutions that provide enterprise-grade reporting and analytics. This role drives 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. 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.

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.

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.
• Ability to design scalable, maintainable, and well-documented data solutions.
• Advanced problem-solving and technical troubleshooting skills.
• Excellent communication skills with ability to translate technical concepts to non-technical stakeholders.

Skills

Additional skills and experience that would be beneficial:

• 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.