Data Integration Consultant

Higher Logic, LLC; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Higher Logic, LLC seeks a Data Integration Consultant to configure, validate, and optimize mappings between customers’ systems and Higher Logic applications. You will translate JSON structures into target objects, apply transformations, and ensure data integrity across onboarding and ongoing integrations.

You will partner with Sales, Partnerships, and Engineering to assess new integration opportunities and provide expert mapping guidance.

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.
• Working proficiency with SQL and API testing sufficient to support data checks and technical diagnosis.
• Understanding of SaaS integrations, APIs, authentication, and data synchronization.
• 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.
• Ability to take direction, incorporate feedback, and use AI effectively while validating results.

Responsibilities

• Review source-system documentation and sample JSON payloads to understand objects and relationships.
• Configure source-to-target mappings, including one-to-one field mappings and transformations.
• Apply mappings to customer onboarding, data conversion, and ongoing integrations.
• Run and validate mappings, compare results, and investigate data issues.
• Maintain mappings as systems and requirements change; document findings.

Skills

JSON data structures

SQL

API testing

Data mapping

Problem solving

Communication

Tools

Cursor

Replit

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

KNOWLEDGE AND ABILITIES REQUIRED:

• Ability to understand structured data and JSON, including objects, properties, identifiers, relationships, and custom fields, and translate business requirements into accurate source-to-target mappings.
• 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. Able to maintain clear records, follow priorities, adapt to changes, and elevate issues early.
• 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.

EXPERIENCE DESIRED:

• Experience in data conversion, data migration, technical implementation, integration configuration, or a related role involving mapping, transformation, and validation of customer data.
• Experience with AMS (Association Management System) or CRM implementations is preferred. Experience with associations, or an understanding of their operations, member needs, and software ecosystems, is a plus.
• Experience maintaining customer-specific configurations and troubleshooting data issues across connected software systems. SaaS experience is preferred.
• Experience with scripting, software development, or reading code is helpful; independent development of production integrations is not required.
• Experience using AI-assisted tools such as Cursor and Replit is a plus. Familiarity with MCP, reusable AI skills, or tools for building internal reports and utilities is also helpful.

You’ll earn:

• Competitive compensation.
• 401(k) plan with employer match.
• Healthcare and dependent-care flexible spending account.
• Company short-term and long-term disability insurance.
• Company culture that recognizes its employees.
• Room for growth and development and management that cares about your professional growth and will help you achieve your goals.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Higher Logic’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.