Job Summary:You will be responsible for designing, developing, deploying, and supporting robust enterprise integration solutions that connect internal and external systems across cloud, on-premises, and B2B environments. This individual works closely with business analysts, project managers, and cross-functional teams. Their responsibilities include translating business requirements into technical solutions, ensuring timely, accurate, and high-quality delivery. This position supports ongoing operations by monitoring integration performance, troubleshooting issues across integration platforms and SQL environments, and serving as a backup resource for production support and incident resolution.
Key Deliverables and Responsibilities:- Design, develop, and support complex enterprise integrations using Boomi (iPaaS) within hybrid on-premise and Microsoft Azure cloud environments.
- Develop and maintain data integration workflows leveraging Microsoft SQL Server and Transact-SQL, including stored procedures, data transformations, and performance optimization for high-volume transactional systems.
- Build, configure, and support Microsoft Azure integration services, including Azure Logic Apps, Integration Accounts, and API-driven workflows for B2B and application integrations.
- Design and implement EDI integrations, including mapping, trading partner onboarding, document validation, and secure data exchange.
- Develop and enhance integration components using C# / .NET technologies, including custom services, APIs, and middleware components supporting integration flows.
- Collaborate with business analysts and stakeholders to translate functional requirements into scalable integration and data solutions.
- Perform advanced data analysis and troubleshooting across SQL Server, Boomi, and Azure platforms, ensuring data accuracy, integrity, and system performance.
- Optimize integration performance through efficient SQL query design, indexing strategies, and data flow optimization.
- Participate in solution architecture design sessions, ensuring alignment with enterprise integration and cloud strategies.
- Conduct code reviews and enforce standards for integration design, SQL development, and application code quality.
- Develop and maintain technical documentation, including integration architecture diagrams, data flow mapping, and deployment procedures.
- Provide Level 2 support and participate in incident resolution for integration, database, and EDI-related issues.
Requirements- Bachelor's degree in computer science or a similar field
- 4 - 6 years of experience with Boomi (iPaaS) or a similar B2B or B2C systems integration platform.
- 4 - 6 years of software development experience in business and information systems utilizing Visual Studio C# / .NET, and other modern web technologies.
- 2+ years of experience designing public and private enterprise secure services using RAML and REST-based APIs.
- Proven experience implementing and supporting Microsoft Azure integration services, specifically Azure Logic Apps and Integration Accounts.
- Strong expertise in Microsoft SQL Server and Transact-SQL, including data modeling, query performance tuning, and troubleshooting complex data issues.
- Proven experience implementing and supporting Microsoft Azure integration services, specifically with Azure Logic Apps Accounts.
- Deep understanding of EDI concepts and standards, including X12/EDIFACT formats, mapping, validation, and partner integrations.
- Experience working with:
- Web services (REST/SOAP)
- XML, JSON, XSLT transformations
- Secure file transfer protocols (FTP/SFTP/AS2)
- Strong analytical and problem-solving skills with the ability to troubleshoot across integration platforms, SQL databases, and cloud services.
- Ability to work effectively in a cross-functional team environment, partnering with technical and business stakeholders.
- Strong written and verbal communication skills with the ability to clearly articulate complex technical concepts.
- Demonstrated ability to drive continuous improvement in integration architecture, data quality, and system performance.
Benefits- 3 weeks of PTO with a generous accrual policy
- Employee Assistance Program (EAP)
- Observe 14 annual Holidays.
- Nationwide Medical, Dental, Vision, & FSA
- Flexible Work Life Balance
- Optional Additional Life Insurance
- Short- & Long-Term Disability
- Progressive Associate Recognition Program
- Annual social and community events
- Company Provided Professional development
- Company provided PC and office supplies
- Annual Education Assistance Program
- On-site Free Parking [Hybrid/ In-person]
- 401K with bi-weekly Safe Harbor contributions
Pay: $76,338.70 - $95,423.38
