Data Integration Specialist & API Expert

Higher Logic; Oregon; Hybrid; USD 90,000 - 120,000; Full time

Job summary

Higher Logic seeks a Data Integration Consultant to configure, validate, and optimize mappings between customers’ third-party systems and Higher Logic applications. You will translate JSON objects, apply transformations, and ensure data moves accurately across AMS, CRM, and partner integrations.

You’ll work with Sales, Partnerships, Product, and Engineering, helping on onboarding and data migration while maintaining mappings and documentation.

Qualifications

• Ability to understand structured data and JSON, including objects, properties, identifiers, relationships, and custom fields.
• Practical skill with data transformation, formulas, conditional logic, filters, and validation.
• Able to learn a mapping interface and independently configure and troubleshoot mappings within established practices.
• Ability to investigate source data and destination results using appropriate query and inspection tools.
• Working proficiency with SQL and API testing sufficient to support data checks and technical diagnosis.
• Understanding of SaaS integrations, APIs, authentication, and data synchronization sufficient to recognize limitations, diagnose issues, and explain needed enhancements to Engineering.
• Strong attention to detail, organization, and follow-through across multiple customer configurations.
• Clear written and verbal communication with technical and nontechnical colleagues, customers, and vendors.
• Able to explain mapping decisions, evidence, and unresolved questions.
• Ability to take direction, incorporate feedback, and use AI effectively while validating results and following company requirements for sensitive data and system access.

Responsibilities

• Review source-system documentation, sample JSON payloads, and available data to understand objects, properties, identifiers, relationships, customizations, and limitations.
• Clarify technical requirements with the project lead and relevant teams.
• Configure source-to-target mappings through the integration platform, including one-to-one field mappings, transformations, formulas, conditional logic, filters, and literal values.
• Support standard and custom objects in both source and destination systems.
• Apply mappings to customer onboarding, data conversion, and ongoing integrations, including AMS, CRM systems, partner integrations, and Higher Logic applications.
• Run and validate mappings using agreed access and review practices.
• Compare source and destination results, check record counts and field values, verify relationships and use-case outcomes, and investigate missing, duplicate, rejected, or incorrectly transformed data.
• Maintain mappings as customers add or change systems, fields, custom objects, or business rules.
• Diagnose mapping and configuration issues, document findings, and lift connector or platform defects with reproducible examples.
• Identify capabilities needed to support a new third-party system or use case.
• Specify platform, API, or authentication enhancements for Product and Engineering, explain expected behavior, and validate delivered changes.
• Maintain mapping specifications, configuration records, test evidence, supported-use-case guidance, known limitations, and troubleshooting procedures.
• Develop reusable mapping templates and validation checks that reduce repeated work.
• Enable Integration Services, onboarding, and support teams to perform routine configuration and validation through documentation and training.
• Provide technical escalation support for complex mappings and exceptions.
• Partner with customer implementation and support teams to provide integration documentation, enablement, guidance and when needed, direct customer support.
• Provide the Project Manager with technical progress, findings, effort estimates, dependencies, and risks.
• Join customer or vendor discussions when technical clarification is needed and communicate clearly through email and live meetings.
• Use approved AI tools to improve mapping, analysis, validation, and documentation.
• Help maintain reusable AI skills and support agent-assisted, MCP-enabled, and UI self-service workflows as these capabilities become available; verify outputs and results.
• Recommend requirements for interfaces, reports, and utilities that improve mapping oversight and exception handling. Where appropriate, prototype them using approved AI-assisted tools and agreed review practices.
• Conducts all business in accordance with Higher Logic policies and procedures.
• Performs all other duties as assigned.

Skills

Structured data & JSON

Data transformation

Mapping interface

SQL

APIs & authentication

Data synchronization

Attention to detail

Clear communication

AI-assisted tooling

Problem solving

Tools

SQL

API testing

AMS/CRM integrations

Job description

Higher Logic seeks a Data Integration Consultant to configure, validate, and optimize mappings between customers’ third-party systems and Higher Logic applications. You will translate JSON objects, apply transformations, and ensure data moves accurately across AMS, CRM, and partner integrations.

You’ll work with Sales, Partnerships, Product, and Engineering, helping on onboarding and data migration while maintaining mappings and documentation.