Data Integration Support Engineer

We are seeking a Data Integration Support Engineer to support and develop integrations across our Enterprise Systems. This role will focus on learning how the business operates, understanding how enterprise applications and data support business processes, and assisting with the development, monitoring, troubleshooting, and documentation of integrations.

The individual will work closely with the Senior Data Integration Engineer and other Enterprise Applications team members to support solutions using technologies such as Boomi, Azure Data Factory, SSIS, APIs, SQL, and reporting platforms. As experience grows, the individual will take increasing ownership of integrations, troubleshooting, and technical solutions.

SQL proficiency is required.

Responsibilities:

• Support the design, development, testing, implementation, and maintenance of real-time, batch, file-based, API, and ETL integrations across enterprise applications and Azure services.
• Partner with the Senior Data Integration Engineer to deliver integration and data-engineering solutions using Boomi, Azure Data Factory, SSIS, SQL, APIs, and related technologies.
• Analyze business and data requirements, understand end-to-end system dependencies, and translate requirements into reliable technical integration solutions.
• Create and maintain process flows, data mappings, data-flow diagrams, technical specifications, solution documentation, and production-support procedures.
• Use SQL and integration monitoring tools to validate, reconcile, troubleshoot, and improve data flows across enterprise and Azure-hosted systems.
• Monitor production integrations and applications, investigate failures and recurring issues, perform root-cause analysis, and drive issues through resolution or appropriate escalation.
• Collaborate with application owners, infrastructure and Azure teams, business stakeholders, and vendors to deliver integration requirements and support business operations.
• Follow Agile, SDLC, change-control, testing, and deployment practices while managing multiple priorities in a fast-paced Enterprise Applications environment.
• Support new initiatives and application changes by assessing integration impacts, technical dependencies, data requirements, monitoring needs, and production-readiness considerations.
• Take increasing ownership of integration solutions and technical support, proactively identifying opportunities to improve reliability, scalability, operational efficiency, and documentation as business and technical knowledge develops.

Qualifications

• Proficiency in ETL and real-time integration with at least one ESB platform (Boomi, SSIS, Azure Integration Services).
• Hands-on experience with ADF, Azure and SQL.
• Ability to work independently and in multiple capacities within a small, fast-paced team.
• Strong troubleshooting and problem-solving skills.
• Excellent verbal and written communication skills.
• Highly self-motivated with strong organizational and time management abilities.