Business Intelligence Analyst

LIGNETICS INC•Broomfield, CO

10d•$95,000 - $125,000•Hybrid

About The Position

The Business Intelligence Analyst will build and maintain Lignetics’ 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 provides 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 is based in Broomfield, Colorado, on a hybrid basis, reports to the VP of Information Technology, and works day-to-day with Commercial leadership. Compensation is $95,000–$125,000 base salary plus a 10% annual bonus target based on EBITDA. Travel requirements are 5%.

Requirements

At least 3 years of experience in analytics, BI, or data science supporting sales, revenue, or demand planning.
Strong SQL and Python or R skills, plus advanced Excel and Access.
Applied statistics skills, including 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 to discuss.
Experience diagnosing and fixing data quality issues across multiple source systems.
Ability to explain analysis and its limitations to non-technical executives in plain language.
An ownership mindset and ability to take a messy question through to a finished answer without step-by-step management.

Nice To Haves

Experience supporting a seasonal or consumption-driven business, ideally in CPG, retail, agriculture, or energy.
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 analysis and tools using point-of-sale, on-hand inventory, weather, and internal sales data to identify demand changes by category, customer, and region.
Surface demand signals, including sell-through shifts, inventory build or depletion, and weather departures from normal, so forecast and commercial teams can respond.
Prepare and present regular sales performance reporting to senior leadership.
Design, build, and maintain dashboards, automated reporting, and alerts to reduce manual work.
Integrate data from Salesforce, retailer portals, external sources, and acquired businesses into reliable BI sources.
Own data integrity across BI sources by identifying and troubleshooting discrepancies, tracing root causes, resolving issues with source-system owners, and implementing checks to prevent recurrence.
Maintain consistent KPI definitions.
Use AI tools to accelerate 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.