Programmer Analyst ( IFS ERP , .NET, SSRS, MS SQL Server , PL/SQL)

IT Associates; Illinois; On-site; USD 100,000 - 120,000; Full time

Job summary

IT Associates seeks a Programmer Analyst to develop, test, and maintain customizations and integrations within the IFS ERP system. You will work with SQL Server, SSRS, PL/SQL, and .NET technologies to build reports, optimize databases, and support ERP enhancements.

The role requires a Bachelor’s degree and 5–8 years of hands-on ERP development experience, with strong communication skills and the ability to work independently or in a team. Salary range is competitive with comprehensive benefits.

Qualifications

• Bachelor’s degree or equivalent in CS/IS or related field.
• 5–8 years of hands-on application development in an IFS ERP environment.
• Strong experience with SQL Server, SSRS, ASP.NET, and HTML.
• Proficiency in PL/SQL and .NET Core development.
• Solid understanding of the 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 in a team.
• Strong organizational skills and attention to detail.

Responsibilities

• 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 resolutions.
• Respond to support ticket requests within IT policies.
• Perform user acceptance testing for ERP enhancements.
• Monitor deliverables and ensure timely completion of projects.
• Manage competing priorities across multiple tasks.
• Participate in system upgrades, patches, and regression testing.
• Document technical processes, user guides, and system architecture.
• Collaborate with internal teams to clarify requirements and deliver solutions.
• Stay current with ERP development, .NET technologies, and database tools.

Skills

SQL Server

SSRS

ASP.NET

HTML

PL/SQL

.NET Core

Education

Bachelor’s degree in computer science, information systems, or related field

Job description

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.

MINIMUM QUALIFICATIONS:

• Bachelor’s degree in computer science, information systems, or a related field
• Minimum 5-8 years of hands-on application development experience in an IFS ERP environment
• 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

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

The anticipated salary range for this position is ($100,000-$120,000). Actual salary will be based on a variety of factors including relevant experience, knowledge, skills and other factors permitted by law. A range of medical, dental, vision, retirement, paid time off, bonus and/or other benefits are available.