Programmer Analyst / IT System Specialist - 5788

Advanced Systems Design is seeking a Programmer Analyst   for our client located in Montgomery, AL.

This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.

Job Overview :

We are seeking a technically skilled IT System Specialist with strong hands-on experience in SQL development, ERP systems, and application integrations. This is a technical analyst / developer role, not a project management position. The ideal candidate will be comfortable working directly with data, integrations, and application interfaces, and will be able to design, build, and troubleshoot SQL-based and file-based solutions.

Experience with Boomi and GoAnywhere is highly desirable but not required.

Must be able to demonstrate real, tangible technical skills in SQL and system integrations.

This position supports multiple enterprise platforms, including financial, purchasing, grant management, and HR / timekeeping systems, as well as the GoAnywhere file transfer platform.

This role is best suited for candidates who actively build and troubleshoot technical solutions. Applicants whose experience is primarily project management, coordination, or oversight without hands-on SQL or integration work will not be a match for this position.

Key Responsibilities

• Design, develop, and support SQL queries, SSIS packages, stored procedures, reports, and database structures to ensure data accuracy and high system performance.
• Analyze and troubleshoot data issues across ERP, integration, and reporting systems.
• Develop and support application integrations using platforms such as Boomi, GoAnywhere, APIs, and file-based transfers.
• Perform testing and debugging of integrations, web applications, and SQL scripts to ensure reliability and scalability.
• Create and maintain technical documentation, including interface designs, process flow diagrams, and configuration guides.
• Collaborate with business users to gather requirements and translate them into technical solutions — not just requirements documents.
• Manage and document work through ServiceNow or equivalent task-tracking systems, ensuring clear, auditable technical records of analysis and resolution.
• Provide knowledge sharing and system support to ensure effective use of implemented solutions.

Required Qualifications :

Preferred Qualifications :

Education Required :

Advanced Systems Design, Inc. is :

the pre-employment testing protocol :

background investigation

Our Employees :

Comprehensive Health Insurance with PPO and HDHP / HSA options

For additional information regarding Advanced Systems Design, please check out our WEBSITE    or click HERE for all current job openings.

Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.