sr Analyst - Diamond And Gemstone Supply Planning

Summary

This team plays a critical role in Tiffany's supply chain, strategically assessing business requirements by conducting timely and effective analysis of demand forecasts versus the stone supply while highlighting data and insight to the internal Laurelton network as well as the polished procurement teams. This is achieved through rigorous analysis and interpretation using JDE, Business Objects, DAS, APS and Power BI reporting and off-system/manual sources. Analytical research includes communication/collaboration with various departments such as Inventory Planning, Product Development, Finance, Diamond Acquisition, Laurelton, Gemstone Acquisition, Stone Operations, Sourcing and JDIW as required. This role will support and assist the team by gathering, analyzing and reporting diamond and gemstone supply related information, employing diverse analytical techniques and software tools, including advanced MS Excel and Power BI.

Responsibilities

• Gather monthly cycle data and create required reports for further analysis and assessment.
• Identify and assess supply and capacity constraints, collaborating with Manager to create action plans.
• Identify anomalies and outliers in source data, make recommendations and implement improvement to processes and procedures.
• Convert various data inputs into clear and concise summaries (numerical and graphical/visual) to produce actionable information and insights for the team.
• Update standard daily/weekly/monthly report schedules utilizing systems such as JDE, Business Objects, DAS to provide a current view into the pipeline.
• Quantify stone shortages, communicate constraints and priorities to the respective cross functional teams.
• Maintain the new product manual forecasts (off system demand), ensure accuracy and upload of data through partnership other teams.
• Responsible for monthly 3rd party stone procurement orders and off cycle reviews.
• Identify and communicate monthly grading priorities to the grading labs based on data reviews and business product knowledge.
• Translate finished goods demands into required polished production/procurement and forecast supply based on current pipeline information.
• Maintain a view into our diamond melee, gemstone, and pearl pipelines to understand possible constraints or issues to meet demand.
• Identify and understand changes in demand and forecast potential impacts to inventory using scenario analysis.
• Manage supply expectations and share insights through routine month cycle reporting.
• Support inventory forecasting and planning based on insights on future demand (both systematic and manual) as well as incoming supply.
• Monitor and participate in Product Development discussions to capture demand manually.
• Quantify new launches, including development requirement and builds into forecasts.
• Monitor the MS Teams channels for all related PD groups and update files with availability and timeline details.
• Assess ability to support stone requirements from loose inventory. Provide recommendations for substitutions and procurement.
• Respond to stone requests from the Watch Company, TSC, High Jewelry, Custom, JDIW and other teams.
• Provide coverage and additional representation for the team during absences or when external department support is required.
• Possess the capability and knowledge to represent the team in meetings and presentations when needed.
• Comply with security and safety operating procedures. Report security related and safety observations and incidents to supervisor.

Requirements

• Undergraduate College Degree.
• Ability to work in detail with accuracy.
• Ability to work as part of a team or independently.
• Strong computer skills (Microsoft Office - Advanced Excel skills, PowerPoint, Visio).
• Excellent analytical, organizational, communication, follow-up, and problem-solving skills.
• Ability to be flexible and adapt to changing priorities.
• Clear written and verbal skills.
• Demonstrates experience with working under pressure or with time sensitive/urgent deadlines.
• Exhibits personable skills to build solid working relationships.
• Working knowledge of JDE, Business Objectives, Direct Access, Power BI (Preferred).