Position: Supply Chain Analyst 5
Location: Plano, TX
Duration: 12 Months
Job Description:
Top 3 must-have skills/requirements:
• Strong analytical skillset (Excel, data manipulation, building reporting experience)
• Collaboration/Communication (can work across the team and connect with planning counterparts at Accounts
• Self-Starter, need someone who will take tasks and figure out the best way to do but also willing to ask questions as they go vs. waiting for everything to spelled out for them
- Education: BA/BS
- How many years of experience is required: 3-5
Essential Duties & Responsibilities
• Must have strong Excel skills and be able to create reports using company data in Excel. Must be capable of taking existing Excel template and understand correct formula usage to maintain and update report.
- Respond to ad-hoc reporting requests from internal and external customers in a time sensitive environment
• Analyze weekly Purchase Sales Inventory (PSI) to identify sales target status, drive product manufacturing, and ensure timely fulfillment of delivery to achieve sales plans, product development, and strategic product launches.
• Manage system-based tools that provide real-time information regarding sales, order forecast, and channel inventory; extract data to conduct channel inventory analysis and reconciliation.
• Provide daily/weekly updates of product arrival schedules from factories and against customer delivery commitments. Reviewing and identifying variances compared to outstanding sales orders and forecasts, to plan for future product availability and inventory.
• Monitor team performance on weekly/quarterly KPIs to identify exception cases and analyze those metrics for potential process improvements to drive operational efficiency.
• May communicate daily between headquarters and internal cross-functional teams and handle escalation on production allocation, delivery requirements, and inventory management.
Background/Experience
• A bachelor’s degree with 2-4 years of experience preferably in finance, business, or supply chain management; MBA preferred.
• Experience in the telecommunications and/or wireless industry requiring management of finance, logistics, distribution, program management, and/or business planning, or equivalent work experience in planning, finance, or operations (Preferred)
• Experience should include researching and resolving customer product development, launch, delivery, and logistics issues, driving process improvement to streamline business cadence.
• Data Analytics, Forecasting and direct Customer interface experience preferred.
Necessary Skills/Attributes for this position the following skills and abilities must be demonstrated at a proficient level:
• High Excel proficiency. Must be able to use advanced functions and formulas to create reports. experience in developing KPI and executive dashboards preferred.
• Proven success in a highly dynamic and fast paced environment
• Experience building standardized reports in Tableau or other reporting tool preferred
• The ability to work either independently or in a team environment to achieve personal and team project goals, including the completion of assignments within and exceeding established time frames.
• Forecasting - The ability to prepare sellout volume projections for Marketing promotions, prepare weekly sellout forecast and use Data Analytics to identify developing trends and problem areas.
• The ability to learn new Planning and Analytics Tools.
Please Note: The Pay Rate for this role varies from $38-$42/hr. depending on the experience, industry, skills and commute.