Inventory Control Specialist II

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

The Inventory Control Specialist II runs their site's count program independently and knows the full program end-to-end - policy, procedures, and system - well enough to execute without day-to-day direction. The Inventory Control Specialist II is expected to be as comfortable writing a query or building a variance dashboard as they are walking the floor and counting a skid. The Individual leads root-cause investigation on variances, builds the reporting that makes that investigation visible, and mentors Specialist I's — but does not have final decision authority: schedule changes, process changes, SoD conflict resolution, and anything that sets precedent across sites route to the Supervisor.

Requirements

Key Responsibilities

Count & audit execution

• 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.

Analysis & reporting

• 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.

Governance & mentoring

• Maintain the site's entries in the Location Ownership Matrix (IC-MTX-001); propose updates when locations, owners, or scope change.
• 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.

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.