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.

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

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