Systems Integration Specialist (SQL | ETL | REST APIs | Data Integration)

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

We're looking for a skilled Systems Integration Specialist to support software implementations, data integration, and system synchronization projects. The role involves working closely with clients, consultants, and project managers to translate business requirements into effective technical solutions, ensuring seamless implementation and reliable data workflows.

Key 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.

Required Qualifications:

• Strong understanding of relational databases and data modeling.
• Proficiency in SQL query development and RESTful APIs.
• Familiarity with XML and JSON data structures.
• Excellent problem-solving, communication, and documentation skills.
• Ability to work independently and collaborate effectively with cross-functional teams.

Preferred Qualifications:

• Experience with Intapp applications, particularly Intapp Integration Builder.
• Certification or practical experience with Dell Boomi.
• Knowledge of networking fundamentals and legal industry software.
• Familiarity with Groovy programming.