Business Integration Developer II
About The Position
This role focuses on developing, testing, documenting, and maintaining data interfaces. The developer will create and modify SSIS packages and processes within managed file transfer systems and business integration applications. Key responsibilities include translating functional specifications into technical designs, thorough testing of all work before production release, and beginning customer-facing development work under guidance. The role also involves T-SQL development, including creating and optimizing database objects, and participating in peer reviews. Support functions include 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 crucial part of the 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
