Business Integration Developer II

Century Distribution Systems•Glen Allen, VA

10h•Onsite

About The Position

This role focuses on developing, testing, documenting, and maintaining data interfaces. The Business Integration Developer II will create and modify SSIS packages and processes within managed file transfer systems and business integration applications. They will collaborate with analysts and business users to translate functional specifications into technical designs, thoroughly test all work before production release, and begin participating in customer-facing development for integrations under senior guidance. The position also involves T-SQL development, including understanding database concepts, creating reusable database objects, and optimizing stored procedures and SQL queries. Additionally, the role requires monitoring interface processing environments, managing helpdesk tickets, evaluating and resolving customer data issues, and participating in a 24/7 on-call rotation. Effective communication with clients to identify needs and evaluate solutions is also a key aspect of this role.

Requirements

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

Responsibilities

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