Business Integration Developer II

Century Distribution Systems, Inc; Glen Allen (VA); On-site; USD 80,000 - 110,000; Full time

Job summary

Century Distribution Systems, Inc. is seeking an Interface/ETL Developer to design, implement, and support data interfaces for inbound and outbound processes.

The role involves building SSIS packages and handling GoAnywhere/Cleo and Azure-based integration tools. You will translate business requirements into technical designs, run comprehensive tests, and collaborate with analysts and users to ensure reliable data movement and processing.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field; or equivalent combination of education and experience.
• 2-4 years of experience in interface/integration development, database development, or related technical support.
• Working knowledge of relational database design and data interface/integration concepts.

Responsibilities

• Develop, test, document, and maintain inbound and outbound data interfaces.
• Create and modify SSIS packages and processes in the Managed File Transfer system (GoAnywhere/Cleo) and business integration applications (Cleo Clarify/Azure).
• Translate functional specifications into technical designs for implementation and deployment.
• Test all work before release by developing and executing test plans and scenarios, including data design, tool design, and data extract/transform.
• Participate in customer-facing development work for integrations under guidance from senior developers.

Job description

Description

ESSENTIAL FUNCTIONS AND DUTIES:

INTERFACE DEVELOPMENT

• Develop, test, document, and maintain inbound and outbound data interfaces.
• Create and modify SSIS (SQL Server Integration Services) packages and processes in the Managed File Transfer system (GoAnywhere/Cleo) and business integration applications (Cleo Clarify/Azure).
• Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
• Thoroughly test all work before releasing code to production by developing and executing test plans and scenarios, including data design, tool design, and data extract/transform.
• Begin participating in customer-facing development work for integrations under guidance from senior developers.

T-SQL DEVELOPMENT

• Understand database concepts as well as the implications of different database designs.
• Develop well-designed reusable database objects with guidance as needed, including tables, stored procedures, views, triggers, and indexes.
• Continually review and improve performance of stored procedures and SQL queries.
• Participate in peer reviews of database and integration changes to ensure consistent methodologies are followed.

SUPPORT

• Monitor interface processing environments, including summary reporting/alerting, for exception events and implement changes to avoid recurrence.
• Responsible for updating and closing assigned tasks/helpdesk tickets within Jira and maintaining Business Integration documentation.
• Evaluate customer data issues and implement solutions to avoid recurrence; participate in 24/7 on-call rotation for all assigned interfaces.
• Communicate effectively with clients to identify needs and evaluate alternative business solutions with project management.

Requirements

QUALIFICATIONS & REQUIREMENTS

Education & Experience

• Bachelor's degree in Computer Science, Information Systems, or a related field; or equivalent combination of education and experience.
• 2-4 years of experience in interface/integration development, database development, or related technical support.
• Working knowledge of relational database design and data interface/integration concepts.

Required Skills

• Proficiency in T-SQL, including tables, stored procedures, views, triggers, and indexes.
• Working knowledge of SSIS package development and Managed File Transfer or business integration platforms (GoAnywhere/Cleo, Azure).
• Ability to translate functional specifications into sound technical designs.
• Strong analytical and troubleshooting skills for interface and data issues.
• Effective communication skills for both technical and customer-facing interactions.

ESSENTIAL PHYSICAL REQUIREMENTS AND WORK ENVIRONMENT

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• While performing the duties of this job, the employee is frequently required to talk or hear. The employee regularly is required to stand; walk; use hands to finger, handle, or feel; and reach with hands and arms.
• The employee is regularly required to sit for long periods of time; on occasion may need to climb or balance; and stoop, or kneel. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision; distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• The noise level in the work environment and job sites is usually low, applicable to a business office.

C-TPAT

Century is committed to the Customs Trade Partnership against Terrorism (C-TPAT) program. Century will take all the necessary steps to implement and enhance security throughout our global supply chain. All employees are required to immediately report any anomalies to the Century USA and Asia C-TPAT contacts.

The above is a description of the current essential functions and duties and responsibilities of your position. This document in no way states or implies that these are the only duties to be performed by the employee occupying this position. At the Company’s discretion, these essential functions, duties and responsibilities may be modified in the future to meet the business needs of the Company.

This document does not create an employment contract, implied or otherwise, other than an “at will” employment relationship.

PM22