Business Intelligence Analyst - Hybrid

The Kyjen Company, LLC
Centennial, CO, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$65,000.0 - $75,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Access Microsoft Excel Data Analysis Backup Devices Dataspaces Power BI SQL Databases Tableau (Software) Amazon Marketplace Data Analytics Looker Analytics

Job description

The Business Intelligence Analyst serves as the analytical backbone supporting the Sales, Ecommerce, Planning, and Finance teams. This role provides data-driven insights across forecasting, pricing, inventory, and SKU portfolio management to enable better decision-making throughout the commercial organization. Sitting within the Business Intelligence department, this position brings objectivity, data rigor, and analytical consistency to commercial and operational decisions - while partnering closely with stakeholders across the business to ensure customer, channel, and SKU-level intelligence informs every recommendation., Forecasting & Demand Analytics

  • Analyze demand forecasts produced by the Sales team; identify gaps, bias, and accuracy trends at the SKU, customer, and channel level.
  • Provide recommendations for Sales, Ecommerce, and Planning on forecast adjustments based on historical performance, promotional activity, and market signals.
  • Partner with Sales and Ecommerce to incorporate customer-specific intelligence - new programs, promotions, lost business, channel shifts - into the forecast.

Pricing Analytics

  • Analyze pricing performance across customers, channels (including DTC and marketplace), and product categories; identify opportunities for optimization.
  • Support Sales and Ecommerce with customer and channel-specific pricing analysis for new business, line reviews, MAP enforcement, and negotiations.
  • Monitor competitive pricing and market positioning where data is available.
  • Evaluate promotional pricing effectiveness (lift, ROI, cannibalization) and inform future promo strategy.

Inventory Analytics

  • Analyze inventory health across the network - coverage, days of supply, aging, slow movers, stockouts, and excess.
  • Support Finance with inventory exposure analysis, reserves recommendations, and write-down risk assessments. Flag inventory risks tied to forecast misses, customer program changes, or channel shifts.

SKU Rationalization

  • Lead the analytical work behind SKU rationalization reviews; evaluate SKU-level performance across revenue, margin, velocity, customer penetration, and strategic fit.
  • Recommend SKUs for discontinuation, consolidation, or investment based on a defined analytical framework. Quantify the financial and operational impact of rationalization decisions (margin lift, inventory release, complexity reduction).

Business Intelligence & Reporting

  • Build and maintain dashboards, reports, and self-service tools used across Sales, Ecommerce, Planning, and Finance.
  • Deliver ad hoc analyses to answer questions from leadership and cross-functional partners.
  • Ensure data quality and consistency across commercial, inventory, and financial datasets.

Requirements

Do you have experience in Technical Proficiency?, Do you have a Bachelor’s degree?, Required

  • Bachelor’s degree in Business, Economics, Statistics, Finance, Supply Chain, Data Analytics, or a related quantitative field.
  • 3+ years of experience in BI, analytics, demand planning, commercial analytics, or FP&A.
  • Strong proficiency in SQL and at least one BI tool (Power BI, Tableau, Looker, or similar).
  • Advanced Excel skills and working knowledge of Access.
  • Strong communication skills with the ability to translate complex analysis into clear recommendations for non-technical stakeholders.

Preferred

  • CPG, consumer products, pet, or retail industry experience.
  • Familiarity with mass retail customers and their data ecosystems (e.g., Walmart Retail Link, NIQ/Circana syndicated data).
  • Experience with ecommerce and marketplace data (Amazon Vendor/Seller Central, Chewy, etc.).
  • Familiarity with pricing and revenue management concepts (elasticity, mix, promo analytics).

Key Skills & Attributes

  • Analytically rigorous and comfortable working with large, imperfect datasets.
  • Strong business acumen - able to connect data back to commercial, operational, and financial outcomes.
  • Collaborative partner who can speak the commercial language of Sales and Ecommerce, the operational language of Planning, and the financial language of Finance.
  • Self-directed; identifies analytical opportunities proactively.
  • Detail-oriented without losing sight of the bigger picture.

Benefits & conditions

3.43.4 out of 5 stars Centennial, CO 80112 $65,000 - $75,000 a year - Full-time, Pulled from the full job description

  • Pet insurance
  • AD&D insurance
  • Parental leave
  • Health insurance
  • 401(k) matching
  • Paid time off
  • Vision insurance, Our Benefits (for full-time employees)
  • Medical / Dental / Vision/Accident
  • HSA
  • 401K & 100% Employer Match (Fully vested after 1 year)
  • Flexible Paid Time Off (includes vacation and sick time)
  • Parental Leave
  • Basic Term Life and AD&D (Employer Paid)
  • Voluntary Term Life and AD&D
  • Pet Insurance (Employer Paid)
  • Annual Bonus Potential

We invite all candidates to apply!

Outward Hound is an Equal Opportunity Employer. We value diversity and we strive to create an inclusive and equitable environment for all our employees. We do not discriminate on the basis of race, gender, religion, color, national origin, gender identity, age, marital status, sexual orientation, veteran status, disability, or any other protected status.

Annual Salary - $65-$75k DOE

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

Videos

See all

Related articles

See all