Advanced Systems Design · 1 month ago
Programmer Analyst/IT System Specialist - 5788
Montgomery, AL
Full-time
Onsite
Mid Level
3+ years expAdvanced Systems Design is seeking a Programmer Analyst for our client located in Montgomery, AL. This role requires a technically skilled IT System Specialist to design, build, and troubleshoot SQL-based and file-based solutions while supporting multiple enterprise platforms.
Information TechnologyManagement ConsultingService Industry
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
Qualification
Required
3–5 years of hands-on experience as a System Analyst, Integration Specialist, or SQL Developer
Proven proficiency with SQL (queries, stored procedures, joins, functions, DML/DDL commands) and understanding of database design principles
Experience supporting or integrating with ERP systems (e.g., SAP, Oracle, UKG, STAARS, Ivalua, or similar)
Strong analytical and problem-solving abilities with demonstrable experience in troubleshooting technical issues
Ability to communicate technical concepts clearly to non-technical users
Experience managing workload and documentation in ServiceNow or similar ticketing platforms
Bachelor's degree in Computer Science, Information Technology, or a related technical field
Preferred
Hands-on experience with Boomi, GoAnywhere, API-based integrations, or ETL tools
Working knowledge of integration or file transfer platforms such as Boomi and GoAnywhere
Familiarity with enterprise ERP systems (e.g., SAP, Oracle, UKG, Ivalua)
Experience developing scripts in Python, Java, or C# for automation and system support
Exposure to data visualization or reporting tools such as Power BI or Tableau
Certifications in SQL Server, Boomi, or cloud technologies (AWS/Azure)
Experience with test automation or regression testing platforms such as TestSavvy
Benefits
Comprehensive Health Insurance with PPO and HDHP/HSA options
Dental Insurance
Vision Insurance
Short/Long-Term Disability
Group Life Insurance - Company Paid
Voluntary Life Insurance
401(k) Plan with Employer Match
Paid Time Off (Vacation/Sick)
Holiday Pay - Company Paid Federal Holidays
Professional Certification Incentive Plan
Employee Referral Plan
Technology Exposure
Company
Advanced Systems Design
Over the years, ASD has grown into one of the Southeast's premier providers of web solution, application development, management consulting, IT consulting, networking/collaboration, and IT staffing services to the government sector.
51-200 employees
H1B Sponsorship
Advanced Systems Design has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
$1.32M2010-08-17Series Unknown· $0.55M
2009-06-09Series Unknown· $0.78M
Company data provided by crunchbase