Data Integration Specialist

Role Overview

We are seeking an experienced Integration Analyst to design, develop, and maintain integrations between multiple business systems. The ideal candidate will have strong expertise in SQL, ETL processes, Data Warehousing, API integrations, and hands-on experience working with OpenAPI specifications. An AWS certification is required, with proven ability to build scalable, secure, and reliable data integration solutions in cloud environments.

This role involves collaborating with developers, data engineers, and business stakeholders to ensure seamless data flow across platforms and support data-driven decision-making.

Key Responsibilities • Design, develop, and maintain system integrations using APIs and ETL tools • Build and optimize SQL queries for data extraction, transformation, and loading • Develop and manage ETL pipelines to ensure accurate and timely data movement • Work with data warehouse architectures to ensure data integrity and performance • Implement and maintain RESTful APIs using OpenAPI specifications • Integrate cloud-based systems and services within AWS environments • Troubleshoot integration issues and perform root cause analysis • Ensure data security, governance, and compliance standards are met • Collaborate with cross-functional teams including developers, analysts, and business stakeholders • Document technical specifications, integration processes, and system workflows • Continuously improve integration performance and scalability

Minimum Requirements • Bachelor’s Degree in Computer Science, Information Systems, Engineering, or related field • Minimum 6 years’ experience in system integration, data engineering, or similar role • Strong experience with SQL for complex data manipulation • Proven experience designing and maintaining ETL processes • Solid understanding of Data Warehousing concepts (star schema, snowflake schema, dimensional modelling) • Hands-on experience integrating systems using REST APIs • Experience working with OpenAPI (Swagger) specifications • AWS Certification (e.g., AWS Certified Solutions Architect, AWS Certified Developer, AWS Certified Data Analytics) • Experience working with cloud-based data solutions • Strong analytical and problem-solving skills

Preferred Skills • Experience with ETL tools such as Talend, Informatica, SSIS, or similar • Knowledge of scripting languages (Python, Bash, or similar) • Experience with JSON, XML, and data mapping techniques • Understanding of CI/CD pipelines for integration deployments • Familiarity with microservices architecture • Experience with version control tools such as Git • Knowledge of data governance and security best practices