IT System Specialist - 2327

Advanced Systems Design is seeking an IT System Specialist 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 looking for an experienced IT System Analyst with a strong background in SQL, financial applications, interface design/support/development, and ERP application experience.
The ideal candidate will have hands-on experience with Boomi integration and the GoAnywhere platform, but it is not a requirement. Candidate should possess technical/interpersonal skills to effectively analyze, design, and implement IT solutions that support our business objectives.
This position will provide IT solutions for a variety of systems, including timekeeping and leave, financial and purchasing systems, grant management, and the GoAnywhere file administration platform.

Key Responsibilities:

• Analyze and develop technical solutions for timekeeping and leave, financial and purchasing systems, grant management, and file transfer administration platform systems.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
• Design, develop, optimize, and implement SQL queries, reports, stored procedures, and database structures to ensure data integrity, stable integrations, and efficient SQL performance.
• Support, Implement, and Maintain integration processes using Boomi, GoAnywhere, API, and file-based integration platforms, ensuring seamless data flow across applications and systems.
• Conduct system testing in web applications, integration platforms, or SQL clients for troubleshooting and debugging to resolve issues and ensure optimal performance.
• Prepare and maintain comprehensive technical documentation including system designs, technical specifications, script process designs, and user manuals.
• Provide knowledge transfer and support to colleagues / end-users to ensure effective system utilization.
• Manage workload and update tasks through ServiceNow / work management platforms.
• Key duties include updating the task management system with progress, assigning tasks to other users as applicable, and resolving issues with sufficient documentation to grow the knowledge base effectively.

Required Qualifications:

• 3-5 years of experience as an IT System Analyst or similar role.
• 3 years proficiency in SQL, with experience working with stored procedures, SSIS packages, and complex Data Manipulation commands (select, update, insert, delete) strong understanding of database design and development.
• Experience with ERP web-based applications and integration/file transfer platforms such as Boomi (1 year) and GoAnywhere (1 year).
• Strong analytical and problem-solving skills, with the ability to think critically and make data-driven decisions.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.
• Ability to manage multiple tasks and priorities in a fast-paced environment.

Preferred Qualifications:

• Familiarity with Boomi and GoAnywhere integration platforms and tools.
• Experience with enterprise resource planning (ERP) systems such as SAP or Oracle.
• Experience with agile methodologies and project management.
• Proficiency in programming languages such as Python, Java, or C# for scripting and automation purposes.
• Experience with data visualization tools such as Power BI or Tableau for creating insightful reports and dashboards.
• Certification in relevant technologies such as Microsoft SQL Server, Boomi Professional Developer, or AWS Solutions Architect.
• Experience in test automation platforms such as TestSavvy

Education Required:

• Bachelor’s Degree in Computer Science, Information Systems or other related field.
• Or equivalent work

Advanced Systems Design, Inc. is:

• A leading Information Technology provider for Federal, State & Local government agencies.
• A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.
• A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.
• A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988. 
• Applicants who have a signed offer of employment or contractor agreement are subject to:
  • the pre-employment testing protocol:
    • background investigation
    • drug screening

Our Employees:

• Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC, and a wide array of Federal, State, and Local agencies throughout the United States
• Are eligible for wide-ranging benefits and perks, including but not limited to:
  • 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
  • Tuition Assistance
  • Professional Certification Incentive Plan
  • Employee Referral Plan
  • Technology Exposure

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.

Salary : $80,273 - $88,536