Alabama Draft - KS

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:

Our client is seeking a technically focused IT System Specialist to support the development and ongoing operation of enterprise system integrations.

This role focuses on backend integration development and support, including:

  • Dell Boomi interface development and support

  • REST / SOAP API integrations

  • SQL Server 2019 / 2022 development (queries, stored procedures, and data transformation)

  • Automated data exchanges

  • Develop and maintain file-based integrations using the GoAnywhere MFT platform, including automated file generation, SFTP transfers, job scheduling, and monitoring.

This role centers on building, supporting, and troubleshooting system integrations and data workflows that support statewide financial, HR, and administrative systems.

The ideal candidate enjoys working directly with system interfaces, automation processes, and enterprise data integrations.

Key Responsibilities:

  •  Build, troubleshoot, and maintain Dell Boomi integration processes, connectors, and data mappings.

  •  Design, develop, and support API-based integrations between enterprise systems.

  •  Develop and maintain file-based integrations using GoAnywhere MFT, including:

• automated file exchanges
• secure data transmission workflows
• scheduling and monitoring integration jobs
• troubleshooting failed transfers and data processing issues

  •  Develop SQL Server solutions including:

• stored procedures
• query development
• data validation and transformation logic
• performance optimization

• Develop and support SSIS packages used for batch data movement and transformation.

• Monitor automated integrations and resolve production support issues across API and file-based interfaces.

• Diagnose integration failures, data discrepancies, and interface errors across enterprise applications.

• Document interface specifications, file layouts, data mappings, and operational procedures.

• Track development and support activities using ServiceNow or similar ticketing systems.

• Collaborate with functional teams to translate business requirements into implemented technical solutions.

This position primarily supports:

• Dell Boomi middleware interfaces
• REST / SOAP API integrations
• SQL Server queries and stored procedure development
• SSIS packages and data transformation processes
• GoAnywhere MFT workflows supporting secure file-based integrations

Required Qualifications:

• 3-5 years of hands-on experience in:

          o Boomi Integration Development

          o SOAP / REST API integration development

          o SQL Development

          o Middleware / Interface Technical Support

• Strong SQL Server experience including:

          o Complex queries

          o Stored procedures

          o Data transformation logic

          o Data manipulation (DML/DDL)

• Experience working with REST / SOAP APIs.
• Experience developing or supporting file-based integrations or secure file transfer processes.
• Demonstrated troubleshooting skills involving integrations, data workflows, or automated interfaces.
• Hands-on experience with Dell Boomi integration platform.
• Ability to communicate technical concepts clearly to business stakeholders.

Preferred Qualifications:

• Experience with GoAnywhere MFT or similar enterprise file transfer solutions.
• Experience supporting enterprise systems such as SAP, Oracle, Workday, or similar.
• Experience with integrating UKG products via Dell Boomi (Workforce Management, HR, Payroll)
• Experience building or supporting SSIS packages.
• Familiarity with authentication methods such as OAuth, certificates, or token-based security.
• Experience supporting production integration environments.
• Exposure to automation or scripting using PowerShell, Python, or similar tools.

Education Required:

• Bachelor’s degree in computer science or related technical field.

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 46-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
  • 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.