Data Integration Specialist - SQL - Data Migration/Integration - SSIS - Java - Contract

Data Integration Specialist - SQL - Data Migration/Integration - SSIS - Java - Contract

Posted 1 day ago by Nexere Consulting Limited

£500 Per day
Inside
Undetermined
Hertfordshire/London, UK

Summary: The Integration Technical Specialist role is a contract position focused on leading integration initiatives for both internal and external systems. The specialist will ensure effective data and transaction flows, managing documentation, testing, and alignment with business needs. This position requires strong technical skills in data migration and integration tools, as well as the ability to collaborate with various stakeholders. The role is critical for the successful delivery of integration projects within the organization.

Key Responsibilities:

  • Build strong working relationships with stakeholders across the business to understand integration needs and opportunities.
  • Experience in building systems integrations, moving data from one place to another, including ERP systems, CRM, website, E-commerce, e-invoicing, and vendors.
  • Experience in flat file transferring, data extraction, and understanding the architecture while being able to code the solution.
  • Develop and maintain integration solutions using tools such as SSIS, SQL, and Zapysis, working with flat files, APIs, and database connection managers.
  • Utilize programming languages and data formats such as Java, JavaScript, ESQL, XML, XSLT, REST, SOAP, and JSON to support integration development.
  • Apply knowledge of EDI standards to engage with external partners and customers, identifying and developing integration opportunities.
  • Write and optimize SQL queries for data manipulation and use within SSIS packages or standalone data processes.
  • Review and suggest improvements to database structures, including tables, views, triggers, and stored procedures.
  • Use tools like SQL Server Management Studio to implement job scheduling, data integrity checks, and system alerts.
  • Design robust data flows between systems with appropriate validation and error handling.
  • Support comprehensive end-to-end testing for all integration-related business processes and project workflows.

Key Skills:

  • Experience with integration tools such as SSIS and SQL.
  • Proficiency in programming languages including Java and JavaScript.
  • Knowledge of data formats like XML, JSON, and EDI standards.
  • Strong SQL skills for data manipulation and optimization.
  • Ability to design and implement data flows and integration solutions.
  • Experience with APIs and third-party integrations.
  • Strong problem-solving and analytical skills.
  • Excellent communication and stakeholder management abilities.

Salary (Rate): £500 per day

City: London

Country: UK

Working Arrangements: undetermined

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Integration Technical Specialist - SQL - Data Migration/Integration - SSIS - Java - Contract

Role Overview

We are seeking an experienced Integrations Technical Specialist on a contract basis to act as a key technical lead for integration-related initiatives. This role is essential to the successful delivery and support of both internal and external system integrations, ensuring all data and transaction flows are fully managed, documented, tested, and aligned with business and project needs.

Key Responsibilities

  • Build strong working relationships with stakeholders across the business to understand integration needs and opportunities.

  • They are looking for an integration specialist, someone that has experience of building systems integrations, moving data from one place to another as they have an ERP system, CRM, website, E-commerce, einvoicing and vendors where data needs to be moved.

  • So experience of flat file transferring, data extraction, data out of one system then into another, understanding the architecture but must be able to code the solution.

  • Develop and maintain integration solutions using tools such as SSIS, SQL, and Zapysis, working with flat files, APIs, and database connection managers.

  • Utilize programming languages and data formats such as Java, JavaScript, ESQL, XML, XSLT, REST, SOAP, and JSON to support integration development.

  • Apply knowledge of EDI standards to engage with external partners and customers, identifying and developing integration opportunities.

  • Write and optimize SQL queries for data manipulation and use within SSIS packages or standalone data processes.

  • Review and suggest improvements to database structures, including tables, views, triggers, and stored procedures.

  • Use tools like SQL Server Management Studio to implement job scheduling, data integrity checks, and system alerts.

  • Design robust data flows between systems with appropriate validation and error handling.

  • Support comprehensive end-to-end testing for all integration-related business processes and project workflows.

Sample Projects

  • Develop integrations between core internal systems and third-party logistics providers.

  • Enhance and expand current integrations with Amazon using APIs and custom interfaces.

  • Design and build integrations across internal ERP, eCommerce, and customer-facing systems.