Data Integration & API Mapping Specialist

Remote; San Francisco (CA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Career growth opportunities

Disability insurance

Job summary

Higher Logic is seeking a Data Integration Consultant to configure, maintain, and validate mappings that connect customer systems with Higher Logic applications. You will translate incoming JSON objects into target structures, apply transformations, and support onboarding and ongoing integrations for CRM, AMS, and partner systems.

You will serve as a subject matter expert for Higher Logic APIs, collaborate with Sales and Partnerships, and help optimize mapping accuracy and efficiency using

Qualifications

• Ability to understand structured data and JSON, including objects, properties, identifiers, relationships, and translate business requirements into mappings.
• Practical skill with data transformation, formulas, conditional logic, filters, and validation.
• Ability to investigate source data and destination results using query and inspection tools; working SQL and API testing knowledge.

Responsibilities

• Review source-system documentation, sample JSON payloads, and data to understand objects, properties, relationships, and limitations.
• Configure source-to-target mappings with transformations, formulas, and conditional logic for standard and custom objects.
• Apply mappings to onboarding, data conversion, and ongoing integrations across AMS, CRM, partner integrations, and Higher Logic apps.
• Run and validate mappings, compare source and destination results, and investigate missing or incorrect data.
• Maintain mappings as systems evolve, diagnose issues, and escalate defects with reproducible examples.
• Develop reusable mapping templates and validation checks to reduce repetitive work.

Skills

SQL & API testing

JSON data mapping

Data transformation

Problem solving

Documentation

Job description

Higher Logic is seeking a Data Integration Consultant to configure, maintain, and validate mappings that connect customer systems with Higher Logic applications. You will translate incoming JSON objects into target structures, apply transformations, and support onboarding and ongoing integrations for CRM, AMS, and partner systems.

You will serve as a subject matter expert for Higher Logic APIs, collaborate with Sales and Partnerships, and help optimize mapping accuracy and efficiency using