Power BI–Driven Materials Planning Analyst

Sinomax USA; La Vergne (TN); On-site; USD 70,000 - 90,000; Full time

Job summary

Sinomax USA is seeking a Materials Analyst to support purchasing, production planning, and inventory management by maintaining accurate material data and translating it into actionable supply chain insights.

The role monitors material requirements, inventory availability, shortages and planning parameters, identifies supply risks, and collaborates across departments to resolve issues affecting production and delivery.

Qualifications

• Bachelor's degree in Finance, SCM, Business Analytics, or related field.
• At least three years of experience in supply chain analytics, material planning, or production planning.
• Advanced proficiency in Microsoft Excel and proficiency with other MS Office applications.
• Experience using Power BI, SQL, and Excel VBA for data analysis, reporting, or process automation.
• Strong analytical, statistical, problem-solving, and decision-making skills.
• Strong written and verbal communication skills with cross-functional teams.
• Bilingual Mandarin/English communication is a big plus.

Responsibilities

• Analyze daily supply chain and production metrics to identify material shortages, inventory discrepancies, production constraints, and other operational issues.
• Perform root-cause analysis and coordinate corrective actions with Supply Chain, Production, and Warehouse teams.
• Evaluate shortages, capacity gaps, and risks affecting production plans and customer delivery; communicate findings to Planning, Purchasing, and Production.
• Support purchase-order planning by analyzing material requirements, lead times, inventory, and supplier-held inventory.
• Develop and maintain Power BI dashboards and reports to monitor material availability and support decisions.
• Develop time-phased and just-in-time material supply plans with Operations to ensure availability and controlled inventory.
• Analyze inventory, consumption, processing activity, and aging stock to support decisions.
• Create plant-level inventory strategies to improve turnover and reduce obsolete inventory.
• Prepare material deviation or substitution requests, track approvals, and communicate status to stakeholders.
• Assist with material returns, scrap transactions, and inventory adjustments.
• Ensure company procedures are followed in Materials Department activities.

Skills

Strong analytical skills

Mandarin/English bilingual

Education

Bachelor's degree in Finance, SCM or Business Analytics

Tools

Power BI

SQL

Excel VBA

MS Excel

Microsoft Office

Job description

Sinomax USA is seeking a Materials Analyst to support purchasing, production planning, and inventory management by maintaining accurate material data and translating it into actionable supply chain insights.

The role monitors material requirements, inventory availability, shortages and planning parameters, identifies supply risks, and collaborates across departments to resolve issues affecting production and delivery.