Inventory Control Specialist II: Analytics & Variance Lead

Tangent-Technologies,-LL; Aurora (IL); On-site; USD 65,000 - 90,000; Full time

Job summary

Tangent-Technologies,-LL is seeking an Inventory Control Specialist II to independently run the site’s count program, write queries, and build variance dashboards while counting on the floor. You’ll lead root-cause investigations and mentor Specialist I’s, with final authority resting with the Supervisor for policy changes.

Responsibilities include executing full cycle-counts, conducting VMI audits, and maintaining accurate site reporting using SQL and Excel/Power BI.

Qualifications

• 2+ years of Inventory Control Specialist experience or equivalent external cycle-counting/inventory experience.
• Demonstrated independent command of SyteLine inventory transactions and the site's SOPs.
• Working SQL skills - able to write and modify queries against SyteLine or a reporting layer.
• Comfortable building reporting/dashboards in Excel (Power Query, pivot tables) or Power BI/Tableau; exposure to Python or basic statistics is a plus but not required.
• Able to trace a variance to root cause methodically using data.
• Comfortable coaching a newer team member without formal authority over them.
• Explicitly willing and able to travel to assigned sites/VMI partner locations and perform physical audit work as a routine part of the job.

Responsibilities

• Own execution of the full A/B/C/D cycle-count program at the assigned site.
• Execute recurring external Vendor-Managed Inventory (VMI) audits at assigned partner locations, applying the same accuracy and dual-confirmation standards as internal counts.
• Build and adjust the site-level count schedule within the cadence set by policy (e.g., B every 2-3 months) - operational scheduling, not cadence policy itself.
• Lead root-cause investigation on variances: trace the handoff chain (receiving, production movement, transfers) to identify where the process broke down, using SyteLine transaction data rather than anecdote.
• Build and maintain the variance and KPI reporting layer for the assigned site (e.g., count-accuracy trends, aging of open variances, VMI discrepancy trends) using SQL queries and Excel/Power BI.
• Mentor and check the work of Specialist I's at the site, including basic reporting/query skills as they grow toward II; be the first point of contact for their questions before escalating to the Supervisor.
• Flag separation-of-duties conflicts when observed (e.g., an area owner attempting to approve their own adjustment)
• Support go-live readiness activities at the site (dry-run walkthroughs, baseline counts, checklist items) as the site's IC point of contact.

Skills

SQL queries

Power BI

Excel data analysis

Mentoring

Data tracing & root cause

Tools

SyteLine

Job description

Tangent-Technologies,-LL is seeking an Inventory Control Specialist II to independently run the site’s count program, write queries, and build variance dashboards while counting on the floor. You’ll lead root-cause investigations and mentor Specialist I’s, with final authority resting with the Supervisor for policy changes.

Responsibilities include executing full cycle-counts, conducting VMI audits, and maintaining accurate site reporting using SQL and Excel/Power BI.