Systems Integration Specialist

InOutsource; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

InOutsource is seeking a Systems Integration Specialist to lead data mapping, ETL development, and systems integration for Compliance and DealCloud implementations. The role involves translating requirements into best-practice solutions, guiding engagements from data investigation through go-live and post-deployment support.

Ideal candidates will demonstrate depth in data modeling, SQL, and SSRS, with hands-on experience in Intapp Integrate or Dell Boomi.

Qualifications

• Strong SQL and data modeling skills.
• Experience with ETL development for large data loads.
• Familiarity with Intapp Integrate or similar integration tools.

Responsibilities

• Lead data investigation to assess current systems and risks.
• Perform data mapping sessions aligning source and target models.
• Design, develop, and test ETL processes for bulk data loads.
• Build data synchronization routines for post-deployment reliability.
• Review infrastructure configurations to optimize implementations.
• Develop custom reports using SSRS to surface key insights.
• Oversee testing cycles including data validation and integration tests.

Skills

SQL

RESTful API

Data mapping

ETL development

Data modeling

XML/JSON

SSRS reporting

Tools

Intapp Integrate

Dell Boomi

SSRS

Job description

About InOutsource

InOutsource is a recognized industry leader in information governance and new business intake consulting for large law firms. We partner with clients to deliver technical implementation services, modernize business processes, and support the successful adoption of key technologies across the legal sector. Our team members are innovative, passionate, and collaborative, and we are growing!

About the Role

The Systems Integration Specialist plays a central role in the successful delivery of InOutsource’s Compliance and DealCloud implementations. Sitting at the intersection of technology and client strategy, this person serves as one of the primary technical experts on project teams, working hand-in-hand with business consultants and project managers to help law firms and professional services organizations modernize their risk management and client intake workflows.

This role demands both technical depth and client-facing acuity. The specialist translates complex client requirements into elegant, best-practice solutions, guiding engagements from initial data investigation through go-live and into post-deployment support. Day-to-day work spans data mapping and ETL development, systems integration, infrastructure review, and custom reporting, all executed within a structured methodology refined across hundreds of successful client engagements. Experience with Intapp applications and/or Dell Boomi is especially valuable in this role. This is a fully remote position open to candidates anywhere in the United States.

Key Responsibilities and Duties

• Lead data investigation efforts to assess the current state of client systems, surfacing risks and opportunities before implementation begins.
• Facilitate and participate in client data mapping sessions, ensuring alignment between source systems and target data models.
• Design, develop, and test efficient, well-documented ETL processes for bulk data loads, with attention to accuracy, performance, and long-term maintainability.
• Build and validate ongoing data synchronization routines that keep client environments current and reliable post-deployment.
• Review and advise on on-premises and cloud infrastructure configurations in support of technical implementations, recommending optimizations where appropriate.
• Develop custom reports using SQL Server Reporting Services (SSRS), enabling clients to surface the data insights most critical to their workflows.
• Oversee and guide testing cycles, including data validation, integration testing, and remediation, driving toward confident, clean go-lives.
• Participate in vendor-led professional development sessions to stay current on Intapp product developments and roadmap updates.
• Contribute actively to client project and status meetings, clearly communicating technical progress, blockers, and next steps.
• Coordinate with InOutsource project managers and fellow team members to ensure seamless delivery across workstreams.
• Contribute to the ongoing refinement of InOutsource’s repeatable, templated project methodologies, improving the tools and processes the full team depends on.
• Support business development activities by providing technical input on scoping, solution design, and effort estimation for prospective engagements.

Required Qualifications

• Solid understanding of law firm practices and the information technology ecosystems common in legal and professional services environments.
• Proven ability to work independently, make sound decisions under ambiguity, and maintain a solution-oriented mindset through complex challenges.
• Strong verbal and written communication skills, with the ability to articulate technical concepts to non-technical stakeholders.
• Working knowledge of relational database design principles and data modeling.
• Proficiency in SQL query development and RESTful API usage.
• Familiarity with constructing and navigating XML and JSON data structures.

Preferred Qualifications

• Hands-on experience with Intapp Integration Builder (Integrate) or other components of the Intapp product suite.
• Certification in, or practical experience with the Dell Boomi integration platform.
• Familiarity with computer networking fundamentals and how network topology impacts integration design.
• Exposure to legal industry software beyond Intapp (e.g., matter management, time and billing, document management systems).
• Familiarity with Groovy programming language

InOutsource is an Equal Employment Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, gender identity, sexual orientation, national origin, age, disability, protected veteran status, and any other characteristic protected by applicable federal, state, or local laws. We are dedicated to fostering an inclusive environment where employees feel safe, supported, and able to bring their whole selves to work.