Programmer

Position Overview

The ASP/VB/SQL Developer & Epicor Systems Administrator is responsible for supporting, maintaining, and enhancing the organization’s internal applications and Epicor ERP environment. This position ensures system reliability, data accuracy, and workflow efficiency across multiple operational and administrative functions. The role requires a balanced combination of software development, ERP administration, analytical problem-solving, and cross department collaboration.

Essential Duties and Responsibilities

Application Development & Support

• Maintain and enhance internal web-based applications built on Classic ASP, VBScript, JavaScript, HTML/CSS, and SQL Server.
• Develop new tools and features to support production, maintenance, compliance, and administrative workflows.
• Create and optimize SQL stored procedures, views, triggers, and queries to support reporting and automation.
• Diagnose and resolve application issues, ensuring stable and consistent performance.
• Improve user interfaces and user experience for operator facing and administrative tools.
• Document application changes, technical specifications, and development processes.

Epicor ERP Administration

• Administer Epicor ERP user accounts, security roles, menu access, and permissions.
• Support Epicor modules including Production Management, Engineering, Inventory, Maintenance, and Quality.
• Configure Epicor BPMs, BAQs, Method Rules, and Data Directives to enforce business logic and improve workflow reliability.
• Maintain core Epicor data structures such as Parts, Resources, Operations, and Job records.
• Assist with Epicor upgrades, testing, validation, and deployment of customizations.
• Monitor Epicor system performance and troubleshoot issues related to data, workflows, or integrations.

Reporting, Data Management & Integrity

• Develop SQL-based reports and dashboards for leadership, compliance, and operational teams.
• Ensure data accuracy and consistency across Epicor, SQL Server, and custom applications.
• Implement automated data validation routines to support audit readiness and reduce manual corrections.
• Support KPI reporting for production efficiency, downtime, maintenance activity, and quality metrics.

Workflow Optimization & Automation

• Analyze existing workflows to identify inefficiencies and opportunities for improvement.
• Design and implement automation solutions using SQL, Epicor BPMs, and custom applications.
• Support continuous improvement initiatives related to production, maintenance, compliance, and administrative processes.
• Collaborate with cross functional teams to streamline data entry, reporting, and operational procedures.

Technical Support & Cross Functional Collaboration

• Provide Tier 2/Tier 3 support for Epicor issues, SQL data concerns, and internal application functionality.
• Assist end users with training, documentation, and adoption of new tools or workflow changes.
• Work closely with IT, Production, Engineering, Quality, and Compliance teams to align system capabilities with business needs.
• Maintain clear and organized documentation of system configurations, customizations, and standard operating procedures.

Required Qualifications

• Bachelor's degree in computer science, Information Technology, other related field, or equivalent practical experience.
• 3+ years of experience with relational database development using Microsoft SQL Server (complex queries, views, stored procedures, indexing, and triggers).
• 3+ years of experience developing and maintaining web applications (HTML, CSS, JavaScript, Classic ASP / VBScript).
• Ability to obtain and maintain U.S. security clearance.

Preferred qualifications

• 2+ years of hands-on technical experience with Epicor ERP (Kinetic), including building BAQs, BPMs, and custom dashboards.
• Demonstrated understanding of core manufacturing ERP modules (Engineering, Job Management, Inventory, Quality).
• Experience working in an ISO 9001 and/or AS9100 certified environment
• Familiarity with CMMC compliance and ITAR restrictions.
• Experience supporting manufacturing operations.

Competency

• Analytical thinking and problem-solving
• Attention to detail and accuracy
• Process improvement mindset
• Ability to work independently and collaboratively
• Strong organizational and prioritization skills
• Adaptability in a dynamic environment

Working Conditions

• Standard office environment with periodic interaction on the production floor.
• Occasional after-hour support during system updates or critical issues.
• Collaboration with multiple departments and stakeholders.

Pay: $55,000.00 - $65,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• AD&D insurance
• Dental insurance
• Disability insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid holidays
• Paid parental leave
• Parental leave
• Pet insurance
• Professional development assistance
• Tuition reimbursement
• Vision insurance

Application Question(s):

• Are you an Untied States Citizen?

Education:

• High school or equivalent (Preferred)

Security clearance:

• Confidential (Preferred)

Ability to Commute:

• Ashtabula, OH 44004 (Required)

Work Location: In person