Find & Apply For Business Intelligence Analyst Jobs in Broomfield, Colorado

The Role Build and maintain commercial business intelligence tools, dashboards, automated reports, and alerts using sales, inventory, weather, and external data. Analyze demand signals and present sales performance insights to senior leadership. Integrate data from Salesforce, retailer portals, and acquired businesses; troubleshoot data quality issues; maintain KPI definitions; and partner with commercial teams on ad hoc analysis, forecasting, and decision support. Use SQL, Python or R, advanced Excel, visualization tools, and AI/LLM tools. Summary Generated by

Built In Description 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. Requirements What You Bring Required
• 3+ years in analytics, BI, or data science supporting sales, revenue, or demand planning, ideally in CPG, retail, agriculture, energy, or another seasonal or consumption-driven business.
• Strong SQL and Python or R, plus advanced Excel and Access.
• Applied statistics: regression, time series, and trend analysis.
• Hands-on experience with a visualization tool such as Tableau or Power BI.
• Demonstrated use of AI/LLM tools in real analytical work, with examples you can walk us through.
• Track record of diagnosing and fixing data quality issues across multiple source systems.
• Ability to explain analysis, and its limits, to non-technical executives in plain language.
• Ownership mindset: you take a messy question to a finished answer without being managed step by step. Preferred
• Experience with retailer POS and inventory data (e.g., retailer portals, syndicated data).
• Experience analyzing weather- or seasonally-driven demand.
• Familiarity with Salesforce and ERP sales data.
• Experience with cloud data platforms and pipeline tools.
• Experience integrating data from acquisitions/disparate data sources. What Success Looks Like
• 90 days: You know our data, categories, and customers; you have validated the core performance reporting and shipped your first automation.
• 6 months: Demand-signal analysis (POS, on-hand inventory, weather) is live for our major categories and feeding the forecast and pre-season planning cycle.
• 12 months: Demand shifts are flagged ahead of the forecast, manual reporting time is materially reduced, and leadership relies on your analysis for customer and inventory decisions.

Benefits Annual Bonus Eligibility Employee referral bonus program PTO+ 2 floating holidays Medical, Dental, and Vision Insurance (FSA & HSA options) Educational assistance Life insurance, short term & long-term disability 401(k) with employer match & immediate vesting Employee heating pellet program Lignetics SWAG gear to include an annual pair of work boots & other PPE #IDCorporate Read Full Description Skills Required 3+ years of experience in analytics, business intelligence, or data science supporting sales, revenue, or demand planning Experience in CPG, retail, agriculture, energy, or another seasonal or consumption-driven business Strong SQL Strong Python or R Advanced Excel and Access Applied statistics, including regression, time series, and trend analysis Hands-on experience with Tableau or Power BI Demonstrated use of AI/LLM tools in analytical work Experience diagnosing and fixing data quality issues across multiple source systems Ability to explain analysis and limitations to nontechnical executives Ownership of analytical work from ambiguous question through completed answer Experience with retailer point-of-sale and inventory data Experience analyzing weather-driven or seasonally driven demand Familiarity with Salesforce and ERP sales data Experience with cloud data platforms and pipeline tools Experience integrating data from acquisitions or disparate data sources View all jobs at Lignetics Inc. View Lignetics Inc. Profile Report Job