Business Analyst Intern

Description The Business Analyst Intern supports data-driven decision making across J. Lorber Company by turning ERP, CRM, and vendor data into clear analysis that leadership can act on. The role takes on a rotating set of analytical projects spanning sales and customer performance, vendor and product profitability, and recurring dashboard reporting in Phocas. Working closely with the Management team, the Business Analyst Intern delivers findings as clean spreadsheets, dashboards, and concise written recommendations that support pricing, inventory, purchasing, and sales strategy decisions across all branches.

Requirements

Essential Duties & Responsibilities Core duties and responsibilities include the following. Other duties may be assigned. Analyzes customer purchasing history to identify growth opportunities, at-risk accounts, and declining buying patterns; summarizes findings for sales leadership. Builds customer segmentation and ranking analyses (revenue, gross margin, order frequency, product mix) to support territory planning and account assignment. Measures sales performance against goals by branch, salesperson, product category, and customer segment; identifies variances and probable causes. Supports quote-to-order conversion analysis, identifying business lost to price, availability, or follow-up gaps. Evaluates vendor performance across purchase volume, rebate attainment, lead time, fill rate, and pricing competitiveness. Analyzes product-line profitability and margin trends; flags items with pricing, cost, or turn issues for review by the Director of Purchasing. Assists with inventory analysis including slow-moving and dead stock review, stocking-level evaluation, and turn-and-earn calculations. Prepares data summaries supporting vendor negotiations, line reviews, and new product evaluations. Builds, maintains, and improves dashboards and recurring reports in Phocas, the company’s business intelligence platform. Converts manual, one-off spreadsheet report