Job Title: Data Administrator
Duration: 4+ months (Total hours: 832.00)
Location: 7107 – 8th Street NW, Edmonton, Alberta T6P 1T9
Hours per Day: 8
Hours per Week: 40
Description:
The Database Administrator maintain the ERP (e.g. SAP S4/HANA) database to support the Demand Planning and Inventory activities. Provides functional and technical support to ensure performance, operation, and stability of database system.
Primary Point of Contact and support for part setups / accuracy / knowledge of the system database with global interface.
Specific Accountabilities:
- Develops and maintains Demand Planning and Inventory Dashboards and Reports.
- Develops and maintains programs to improve Demand Planning and Inventory efficiency and communication between departments.
- Develops and maintains KPI reports for Demand Planning and Inventory group.
- Updates the tasks status on the Database Tracker and ensure on-time completion of all open tasks.
- Follows up with Engineering to collect incomplete technical information; and with Purchasing for quote clarity if/when questions arise on part requests and/or BOM information.
- Assists in the review Engineering BOMs to identify and populate the ERP Part Number information on Engineering BOMs
- per most current SA procedures.
- Trouble shoot database issues presented from global team members for systemic resolution (Inventory, Purchasing, Engineering) as required:
o Correct Units of Measures / Conversions
o Research/Request coordination of duplicate cleanups for part number accuracy
o Work on global Part Number mapping and Item Description consistency
o Assist w/ID of parts from Material Team members when system parts not known
o Correct vendor item details
o Correct INV and CON setup in SAP S4/HANA
- Cross-references and validates Part Numbers between different companies (CAN, USA, IRL etc).
- Manages data exporting and importing across database systems.
- Set up system to define & ID the UNSPSC codes on items.
- Train other global team members on system information.
- Develop process improvements to achieve company goals.
- Other duties as required.
Knowledge, Skills & Abilities:
- High school diploma. Post-secondary education is an asset.
- Attention to detail on item attributes and BOM information; and ability to problem solve when information is incomplete.
- Excellent written and verbal communication skills with other departments (engineering, purchasing, inventory, materials, operations, etc.); with ability to quickly resolve questions/issues effectively and completely.
- Strong organizational & follow-up activity on open items; and ability to track and complete multiple open tasks.
- Constant review /prioritization of workload based on most urgent needs (usually tied to dynamic mfg schedule).
- Experience w/team activities & processes reviews for global consensus and continuous improvement.
- Knowledge/experience with Manufacturing Operations, MRP/ERP systems, Inventory Management.
- Strong working knowledge of Excel, Word, Access, MS Teams.
- Knowledge of SAP S4/HANA system is required.
- Appreciate dynamic manufacturing environment w/rapidly evolving product designs driven by technology & customer demand.
- Supply Chain/Logistics systems experience is an asset.
- Able to work efficiently as a part of a team as well as independently.
- Attention to detail in all areas of work.
- Valid driverโs license and good driving record.
- Dependable, good organizational, time management and prioritizing skills.
- Strong work ethic and positive team attitude.
