Supply Chain Cost Control Analyst

Role Overview

• Perform detailed parts cost analysis and drive corrective actions to ensure alignment with budget.
• Review deviations between actual costs and budgeted parts costs in collaboration with Finance.
• Identify root causes for parts cost variances and develop action plans to address deviations.
• Review and collaborate with Finance on effectivity for parts costs on a quarterly basis.
• Work with cross-functional stakeholders to ensure parts are correctly set up in SYSPRO.
• Review and collaborate with the ERP team to identify and implement system setup improvements.
• Review Finance reports to identify concerns with GL setups; work with functional Buyers and leads to implementing corrections.
• Collaborate with Buyers and Sourcing teams to ensure purchase order pricing accuracy.
• Identify system exceptions or incorrectly set up items and support timely resolution.
• Review total inventory held in the warehouse and perform analysis to confirm optimal stock levels.
• Analyze and explain weekly and monthly inventory fluctuations.
• Review inventory turnover and investigate parts contributing to higher holding costs due to turnover issues.
• Identify non-moving inventory and work with stakeholders to define action plans, including alternative use, external sale, or scrap.
• Review planned versus actual cycle counts based on classification and required frequency; escalate issues if schedules are not met.
• Review and collaborate with Buyers on PO pushouts with high delta or carrying costs and document reasons for rejection.
• Understand SQL tables and extract required data to support dashboards and reporting.
• Recommend data structure improvements and collaborate with IT on the configuration and development of data tables.
• Create, maintain, and enhance Power BI dashboards.
• Review KPI data, identify areas for improvement, and drive corrective actions in collaboration with the ERP team.
• Support part setup activities and lead continuous improvement initiatives related to system accuracy.
• Create and maintain jobs within the ERP system.
• Work with Buyers and Sourcing to adjust buying rules to maintain optimal inventory levels.
• Review, monitor, and close out OPEX jobs in collaboration with respective Buyers.

Requirements

• Experience within Aerospace or large supply chain organizations would be an asset
• Advanced proficiency in Microsoft Excel, including complex formulas, data analysis, and reporting.
• Power BI experience is considered a strong asset, particularly for dashboard creation and KPI monitoring.
• Working knowledge of ERP systems, with SYSPRO experience preferred.
• Ability to understand SQL-based data structures and extract data for reporting and analysis.
• Strong auditing skills.
• Strong interpersonal skills.
• Must possess strong business acumen.
• Must be detailed oriented.
• Must be process driven.
• Must possess strong analytical skills.
• Ability to work in a team setting as well as independently.
• Excellent written and oral communication skills.
• Ability to present complex technical issues in a clear and concise manner.
• Strong organizational and time management skills with the ability to prioritize competing tasks.
• Demonstrated ability to work under pressure and meet deadlines.
• Current work authorization for Canada is required for all openings.
• A criminal background check is required for candidates aged 18 and over.

Tech Stack

• ERP
• SQL

Benefits

• Comprehensive Benefits (health care, dental care, life and disability coverage)
• RRSP group contribution programs with RRSP increasing based on seniority
• All-encompassing Employee Assistance Program (EAP) with 24/7 confidential support
• Corporate Partnerships (health and wellness, recreation and leisure, etc.)
• Company bonus incentive plan – which increases based on years of service
• Retirement bonus based on age and years of service
• Company events and celebrations throughout the year
• Long service vacation cash out at year end
• Recognition program
• Reimbursement Programs including Uniform – production Mr. Safety Shoe – work boots allowance
• Prescription safety glasses
• Childcare subsidy