Customer Contract Admin Analyst [Urgent Nedd]

MillenniumSoft Inc; Vernon Hills (IL); On-site; USD 34,000 - 41,000; Full time

Job summary

Medical Device Company in Vernon Hills, IL is seeking a Customer Contract Admin Analyst on a 12+ month contract to support GPO contract membership administration and ensure accurate pricing and notifications.

The role requires strong Excel skills (VLOOKUPs, pivot tables), data analysis, and the ability to manage a variable workload while working independently within a team.

Candidates must be US Citizens or GC holders; no H1Bs, W2 contract, and an Excel test is required.

Qualifications

• Strong analytical skills to interpret data, acquire, mine and analyze data.
• Advanced Excel skills, including VLOOKUPs and pivot tables.
• Ability to plan, organize, and prioritize a variable workload to meet schedules with accuracy.
• Ability to work independently and in a team, multi-task and stay motivated.
• Analytical problem solver.
• Experience with ERP (SAP) and BI/reporting systems preferred.

Responsibilities

• Support GPO Contract Membership team with administration of contract membership eligibility.
• Provide eligibility information to customers, distributors, and internal teams.
• Validate members’ eligibility and alignment to contracts for accurate pricing.
• Identify customer numbers based on address demographics from multiple sources.
• Ensure customers are aligned to appropriate GPO contracts/tier.
• Use Membership Analytics to verify Single Group Affiliation and identify expiring connections.

Skills

Analytical skills

Excel advanced

Data analysis

Prioritization & time management

Independent / teamwork

Problem solving

SAP ERP experience

BI reporting

Tools

SAP ERP

Job description

Job Title: Customer Contract Admin Analyst

Location: Vernon Hills, IL

Duration: 12+ Months

pay rate:25-30/hr

Client: Medical Device Company

Employment Type: Contract on W2 (Need US Citizens Or GC Holders Only)

No H1B’s

All Candidates must be submitted with an excel test result

Accountabilities In This Role

The position is responsible for supporting the GPO Contract Membership team with the administration of contract membership eligibility for national GPO (Group Purchasing Organization) agreements. This information is provided to customers, distributors, and internal business teams.

Scope includes validating GPO members’ eligibility and alignment to all contracts to ensure accurate customer pricing and notification to distributors.

• Identify BD’s customer number based on customer address demographics using various data sources.
• Validate customers are eligible for and aligned to the appropriate GPO contracts/tier
• Utilize Membership Analytics database to ensure customers are SGA (Single Group Affiliation) by identifying customer contract connections to be expired

Qualifications

• Strong analytical skills to interpret data to include data acquisition, data mining, and data analysis
• Strong proficiency and advanced skills with Microsoft Excel (Must demonstrate strong abilities with VLookups, pivot tables and other analytic formulas)
• Ability to plan, organize, and prioritize a variable workload to meet schedules with accurate results.
• Ability to work independently in a team environment, be self-motivated and to multi-task while achieving expectations.
• Analytical problem solver
• Preferred experience in ERP (SAP) and reporting (Business Intelligence) systems.