Find & Apply For Computer Programmer Jobs in Ashtabula, Ohio

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