Programmer Analyst (38288)

Site Overview

Young Innovations is a manufacturer and marketer of high-quality dental equipment with sales in excess of $100 million. With an outstanding reputation for quality, the company has a broad portfolio of market leading products across a variety of categories.

CHARACTERISTICS OF THE CLASS: The Programmer Analyst role focuses on developing, testing, and maintaining customizations and integrations within the IFS ERP system. This position involves working with SQL Server, SSRS, PL/SQL, and .NET technologies to build reports, optimize databases, and support ERP enhancements. The ideal candidate will have at least eight years of experience with IFS ERP, strong technical and troubleshooting skills, and the ability to collaborate across teams in a fast-paced environment. The Programmer Analyst reports to the Director of IT.

This role is hybrid, office is located in Algonquin, IL. Candidates should apply if they live in the Algonquin, IL or Chicagoland area. 

ESSENTIAL DUTIES: 

• Develop, test, and maintain scripts and integrations within the IFS ERP system
• Create and optimize database objects including tables, views, and stored procedures
• Build and maintain reports using SQL Server Reporting Services (SSRS)
• Write and code databases using PL/SQL and T-SQL
• Design and build custom fields, events, and modules within IFS ERP
• Integrate IFS ERP with third-party systems using APIs and middleware
• Troubleshoot existing systems and APIs, providing timely and efficient resolutions
• Respond to support ticket requests within the time frame outlined in IT support policies

RELATED DUTIES:  

• Perform user acceptance testing to ensure quality and functionality of ERP enhancements
• Monitor deliverables and ensure the timely completion of assigned projects
• Manage competing priorities and allocate time effectively across multiple tasks
• Participate in system upgrades, patches, and regression testing
• Assist in documenting technical processes, user guides, and system architecture
• Collaborate with internal teams to clarify requirements and deliver technical solutions
• Stay current with trends in ERP development, .NET technologies, and database tools

MINIMUM QUALIFICATIONS:

Training and Experience

• Bachelor’s degree in computer science, information systems, or a related field
• Minimum of 5 years of hands-on application development experience in an IFS ERP environment

Knowledge, Abilities and Skills

• Strong experience with SQL Server, SSRS, ASP.NET, and HTML
• Proficiency in PL/SQL and .NET Core development
• Solid understanding of software development lifecycle (SDLC)
• Excellent troubleshooting and debugging skills for ERP systems and APIs
• Strong verbal and written communication skills
• Ability to work independently or collaboratively in a team setting
• Strong organizational skills and attention to detail

PHYSICAL REQUIREMENTS:

Manual dexterity and continual use of computers.  Occasional bending, frequent sitting. 

Working Conditions

Office environment and occasional exposure to manufacturing plant environment, with some abnormal variations in temperature, unavoidable fumes, noise, dust and atmospheric conditions.

Occasional travel to business sites based on project need.

Pay Range: $100,000 - $120,000 per year. 

The pay range reflects the minimum and maximum target for the position at the time of posting. Within the range, the compensation will be determined based on education/training, skill set, experience, and other organizational needs.

For information regarding our benefit offerings, please visit our company website at www.younginnovations.com  

Young Innovations, Inc. is an Equal Opportunity Employer and E-Verify participating employer.