Job Details

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)