Data Integration Consultant

higherlogic; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Higher Logic is seeking a Data Integration Consultant to configure, maintain, and validate mappings that connect customers' third-party systems with Higher Logic applications. You will translate incoming JSON objects into target objects, applying transformations, formulas, and conditional logic to meet diverse use cases.

You will collaborate with Sales, Partnerships, Product, and Engineering to ensure accurate data movement, on-boarding new customers, and supporting existing integrations as

Qualifications

• Experience configuring, mapping, and validating data across systems.
• Ability to translate source data into target objects with transformations.

Responsibilities

• Review source-system documentation, sample JSON payloads, and available data to understand objects, properties, identifiers, relationships, customizations, and limitations.
• Configure source-to-target mappings through the integration platform, including one-to-one field mappings, transformations, formulas, conditional logic, filters, and literal values.
• Apply mappings to customer onboarding, data conversion, and ongoing integrations, including AMS, CRM, and partner integrations.
• Run and validate mappings, compare source and destination results, verify relationships, and investigate data discrepancies.
• Maintain mappings as customers change systems, fields, or business rules; document findings and raise platform defects with reproducible examples.
• Identify capabilities needed for new third-party systems and propose API/auth enhancements with Product/Engineering and validate changes.
• Maintain mapping specifications, configuration records, test evidence, and troubleshooting guidance; create reusable templates.
• Enable teams to perform routine configuration and validation through documentation and training; provide technical escalation for complex mappings.

Skills

JSON payloads

APIs

Data mapping

Data validation

Stakeholder communication

Tools

Integration platform

Job description

Higher Logic exists to connect people, knowledge, and ideas to improve lives and organizations. Through our community solutions, we empower growth‑stage businesses and associations to build a more engaged and meaningful relationship with their customers and members. Higher Logic serves more than 3,000 customers, representing over 350,000 online communities with greater than 200 million users in more than 42 countries worldwide.

Our team is a thriving community of authentic people with diverse experiences and perspectives. We are honest and genuine and believe that sharing ideas and feedback openly helps us to be successful. We believe that diversity and empathy bring us #AllTogether to make us stronger. We learn from failure and successes because both help us to grow and learn. We strive to understand the why behind our actions and bring our best selves to work every day.

The Data Integration Consultant configures, maintains, and validates the data mappings that connect customers' third‑party systems with Higher Logic applications. Working within Product, this role uses the integration platform's mapping interface to translate incoming JSON objects and properties into target objects and properties, including custom objects and fields. The consultant applies transformations, formulas, conditional logic, filters, and literal values to meet customer use cases. This role supports Higher Logic's existing integration infrastructure and serves as a point of contact for the Sales and Partnerships team by assessing potentional integration partners. There is potential to uplevel to Senior level, depending on experience.

This is an ongoing technical implementation role supporting new customer onboarding and existing customers as their systems, data models, and requirements change. The consultant understands how data should move, configures the mapping, runs it through agreed processes, and verifies the results. The consultant also serves as the subject matter expert for Higher Logic's APIs. This role reports directly to the VP, Product Management, and will work closely with the Project Manager, who owns prioritization, scheduling, delivery coordination, and most client and vendor interactions; Engineering owns the production connector and platform development.

ESSENTIAL DUTIES AND RESPONSIBILITES:

• 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 association management systems (AMS), customer relationship management (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 up to 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 exce