Systems Integration Specialist — SQL, ETL & REST APIs

Owlsln; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

Owlsln is seeking a Systems Integration Specialist to support software implementations, data integration, and system synchronization projects for clients. You will translate business requirements into technical solutions and develop ETL processes to ensure reliable data workflows.

The role requires strong SQL, RESTful APIs, and XML/JSON skills, with independent work and cross-functional collaboration. Experience with Intapp Integration Builder or Dell Boomi is a plus.

Qualifications

• Requires solid understanding of relational databases and data modeling.
• Proficiency in SQL and RESTful API development.
• Familiarity with XML and JSON data structures.
• Strong problem-solving and documentation skills.
• Ability to work independently and with cross-functional teams.

Responsibilities

• Conduct data investigations and facilitate data mapping sessions.
• Design, develop, and test ETL processes for data migration and synchronization.
• Develop SQL queries and custom reports using SSRS.
• Integrate systems using RESTful APIs, XML, and JSON.
• Review infrastructure configurations and troubleshoot integration issues.
• Coordinate testing, data validation, and implementation activities.
• Collaborate with clients and project teams to ensure successful project delivery.

Skills

SQL

RESTful APIs

Data modeling

ETL

SSRS

Data mapping

XML

JSON

Documentation

Communication

Tools

Intapp Integration Builder

Dell Boomi

Groovy

Job description

Owlsln is seeking a Systems Integration Specialist to support software implementations, data integration, and system synchronization projects for clients. You will translate business requirements into technical solutions and develop ETL processes to ensure reliable data workflows.

The role requires strong SQL, RESTful APIs, and XML/JSON skills, with independent work and cross-functional collaboration. Experience with Intapp Integration Builder or Dell Boomi is a plus.