Note: The job is a remote job and is open to candidates in USA. Insight Global is recruiting for a fully remote, long-term contract role supporting Google Fiber and its network engineering operations. The Supply Chain Analyst will manage demand planning, material scheduling, inventory, procurement data, and supply chain risks while using advanced SQL, SAP, Excel, and Google Sheets to optimize material availability and costs.
Responsibilities
- Responsible for building, maintaining and developing Demand Planning metrics, work in SAP to optimize reporting queries, this involves managing SQL lines and ensuring procurement data is accurate and in line with our business requirements
- Responsible to predict and resolve site specific material planning issues that arise, including over or under delivery and take up immediate actions in the event of material shortages put projects at risk
- Resolve material specifications, creating and maintaining company part number within PLM/Agile
- Monitor on-hand inventory, customer demand, project schedules, build plans, inventory transactions and material deltas
- Work closely with 3PL in overseeing logistics material management, colocation material delivery requirements, mitigating risk with logistics project managers and 3PL
- Actively support large site Decoms, reviewing, analyzing and auditing all material for effective disposition. Ensuring deployment engineering are following best practices for physical device decom along with proper material packaging per device disposition requirements. Overseeing A-Z on reverse logistics for material management
- Coordinate inventory levels and controls to mitigate material demand impact risk with active safety stock planning, demand forecasts and open orders. Build contingency plans around risk
- Coordination and management of suppliers to organize and ensure scheduled deliveries arrive on time. Or working with to create second sources, change allocations, or develop new partners if required
- Execute flexible material processes to provide shortage risk visibility, correct safety stock levels, aid business efficiency, and drive new process improvements
- Lead site materials planning applied across the business, while ensuring Bill of Materials (BOM) integrity, inventory accuracy and inventory movements are handled daily
Skills
- 5 years of experience with Data Analytics
- Data analytics (supply chain- more a plus)
- Data management- key to understand where data comes from and where it needs to go
- 6+yrs in a Planner based role (ability to hit the ground running)
- Understanding of BOM-bill of material lifecycle
- Strong working experience with excel/google sheets-advanced user/advanced formulas
- Manual work with google sheets/Excel (ability to handle large work samples)
- Critical thinking questions (what did you load, why, what's the action plans)
- Strong working knowledge with SQL-high level (combine tables, joins, strong complex queries )
- Experience creating (vlook ups, joins, Match functions, IT functions-SQL and Excel related work)
- Coming from networking or fiber industry is a plus!
- Strong Google Sheets
- Large background in Supply chain
- Strong working knowledge in SAP
Benefits
- Fully remote work arrangement
- Long-term contract
Company Overview
Company H1B Sponsorship