Business Intelligence Analyst

Reports To: VP of Information Technology; works day-to-day with Commercial leadership

Location: Broomfield, CO / Hybrid

Compensation: $95,000- $125,000 base + 10% annual bonus target based on EBITDA

Job Type: Full Time

Travel Requirements: 5%

About the Role

Lignetics makes consumable products, including heating pellets, animal bedding, and grilling pellets, where demand moves with weather, seasonality, and retailer inventory. As part of the IT team, you will build and maintain the commercial BI environment, analyze the signals that drive demand, and deliver the reporting and insight senior leadership uses to run the business. You will use modern analytics and AI tools to get there faster.

What You Will Do

• Build analysis and tools on point-of-sale, on-hand inventory, weather, and internal sales data that signal changes in demand by category, customer, and region.

• Surface those signals early (sell-through shifts, inventory build or depletion, weather departures from normal) so the forecast and commercial teams can act on them.

• Prepare and present regular sales performance reporting to senior leadership.

• Design, build, and maintain dashboards and automated reporting and alerts that reduce manual work.

• Integrate data from Salesforce, retailer portals, external sources, and acquired businesses into reliable BI sources.

• Own data integrity across BI sources: identify and troubleshoot discrepancies, trace them to root cause, resolve them with source-system owners, and put checks in place so they don't recur. Maintain consistent KPI definitions.

• Use AI tools to speed up analysis, coding, and reporting, and validate output before it reaches decision-makers.

• Partner with commercial and cross-functional teams on requirements and ad-hoc analysis.