Data Integration Engineer II (SSIS, T-SQL)

Century Distribution Systems, Inc.; Glen Allen (VA); On-site; USD 70,000 - 95,000; Full time

Job summary

Century Distribution Systems, Inc. is seeking an experienced interface/integration developer to design, test, and maintain data interfaces. You will create SSIS packages and work with GoAnywhere/Cleo/Azure for business integrations, translating requirements into technical designs and collaborating with Analysts and business users.

The role emphasizes testing, documentation, and participation in customer-facing development under senior guidance, with on-call rotation for critical interfaces.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 2–4 years of experience in interface/integration development or related technical support.
• Working knowledge of relational database design and data interface/integration concepts.
• Proficiency in T-SQL and SSIS development; familiarity with GoAnywhere/Cleo/Azure.

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 with test plans and scenarios, including data design and data extraction/transform.
• Participate in customer-facing development work for integrations under senior guidance.
• Monitor interface processing environments, including alerting and reporting; respond to exceptions.

Skills

T-SQL

SSIS

GoAnywhere/Cleo

Azure

Technical translation

Analytical skills

Communication

Problem solving

Education

Bachelor's degree or equivalent

Tools

SSIS

GoAnywhere

Cleo

Azure

Job description

Century Distribution Systems, Inc. is seeking an experienced interface/integration developer to design, test, and maintain data interfaces. You will create SSIS packages and work with GoAnywhere/Cleo/Azure for business integrations, translating requirements into technical designs and collaborating with Analysts and business users.

The role emphasizes testing, documentation, and participation in customer-facing development under senior guidance, with on-call rotation for critical interfaces.