Bilingual Inventory Analyst – Data-Driven BI & SQL

American-Iron-; Montreal (administrative region); On-site; CAD 60,000 - 85,000; Full time

Benefits offered by this job

Salary & benefits

RRSP

On-site cafeteria

Company events

Job summary

American Iron & Metal Company (AIM) is seeking an Inventory Analyst to join our Montreal team. You will monitor stock levels, analyze data, and support Buyers and Warehouse personnel to optimize inventory health.

The role requires strong Excel/Power BI capabilities, bilingual communication in French and English, and solid programming and database skills to drive accurate reporting and informed decision making.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Bilingual in French and English (oral and written).
• Experience with databases, spreadsheets, and programming tools.
• Strong Excel, Access, SQL Server, VBA and Power BI skills.

Responsibilities

• Maintain and improve inventory health by analyzing inventory statistics.
• Configure replenishment system parameters, min/max levels, and supplier data.
• Review weekly inventory purchase orders before submission.
• Analyze inventory reports, data trends, and national purchasing trends.
• Provide guidance to Buyers and Warehouse personnel.
• Perform regular inventory analyses and cycle counts.
• Prepare inventory reports with stock levels, variances, and KPIs.
• Present statistics to management and suggest process improvements.
• Coordinate with cross-functional teams to resolve discrepancies.

Skills

Excel

Access

SQL

VBA

Power BI

Bilingual (French/English)

Analytical skills

Programming skills

Education

Bachelor's degree in supply chain management

Bachelor's degree in Business Administration

Bachelor's degree in Mathematics

Job description

American Iron & Metal Company (AIM) is seeking an Inventory Analyst to join our Montreal team. You will monitor stock levels, analyze data, and support Buyers and Warehouse personnel to optimize inventory health.

The role requires strong Excel/Power BI capabilities, bilingual communication in French and English, and solid programming and database skills to drive accurate reporting and informed decision making.