Material Database Admin

Requisition ID: 697 

Why Choose IMP Aerospace & Defence:
IMP Aerospace & Defence is not only one of the leading companies in the Aerospace field. But we are also one of the most engaging and equality advocating companies to work for. We believe that regardless of where you work at IMP Aerospace & Defence, you are apart of our ever-growing team. IMP is able to achieve success through this teamwork mindset. That is why at IMP, you are not defined by your role.

Position Overview:

The Material Database Administrator is responsible for performing critical data management functions to ensure the accuracy/reliability and integrity of the JD Edwards database. 

What You Will Do:

  • Ensure the input of accurate data into the JDE computer system iaw SPPs, ADs, QSPs, Work Instructions and approved technical documents.
  • Support efforts, including but not limited to performing audits and other forms of analysis of the inventory database.
  • Monitor and interpret aerospace material specifications, drawings and other approved technical documents to ensure our Material database is current, and that new Item Master and Item Branch entries are built iaw approved technical documents.
  • Correct &/or update the database to maintain current, accurate and consistent records.
  • Categorize parts for inventory monitoring purposes.
  • Modify and maintain Item Masters and Item Branch shelf life, Controlled Goods, and MSDS requirements/data.
  • Work effectively and efficiently with Planners, Buyers, Material Coordinators, Engineers, Asset Managers etc. to build and maintain Item Master, Item Branches, and Cross References iaw SPPs, ADs, QSPs, Work Instructions and approved technical documents.
  • Ensure new item Branches are built in the correct Branch Plant based on contractual and schedule requirements.
  • Complete inventory transactions, including but not limited to purchase order reversal transactions, reversing issues, transferring inventory.
  • Generate and action reports, including but not limited to the Referral Report, Shortage Reports, and Material Reports.
  • Minimize material shortages to ensure production schedule is not negatively impacted.
  • Update Work Order Line Types upon building new Item Branches for work order requirements.
  • Take a proactive approach to identify and resolve inventory control issues before they occur.
  • Assist in the development and analysis of Material performance metrics
  • Recommend and implement ways to reduce inventory holdings.
  • Report discrepancies in information to mitigate or minimize disruptions in the supply chain and ensure airworthiness is maintained. 
  • Provide oral and written reports and correspondence as required, internal and external. 

What You Will Bring:

  • Minimum High School completion with suitable work experience in the aerospace industry.  However, preference will be given to those candidates who possess a college diploma or undergraduate degree.
  • Position Requirements:
  • Accuracy and attention to detail is essential.
  • Strong analytical skills and the ability to work independently.
  • Strong skills in MS Office Suite of applications particularly Excel & Access
  • Experience with ERP systems (e.g. JD Edwards, SAP, PeopleSoft etc). 
  • Familiarity with CFTOs, Navairs, PDMPlus Web, IHS Standards Expert, and ASSIST an asset.
  • Strong verbal and written communications skills.
  • Ability to meet objectives working with colleagues.
  • Familiarity with the Aerospace industry inventory/logistics environment and its major challenges is an asset.
  • Familiarity with the ISO 9000 quality environments is an asset.
  • Incumbents must be able to pass and maintain Public Works Government Services Canada (PWGSC) and Transport Canada security clearances.
  • Must be eligible to meet requirements for Canadian Controlled Goods Program (CGP),  Secret Level II Security Clearance through PSPC- Contract Security Program, and  Transport Canada RAIC clearance.
  • Strong time management and organizational skills are required.
  • Review and become familiar with Annex C of the Maintenance Process Manual.
  • The ideal candidate will have 3 – 5 years experience in the aerospace supply/logistics or Production Planning field.

What We Will Do For You:

  • All of IMP's benefits become effective on your first day of work, regardless of your position.
  • We offer a comprehensive Benefits Package, including RSP Program, Holiday Incentive program (3 additional days off over Christmas), Tuition Reimbursement Program, Long Service Awards, Volunteer Grant Program, Scholarship Program, and more!

IMP is committed to Employment Equity and our goal is to be a diverse workforce that is representative at all job levels.  We welcome applicants from Aboriginal People, Visible Minority Groups, Persons with Disabilities and Women in occupations or positions where they are under-represented.  If you are a member of one of these equity groups, you are encouraged to self identify on either your cover letter or resume.