Programmer, Sr

Under general supervision, designs, develops, modifies, tests, documents, and supports business applications, databases, integrations, and reporting solutions. The position supports manufacturing, finance, accounting, payroll, inventory control, production management, customer service, and supply chain operations, with primary responsibility for the Infor Syte Line ERP environment and Microsoft SQL Server.

The programmer works directly with departmental users to clarify requirements, translate business needs into effective technical solutions, troubleshoot application issues, and improve the reliability, performance, security, and usability of enterprise systems.

• Design, develop, test, implement, document, and maintain custom business applications and program components.
• Read and interpret verbal and written program requests; clarify user needs, business rules, data requirements, and expected outcomes.
• Support, configure, customize, and troubleshoot the Infor Syte Line ERP environment.
• Maintain existing programs and create new applications, integrations, reports, and automated processes as business requirements change.
• Develop and maintain SQL Server databases, tables, stored procedures, views, functions, triggers, and SQL Agent jobs.
• Design and support integrations among Syte Line, third-party applications, databases, APIs, and cloud platforms.
• Create operational reports, dashboards, data extracts, and analytical datasets to support business decision-making.
• Diagnose and resolve application, database, interface, data-quality, and performance issues.
• Optimize application code, database queries, and data-processing routines for reliability and performance.
• Assist with ERP upgrades, testing, deployments, customizations, and system enhancements.
• Advise and train users on application functions, system capabilities, and appropriate procedures.
• Create and maintain technical specifications, system documentation, data mappings, test plans, and support procedures.
• Participate in software testing, source control, change management, and production deployment processes.
• Maintain data integrity and follow company standards for security, access control, backup, recovery, and regulatory compliance.
• Collaborate with Information Technology, Finance, Operations, Engineering, Customer Service, and other departments on application initiatives.
• Maintain regular punctuality, attendance, and absence reporting in accordance with company policies.
• Fully comply with company rules, policies, procedures, and safety guidelines to support safe and effective operations.
• Perform other related duties as assigned.

Any combination of education, training, and experience that provides the required knowledge, skills, and abilities may be considered.

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field. An equivalent combination of education and relevant professional experience may be considered.
• Three or more years of application development experience.
• Three or more years of Microsoft SQL Server development experience.
• Experience supporting ERP systems, preferably within a manufacturing environment involving finance, accounting, payroll, inventory control, purchasing, planning, production, and customer order processing.
• Experience developing system integrations and business reporting solutions.

• Hands-on experience supporting, configuring, customizing, and troubleshooting Infor Syte Line ERP.
• Knowledge of Syte Line tables, forms, Intelligent Data Objects (IDOs), business processes, data views, and queries.
• Experience with Syte Line form customization, IDO development, workflow, process automation, and the Application Event System (AES).
• Working knowledge of Infor OS and related integration capabilities.
• Ability to troubleshoot application errors, data inconsistencies, integrations, and performance issues within Syte Line.
• Understanding of manufacturing processes, including customer order processing, purchasing, inventory control, planning, production, and shop-floor operations.

• Strong Transact-SQL programming skills and experience using SQL Server Management Studio (SSMS).
• Experience developing and maintaining tables, stored procedures, views, functions, triggers, and SQL Agent jobs.
• Knowledge of relational database design, normalization, indexing, query optimization, and…