What are the responsibilities and job description for the ERP Gatekeeper position at Besa Lighting?
Why Besa Lighting?
At Besa Lighting, we believe that lighting is a magical combination of art and science. Lighting affects everyone and provides the challenge for creative expression and efficient performance to be merged. Lighting has the ability to change the atmosphere in an environment; it can bring a sense of wow or make a space complete. Working at Besa is an opportunity to be a part of a company that values the balance of passion at work as well as home. The company structure offers the ability for the employees to have a meaningful impact on our customers, teammates, operations, and the overall culture. Besa Lighting has been able to develop and grow due to the innovative ideas from its employees. Located in the Columbus, Ohio metro area since 1993, Besa has proudly offered “sensibly contemporary” solutions for customers located throughout North America.
Position Summary
The ERP Gatekeeper will be responsible for maintaining the databases and applications, as well as performing inventory control activities. This position will require both a technical level experience and the ability to interface with all levels of users. The ERP Gatekeeper will be a self-motivated individual with a passion for management information systems and computer science.
Essential Job Functions
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Prepares inventory reports and identifies discrepancies to be reconciled
- Manages and maintains inventory systems for correct counts, weights, and dimensions
- Monitors item location accuracy
- Codes and manages automated tasks
- Supports and maintains enterprise resource planning and database applications
- Develops reports and custom requests for users
- Runs reports as needed to sustain operations
- Assists with application and user support when needed
- Inventory accounting, tracking, and management
- Tests programs or databases, corrects errors, and makes necessary modifications
- Plans, coordinates, and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure
- Specifies users and user access levels for each segment of the database
- Develops methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs
- Works as part of a project team to coordinate database development and determine project scope and limitations
- Process improvement
- Reviews project requests describing database user needs to estimate time and cost required to accomplish projects
- Trains users and answers questions
- Reviews workflow charts to understand tasks computers will perform, such as updating records
- Assists purchasing by creating/maintaining automated tools to guide the process
Competencies
- Technical capacity
- Thoroughness
- Time management
- Communication proficiency
- Financial management
Supervisory Responsibility
This position has no supervisory responsibilities.
Work Environment
This job operates in an office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, etc.
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit, use hands to fingers, and reach with hands and arms. The employee may be required on occasion to lift and/or move items up to and including 50 pounds.
Position Type/Expected Hours of Work
This is a full-time on-site position with the expected minimum 40 hours a week. Days and hours of work are Monday through Friday, 8:00 a.m. to 5:00 p.m. Overtime may be required as necessary.
Travel
Occasional overnight travel may be expected for this position up to one week annually.
Required Education and Experience
- Bachelor’s degree preferred
- Four years of IT experience required
- Four years of inventory management experience required
- Experience in the following:
- Microsoft Access – Intermediate
- Microsoft Excel – Intermediate
- Crystal Reports – Intermediate
- SQL – Intermediate
- Report writing – Intermediate
- Supply Chain Management Solutions – Beginner to Intermediate
- Macola ES
- WiSys
EEO Statement
Besa Lighting provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Besa Lighting complies with applicable state and local governing nondiscrimination in employment. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, compensation, and training.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.