Business Intelligence Analyst
- Burlington, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Apply
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
What You Bring
Required
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.
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.
- 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.
- 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.
- 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
More about this job
Responsibilities
Build and maintain commercial BI tools, dashboards, automated reporting, and demand-signal analysis using sales, point-of-sale, inventory, and weather data. Ensure data integrity and consistent KPIs, present performance insights to senior leadership, and partner with commercial teams to support forecasting and business decisions.
Requirements
Requires at least three years of analytics, BI, or data science experience supporting sales, revenue, or demand planning, along with strong SQL and Python or R, advanced Excel and Access, applied statistics, and visualization-tool experience. Candidates should demonstrate practical use of AI or LLM tools, experience resolving data-quality issues across systems, and the ability to communicate analysis clearly to executives.
Skills
- SQL
- Python
- R
- Advanced Excel
- Microsoft Access
- Applied Statistics
- Regression Analysis
- Time Series Analysis
- Trend Analysis
- Tableau
- Power BI
- Demand Planning
- Data Quality Management
- AI and LLM Tools
- Salesforce
- Executive Communication
Benefits
- Annual Bonus Eligibility
- Employee Referral Bonus Program
- Paid Time Off
- Two Floating Holidays
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Flexible Spending Account
- Health Savings Account
- Educational Assistance
- Life Insurance
- Short-Term Disability Insurance
- Long-Term Disability Insurance
- 401(k) With Employer Match and Immediate Vesting
- Employee Heating Pellet Program
- Company Swag and Annual Work Boots
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Manufacturing
Keywords
- Business Intelligence
- Commercial Analytics
- SQL
- Python
- R
- Excel
- Microsoft Access
- Tableau
- Power BI
- Artificial Intelligence
- Large Language Models
- Point-of-Sale Data
- Inventory Data
- Weather Data
- Demand Planning
- Forecasting
- Regression
- Time Series Analysis
- Trend Analysis
- Salesforce
- ERP
- Data Integration
- Data Quality
- KPI Definitions
- Automated Reporting
- Dashboards
- Retailer Portals
- Cloud Data Platforms
- Data Pipelines
- Consumer Packaged Goods