Merchandising Analyst - Excel, PowerBI

Job Title:  Merchandising Analyst Duration: 6 months+ Location: Cincinnati OH  Required Pay Scale: 45-50/hr W2 ***Due to client requirements this role is only open to USC or GC candidates***   Job Summary:Job DescriptionThis Analyst role works with the Merchandising workstream to own in-stock performance measurement, develop guardrails and compliance reporting, and support promo readinessand days-of-supply optimization. The successful candidate will deliver actionable insights on shelf holding power, tail SKU behavior, and vendor dependencies to drive availabilityimprovements. Desired Skills:• Advanced Excel and Power BI skills; strong SQL proficiency, need to be able to write their own queries to solve problems; R or Python preferred• Demonstrated experience with merchandising analytics across DSD and/or Center Store and Perishables (in-stock/OSA, promo performance, supplier scorecards)• Proven ability to build guardrails/compliance reporting and translate analytics into operational actions• Excellent communication and presentation skills to support supplier enablement and cross-functional decision-making• Demonstrated ability to work independently and with others in a fast-paced environment • High level of analytical ability and interpersonal skills• Ability to multi-task and manage multiple analytical workstreams simultaneously• Strong problem-solving and organizational skills• Experience with supplier performance management and escalation processesKey Responsibilities• Own merchandising in-stock performance analytics (DSD + Center Store + Perishables); track OSA drivers tied to DSD performance, shelf holding power, and tail SKU behavior• Support supplier onboarding (e.g., KeHe and perishable suppliers) with performance views and reporting• Develop guardrails and compliance analytics; measure supplier performance versus escalation guardrails (e.g., <90% OSA for 2 periods) and provide reporting to operationalizeescalation mechanisms• Deliver promo readiness analytics; use deeper historical data and tools such as "Top Ten Commodity Lost Sales" to flag risk earlier and quantify expected lost sales exposure• Support Center Store case pack-out and DOS modeling; evaluate scenarios (e.g., ~10% pack-out increases) and quantify impacts to days of supply and in-stock performance• Perform perishable holding power analysis; quantify DOS/holding power opportunities and identify items/categories driving outs due to insufficient shelf holding power• Conduct Peyton dependency analysis; assess what percentage of promo items come from Peyton, quantify risk and impact of misses, and support setting standards/thresholdsfor WDDs• Create process adherence reporting; provide visibility to constrained item processes, new item setup impacts on in-stock, pending constrained items reporting, and usage of toolslike "Top 100" to drive action  About Matlen Silver Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: info@matlensilver.com // 908-393-8600 At The Matlen Silver Group, Inc., W2 employees are eligible for the following benefits:Health, vision, and dental insurance (single and family coverage)401(k) plan (employee contributions only)