Demand Analytics BI Analyst | AI-Driven Dashboards

Lignetics, INC.; Broomfield (CO); Hybrid; USD 95,000 - 125,000; Full time

Job summary

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

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL

Python or R

Advanced Excel

Access

Statistics

Tableau/Power BI

AI/LLM tools

Data quality

Communication

Ownership mindset

Tools

Salesforce

ERP data

Cloud data platforms

ETL/pipeline tools

Job description

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