Job Description
Job Description
GENERAL PURPOSE:
At SumiRiko Ohio, Inc. we understand that our ERP, data collection, and web applications are at the heart of our success. The Application Support Engineer will work alongside the team to build new custom applications, and support the maintenance of our existing applications, ERP and data collection systems, and participate in the integration of DX technologies. This position will work with staff at multiple Sumitomo Riko America group companies to implement and maintain systems, while maintaining standardization.
ESSENTIAL FUNCTIONS:
- Design, develop, support, and maintain new web-based, custom applications that support business needs and eliminate manual processes.
- Build dashboards, reports, and queries within business intelligence applications.
- Utilize advanced ERP capabilities and automations to provide solutions to business users.
- Troubleshoot and provide end-user support for ERP, data collection (barcode scanners and barcode printers), EDI, and other 3rd party applications via the use of SQL queries, code reviews, logs, data analysis, performance monitoring, and testing.
- Coordinate with 3rd party vendors and internal stakeholders for installations, testing, troubleshooting, supporting tickets, and case escalation.
- Spend time with business users and plant-floor staff to understand and learn business processes and design new solutions.
- Integrate BI and custom web applications with 3rd party software and databases.
- Design new barcode labels to support both internal processes and external customer needs.
- Support EDI and Shipping Applications, including purchase orders, customer schedules, and shipment notifications.
- Support the implementation and integration of DX and automation technologies.
- Research and evaluate new technologies to streamline our processes and support our business.
- Demonstrate a strong willingness to learn new applications and solution techniques through self-guidance and experimentation.
OTHER RESPONSIBILITIES AND JOB INFORMATION:
- The SumiRiko Ohio Information Technology Department is a service organization. It is imperative that the associates in this department have the skills and personality to effectively communicate with business users in a professional manner. This also includes the ability to discuss systems on a level easily understood by the user and not necessarily on a technical level. This position requires the associate be self-motivated and involved in providing solutions.
- This position supports our ERP system consisting of IFS / Radley iCARaS (EDI) / Radley Data Collection (Barcode Scanners).
- Participate in after-hours, production down support activities/on call rotation.
MINIMUM REQUIREMENTS: The minimum qualifications needed to perform the essential functions of the job such as education, competencies, experience, knowledge, and skills. This includes any specialized knowledge and expertise applicable to the job.
- Minimum of an Associate Degree in Computer Science, Information Technology, or Programming.
- Superior knowledge of using SQL to build reports, retrieve and update data, and troubleshoot (direct PL/SQL experience is a plus).
- Experience in creating, maintaining, and supporting SQL Server and/or Oracle databases.
- Proficiency with report writers, business intelligence software, and programming languages.
- Knowledge of ERP concepts and barcode technology standards.
- Strong experience with HTML and web development.
- Experience with developing custom web applications using Python/Flask is preferred.
- Maintaining applications on both Windows and Linux servers is required.
The ideal candidate will be self-motivated, able to work efficiently and independently, and have good time management, organizational, and documentation skills.