Business Integration Developer II

• 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 (Go Anywhere/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.

• 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 (Go Anywhere/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.

• 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 (Go Anywhere/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.

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;…