Business Intelligence Analyst

Lignetics, INC.; Broomfield (CO); Ibrido; USD 95.000 - 125.000; Tempo pieno

Descrizione del lavoro

Lignetics, INC. is seeking an experienced BI analytics professional to own the commercial BI environment. You will analyze signals that drive demand from POS, inventory, weather and internal sales data, building dashboards and automated reporting for senior leadership.

You will leverage SQL, Python or R, Tableau/Power BI, and AI tools to accelerate analysis while ensuring data quality across sources. Hybrid role in Broomfield, CO with base compensation of $95,000–$125,000 plus a 10% target

Competenze

• 3+ years in analytics, BI, or data science supporting sales, revenue, or demand planning.
• 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.

Mansioni

• Build analysis and tools on POS, 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.

Conoscenze

SQL

Python or R

Advanced Excel

Access

Statistics

Tableau/Power BI

AI/LLM tools

Data quality

Communication

Ownership mindset

Strumenti

Salesforce

ERP data

Cloud data platforms

ETL/pipeline tools

Descrizione del lavoro

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

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%

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