Business Intelligence Analyst Hybrid
Centennial, CO - USA
Job Summary
Position Summary
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.
Key Responsibilities
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.
Qualifications
Required
- Bachelors 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.
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
Required Experience:
IC
About Company
This is a Hybrid role, all candidates must be local to Outward Hound's corporate office in Centennial, CO. Job Summary: The Market Analyst at Outward...