MP&L Analyst

Hanon Systems; Novi (MI); On-site; USD 55,000 - 75,000; Full time

Job summary

Hanon Systems in Novi, MI seeks a data-driven analyst to support the Regional MP&L team across USA, Canada, and Mexico. You will analyze customs and inventory data, build structured Excel datasets, and help develop dashboards and standardized reports for recurring analytics.

You will collaborate with external compliance teams, respond to USMCA inquiries, and assist with classifying parts while coordinating weekly follow-ups to drive continuous improvement and accurate business decisions.

Qualifications

• Strong analytical mindset with the ability to work with large datasets.
• Proficiency in Microsoft Excel and similar data analysis or transformation tools.
• Ability to combine, reconcile, and analyze data from multiple sources.
• Familiarity with logistics, customs, and trade compliance data.
• Ability to communicate findings clearly through written reports and visual presentations.
• Bachelor’s degree in supply chain management, operations, business, or a related field.

Responsibilities

• Support the Regional MP&L team (USA, Canada, and Mexico) with data analysis, reporting, and cross-functional coordination.
• Analyze customs and inventory data to support compliance requirements and process improvements.
• Prepare and maintain structured datasets in Excel to support business decisions.
• Assist in developing dashboards, templates, and standardized reports for recurring analytics.
• Work with customs brokers and analyze ACE and broker reports to provide monthly updates.
• Respond to USMCA and customs compliance-related inquiries.
• Support OEM customer requests and USMCA compliance activities in collaboration with the external compliance team.
• Assist with the classification of purchased parts, manufactured parts, and finished goods.
• Conduct weekly follow-up meetings with the external compliance team regarding open and pending items.

Skills

Data analysis

Excel

Data reconciliation

Trade compliance data

Data storytelling

Education

Bachelor’s degree in supply chain/related field

Tools

SAP

Job description

• Support the Regional MP&L team (USA, Canada, and Mexico) with data analysis, reporting, and cross-functional coordination.
• Analyze customs and inventory data to support compliance requirements and process improvements.
• Prepare and maintain structured datasets in Excel to support business decisions.
• Assist in developing dashboards, templates, and standardized reports for recurring analytics.
• Work with customs brokers and analyze ACE and broker reports to provide monthly updates.
• Respond to USMCA and customs compliance-related inquiries.
• Support OEM customer requests and USMCA compliance activities in collaboration with the external compliance team.
• Assist with the classification of purchased parts, manufactured parts, and finished goods.
• Conduct weekly follow-up meetings with the external compliance team regarding open and pending items.

Required Skills & Qualifications

• Strong analytical mindset with the ability to work with large datasets.
• Proficiency in Microsoft Excel and similar data analysis or transformation tools.
• Ability to combine, reconcile, and analyze data from multiple sources.
• Familiarity with logistics, customs, and trade compliance data.
• Ability to communicate findings clearly through written reports and visual presentations.
• Bachelor’s degree in supply chain management, operations, business, or a related field.

Preferred Experience

• 2 to 3 years of experience in customs, trade compliance, logistics, or supply chain environment, preferably within a manufacturing or industrial setting.
• SAP

Personal Attributes

• Curious and motivated to understand customs, compliance, and inventory data.
• Proactive, self-driven, and committed to continuous improvement.
• Strong problem-solving skills with the ability to work independently.
• Organized, dependable, and able to manage multiple priorities and deadlines.
• Team-oriented with strong interpersonal and communication skills.