Information Systems Programmer

Iten Defense, Llc.; Ashtabula, Northern (OH, KY); Hybride; USD 85 000 - 120 000; Plein temps

Résumé du poste

Iten Defense, Llc. is seeking an ASP/VB/SQL Developer & Epicor Systems Administrator to support, maintain, and enhance our internal applications and Epicor ERP environment.

The role balances software development, ERP administration, analytics, and cross-functional collaboration to improve reliability, data accuracy, and workflow efficiency across operations. Responsibilities include developing tools, optimizing SQL queries, administering Epicor modules, building reports and dashboards, and

Qualifications

• 3+ years of relational database development with SQL Server.
• Experience with Epicor ERP (Kinetic) administration and BPMs.
• Ability to obtain and maintain U.S. security clearance.

Responsabilités

• Develop new tools and features to support production, maintenance, and admin workflows.
• Administer Epicor ERP users, security, and modules; configure BPMs and BAQs.
• Create SQL reports and dashboards; ensure data integrity across systems.
• Provide Tier 2/3 support and collaborate with IT, Production, and Quality teams.

Connaissances

Analytical thinking

Attention to detail

Independent work

Cross-functional collaboration

Formation

Bachelor's degree in Computer Science or related field

Outils

Microsoft SQL Server

Epicor ERP (Kinetic)

VB/ASP development

BAQs & BPMs

Description du poste

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.

Application Development & Support

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