Jr Data Analyst-Inventory

HALO is hiring a Jr. Data Analyst (Inventory) to support its Inventory Analytics & Reporting team. The role maintains accurate inventory data, performs routine analysis, and develops reporting and dashboards to improve inventory visibility in collaboration with analysts and supply chain teams.

Responsibilities

• Prepare recurring inventory reports and develop, maintain, and enhance Power BI dashboards that provide visibility into inventory levels, aging, availability, movement, and key supply chain metrics
• Analyze inventory data using Power BI, Excel, and reporting tools to identify trends, discrepancies, and potential risks
• Review inventory data for completeness, accuracy, and unusual changes; investigate discrepancies and escalate unresolved issues as needed
• Monitor inventory levels, aging, availability, and movement; identify and communicate potential excess inventory, shortages, or replenishment risks
• Support inventory planning activities by gathering and organizing demand, usage, shipment, and on-hand inventory data
• Reconcile inventory data across reports and systems, document variances, and assist with corrective actions
• Maintain inventory-related master data, including item, location, and product information, in accordance with established procedures and controls
• Respond to routine reporting and data requests while ensuring accuracy and timely delivery
• Partner with Inventory, Procurement, Operations, Finance, and other internal teams to resolve data and reporting questions
• Document reporting processes, assumptions, data definitions, and recurring issues to ensure consistency and repeatability
• Identify opportunities to improve reporting, streamline processes, and enhance dashboard functionality
• Protect confidential business information and adhere to company policies and data governance practices
• Perform other duties as assigned

Preferred

• Associate's or Bachelor's degree in Supply Chain, Business, Analytics, Information Systems, or a related field preferred
• Equivalent education, coursework, internships, or relevant experience will also be considered
• Experience with inventory management, ERP, warehouse management, or reporting systems
• Familiarity with data visualization best practices and business intelligence tools
• Exposure to Power BI data modeling, DAX, or dashboard development
• Coursework, project work, or practical experience involving forecasting, statistics, supply chain analytics, or inventory management
• Information Systems
• Inventory Management
• ERP Systems
• Warehouse Management Systems
• Reporting Systems
• Business Intelligence Tools
• Data Modeling
• DAX
• Dashboard Development
• Forecasting
• Statistics
• Supply Chain Analytics

Benefits

• Nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits.
• 401(k) Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).
• Career advancement through internal promotion, learning from industry leaders, access to HALO’s influential global network, leadership opportunities, and diverse perspectives.
• Recognition of milestones and awards; accumulated recognition can be converted into gift cards, trips, concert tickets, and merchandise.

Company

• Optical transceiver and connectivity solutions for enterprise, telecom, government
• Tustin, California, USA
• https://www.halotechnology.com/
• Founded in 1999
• 201-500 employees

Qualifications

• 2+ years of experience in inventory, supply chain, operations, reporting, analytics, or a related support role
• Hands-on experience with Power BI, including creating dashboards, reports, data visualizations, and KPI tracking
• Experience writing SQL queries to extract, validate, and analyze data for reporting and Power BI dashboards
• Strong Excel skills, including formulas, PivotTables, sorting, filtering, and data validation
• Ability to work with data, identify trends, and validate accuracy
• Strong attention to detail and commitment to maintaining data integrity
• Effective written and verbal communication skills
• Strong organizational and time management skills with the ability to manage recurring priorities
• Collaborative mindset and willingness to learn inventory, supply chain, and reporting processes
• Associate's or Bachelor's degree in Supply Chain, Business, Analytics, Information Systems, or a related field preferred
• Equivalent education, coursework, internships, or relevant experience will also be considered
• Experience with inventory management, ERP, warehouse management, or reporting systems
• Familiarity with data visualization best practices and business intelligence tools
• Exposure to Power BI data modeling, DAX, or dashboard development
• Coursework, project work, or practical experience involving forecasting, statistics, supply chain analytics, or inventory management
• 2+ years of experience in inventory, supply chain, operations, reporting, analytics, or a related support role.

Required skills

• Power BI, SQL, Microsoft Excel, Inventory Management, Supply Chain Analytics, Data Visualization, DAX, Forecasting, Statistics

Experience

• 2+ years