Application Support Engineer

Strategic Systems Inc; Bluffton (OH); On-site; USD 60,000 - 90,000; Full time

Job summary

Strategic Systems Inc in Bluffton, Ohio is seeking an Application Support Engineer to build new custom applications, support ERP and data collection systems, and help integrate DX technologies across our group companies.

You will design, develop, and maintain web-based solutions, perform SQL data analysis, create BI reports, and collaborate with vendors and internal users to deliver reliable, scalable software.

Qualifications

• Associate degree in CS/IT or programming.
• Strong SQL skills to build reports and troubleshoot data.
• Experience with SQL-Server and/or Oracle databases.
• Proficiency in HTML and web development.
• Knowledge of ERP concepts and barcode technology standards.
• Experience with Python/Flask is preferred.
• Experience maintaining applications on Windows and Linux.

Responsibilities

• Design, develop, support, and maintain new web-based applications.
• Utilize ERP capabilities and automations to provide solutions.
• Troubleshoot ERP, data collection, EDI, and third-party apps via SQL and logs.
• Build dashboards, reports, and queries in BI tools.
• Integrate BI and custom apps with third-party software and databases.
• Coordinate with vendors and internal stakeholders for installs and testing.
• Collaborate with users to understand business processes and design new solutions.
• Support DX integrations and automation technologies.
• Research new technologies to streamline processes.

Skills

SQL queries

ERP concepts

HTML

Python/Flask

BI software

Data analysis

Web development

Windows & Linux

Documentation

Education

Associate Degree in Computer Science/IT/Programming

Tools

SQL-Server

Oracle databases

IFS ERP

Radley iCARaS

Radley Data Collection

Job description

The Application Support Engineer will work alongside the team to build new custom applications, support the maintenance of existing applications, ERP, and data collection systems, and participate in the integration of DX technologies. This position will work with staff at multiple 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.
• 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.
• Build dashboards, reports, and queries within business intelligence applications.
• Integrate BI and custom web applications with 3rd party software and databases.
• Coordinate with 3rd party vendors and internal stakeholders for installing, testing, and troubleshooting application issues.
• Liaise with 3rd party vendors for troubleshooting and support, enter support tickets on 3rd party sites, and elevate tickets to ensure timely resolution.
• Collaborate with business users and plant-floor staff to understand and learn business processes and design new solutions.
• Design new barcode labels to support both internal processes and external customer needs.
• Support EDI and shipping applications, including customer 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 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 to be self-motivated and involved in providing solutions.
• This position supports our ERP system consisting of IFS, Radley iCARaS (EDI), and Radley Data Collection (barcode scanners).
• This individual will participate in after-hours and production support activities and an on-call rotation.

MINIMUM REQUIREMENTS:

• 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.