Business Intelligence Analyst

Lignetics•Broomfield, CO

10d•Hybrid

About The Position

Lignetics is seeking a Business Intelligence Analyst to build and maintain the commercial business intelligence environment as part of the IT team. The role analyzes point-of-sale, on-hand inventory, weather, and internal sales data to identify demand signals by category, customer, and region, and delivers reporting and insights that senior leadership uses to run the business. The analyst will use modern analytics and AI tools to accelerate analysis and reporting while validating outputs before they reach decision-makers. The position reports to the VP of Information Technology and works day-to-day with Commercial leadership. It is based in Broomfield, Colorado, with a hybrid work arrangement, 5% travel, and a base compensation range of $95,000–$125,000 plus a 10% annual bonus target based on EBITDA. Success expectations include learning the data, categories, and customers and validating core performance reporting within 90 days; launching demand-signal analysis for major categories within six months; and flagging demand shifts ahead of forecasts, materially reducing manual reporting, and supporting customer and inventory decisions with trusted analysis within 12 months.

Requirements

At least 3 years of experience in analytics, business intelligence, or data science supporting sales, revenue, or demand planning.
Strong SQL and Python or R skills, plus advanced Excel and Access skills.
Applied statistics experience, including regression, time-series, and trend analysis.
Hands-on experience with a visualization tool such as Tableau or Power BI.
Demonstrated use of AI or LLM tools in real analytical work, with examples to discuss.
Track record of diagnosing and fixing data-quality issues across multiple source systems.
Ability to explain analysis and its limitations to non-technical executives in plain language.
Ownership mindset and ability to take a messy question through to a finished answer without step-by-step management.

Nice To Haves

Experience with retailer POS and inventory data, such as retailer portals or 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 or disparate data sources.

Responsibilities

Build analyses and tools using point-of-sale, on-hand inventory, weather, and internal sales data to identify demand changes by category, customer, and region.
Surface sell-through shifts, inventory build or depletion, and weather departures from normal early enough for forecasting and commercial teams to act.
Prepare and present regular sales performance reporting to senior leadership.
Design, build, and maintain dashboards, automated reporting, and alerts that reduce manual work.
Integrate data from Salesforce, retailer portals, external sources, and acquired businesses into reliable BI sources.
Maintain data integrity across BI sources by identifying and troubleshooting discrepancies, tracing root causes, resolving issues with source-system owners, and establishing checks to prevent recurrence.
Maintain consistent KPI definitions.
Use AI tools to accelerate analysis, coding, and reporting, and validate outputs before sharing them with decision-makers.
Partner with commercial and cross-functional teams on requirements and ad-hoc analysis.