Supply Chain Analyst 5

Customer Job Supply Chain Analyst 5

Job ID: 26-01233 Pay rate range: 35hr. to 40hr. Schedule: Fully onsite, 9am-6pm

Job Description Top skills: • 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 task 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

KEY RESPONSIBILITIES/REQUIREMENTS

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 in order 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 Bachelors Degree with 3-5 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 re-clientrching 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 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.

Physical/Mental Demands and Working Conditions The position requires the ability to perform the essential duties and responsibilities in the following environment: • Work is generally performed in an office environment. • Operate a computer keyboard and view a video display terminal between 50 - 95% of work time, including prolonged periods of time. • Requires considerable 90% work utilizing high visual acuity, detail, numeric, character distinction and moderate hand-finger dexterity. • The movement and transportation of equipment most of the time is under 25 pounds. • Performs work under time schedules and stress which are normally periodic or cyclical, including time-sensitive deadlines, intellectual challenge, some language barriers and project management deadlines. • Machines, tools, equipment and work aids include PCs, printers, copiers, faxes and other equipment commonly associated with an office work area. • May require working additional hours beyond normal schedule. • Consistently demonstrates a commitment to policies and procedures, including but not limited to attendance, confidentiality, conflict of interest and ethical responsibilities.