Strategic Sourcing & Contracts Data Analyst

Integrated Resources INC; Mounds View (MN); On-site; USD 60,000 - 90,000; Full time

Job summary

Integrated Resources, Inc., a premier staffing firm, seeks a data analyst to create standard test matrices across suppliers, consolidate survey data into in-house matrices, and analyze data from multiple disciplines including Micro, Chem, Pharma and Packaging.

The role involves reviewing contracts and invoices, refreshing cost savings data, and coordinating finance reviews for TCO savings. Strong Excel/Access proficiency is required.

Qualifications

• Advanced analytical skills.
• Expertise in Excel.
• Expertise in Access.
• Experience with indirect preferably within labs/testing areas.

Responsibilities

• Work with SME and create standard test matrix across suppliers - Micro only.
• Incorporate information from previous surveys into new in-house matrix - Micro only.
• Consolidate & perform analysis on data obtained from all disciplines (Micro, Chem, Pharma, Packaging, etc.).
• Identify suppliers under contract and provide copies of contracts & SOWs for review; review contracts and prepare a meaningful matrix of contracts.
• Review invoicing against contracted rates.
• Refresh cost savings information based on data provided by suppliers; coordinate Finance reviews for TCO savings.
• Create capability matrix by discipline based upon standard data collection from suppliers.
• All suppliers and in-house. Includes identification of all equipment used in-house.
• Build an excess equipment matrix for all disciplines.

Skills

Advanced analytical skills

Expertise in Excel

Expertise in Access

Experience with indirect preferably in

Tools

Excel

Access

Job description

Integrated Resources, Inc., a premier staffing firm, seeks a data analyst to create standard test matrices across suppliers, consolidate survey data into in-house matrices, and analyze data from multiple disciplines including Micro, Chem, Pharma and Packaging.

The role involves reviewing contracts and invoices, refreshing cost savings data, and coordinating finance reviews for TCO savings. Strong Excel/Access proficiency is required.