Data Analyst I – Branch Operations & Inventory Analytics
Nova Infotek, Mckinney, TX, United States
Role Title:
Data Analyst I – Branch Operations & Inventory Analytics
Experience:
0–3 years
Project Tenure:
18 Months
Work Mode:
Hybrid (4 days onsite, 1 day remote)
Work Location:
McKinney, Texas / (Remote)
Employment Type:
Full-Time
Core Responsibilities
Perform daily and weekly inventory reconciliation across multiple ERP systems (Prophet 21, Eclipse) to identify stock mismatches and posting delays
Analyze branch-level sales vs. inventory movement to flag dead stock, overstock, and stock-out risks
Build SQL queries to extract and validate transactional data (orders, receipts, transfers) from internal databases
Support standardization of SKU mapping across acquired branches with inconsistent item master structures
Work with branch managers to validate discrepancies between system data and physical counts
Generate operational reports tracking fill rates, backorders, and inventory turnover at branch level
Identify patterns in demand variability and recommend adjustments to reorder points and safety stock
Assist in data cleanup initiatives tied to ERP consolidation efforts
Participate in weekly operations calls with regional leadership to review analytics findings
Required Qualifications
Bachelor’s degree in Data Analytics, Supply Chain, Business, or related field
0–3 years of experience working with structured business or operational datasets
Strong SQL skills (multi-table joins, aggregations, filtering large datasets) — mandatory and tested
Hands-on Excel experience (pivot tables, lookups, data cleaning) in a professional or internship setting
Ability to work with transactional data (sales, inventory, logistics, or operations)
Comfortable working in a fast-paced, branch-driven operational environment
Willingness to work onsite and interact with non-technical stakeholders
Preferred Qualifications
Exposure to inventory, warehouse, or distribution datasets
Familiarity with ERP systems like Prophet 21, Eclipse, SAP, or similar
Experience supporting operations or supply chain teams
Basic understanding of demand planning, stock movement, or fulfillment metrics
Experience with Power BI or Tableau (supporting role, not primary)
Data Analyst I – Branch Operations & Inventory Analytics
Experience:
0–3 years
Project Tenure:
18 Months
Work Mode:
Hybrid (4 days onsite, 1 day remote)
Work Location:
McKinney, Texas / (Remote)
Employment Type:
Full-Time
Core Responsibilities
Perform daily and weekly inventory reconciliation across multiple ERP systems (Prophet 21, Eclipse) to identify stock mismatches and posting delays
Analyze branch-level sales vs. inventory movement to flag dead stock, overstock, and stock-out risks
Build SQL queries to extract and validate transactional data (orders, receipts, transfers) from internal databases
Support standardization of SKU mapping across acquired branches with inconsistent item master structures
Work with branch managers to validate discrepancies between system data and physical counts
Generate operational reports tracking fill rates, backorders, and inventory turnover at branch level
Identify patterns in demand variability and recommend adjustments to reorder points and safety stock
Assist in data cleanup initiatives tied to ERP consolidation efforts
Participate in weekly operations calls with regional leadership to review analytics findings
Required Qualifications
Bachelor’s degree in Data Analytics, Supply Chain, Business, or related field
0–3 years of experience working with structured business or operational datasets
Strong SQL skills (multi-table joins, aggregations, filtering large datasets) — mandatory and tested
Hands-on Excel experience (pivot tables, lookups, data cleaning) in a professional or internship setting
Ability to work with transactional data (sales, inventory, logistics, or operations)
Comfortable working in a fast-paced, branch-driven operational environment
Willingness to work onsite and interact with non-technical stakeholders
Preferred Qualifications
Exposure to inventory, warehouse, or distribution datasets
Familiarity with ERP systems like Prophet 21, Eclipse, SAP, or similar
Experience supporting operations or supply chain teams
Basic understanding of demand planning, stock movement, or fulfillment metrics
Experience with Power BI or Tableau (supporting role, not primary)