Overview
Design, develop, test, and support business integration interfaces and database solutions. This role includes building SSIS-based and managed file transfer integrations, contributing to T-SQL development, and providing ongoing support through monitoring, ticket resolution, documentation updates, and a 24/7 on-call rotation for assigned interfaces.
Interface Development
- 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).
- Partner with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
- Thoroughly test work before releasing code to production by developing and executing test plans and scenarios, including data design, tool design, and data extract and transform.
- Participate in customer-facing integration development efforts under the guidance of senior developers.
T-SQL Development
- Understand database concepts and the implications of different database designs.
- Develop reusable database objects with guidance as needed, including tables, stored procedures, views, triggers, and indexes.
- Continuously review and improve performance of stored procedures and SQL queries.
- Participate in peer reviews of database and integration changes to help ensure consistent methodologies are followed.
Support and Operations
- Monitor interface processing environments, including summary reporting and alerting, for exception events and implement changes to prevent recurrence.
- Update and close assigned tasks or helpdesk tickets within Jira and maintain Business Integration documentation.
- Evaluate customer data issues and implement solutions to avoid recurrence; participate in a 24/7 on-call rotation for all assigned interfaces.
- Communicate with clients to identify needs and evaluate alternative business solutions with project management.
Qualifications & Requirements
Education and Experience
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or an equivalent combination of education and experience.
- 2 to 4 years of experience in interface and integration development, database development, or related technical support.
- Working knowledge of relational database design and data interface or 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: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job. While performing this role, the employee is frequently required to talk or hear. The employee regularly stands and walks, uses hands to finger, handle, or feel, and reaches with hands and arms. The employee regularly sits for long periods, and on occasion may need to climb or balance, or stoop or kneel. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
Work Environment: The noise level in the work environment and job sites is usually low, applicable to a business office. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
C-TPAT
Century is committed to the Customs Trade Partnership against Terrorism (C-TPAT) program and will take necessary steps to implement and enhance security throughout its global supply chain. All employees are required to immediately report any anomalies to the Century USA and Asia C-TPAT contacts.
Compensation
Salary: $70,000 to $80,000 per year.