[Hiring] Master Data & Integration Lead @Totara Learning Solutions

Role Description

We are looking for a hands-on Master Data & Integration Lead to own the integrity of shared commercial data across our systems.

You will:

• Define what constitutes an account, how records are matched, how parent-child account hierarchies are formed, which system is authoritative for each attribute, and how data is mapped and synchronised between systems.
• Implement these rules through Syncari and the connected systems, monitor whether they are working, and work with individual system owners to prevent defects from being created.

Success means that the same customer, account, and relationship is represented consistently, accurately, and explainably across HubSpot, Sage, product systems, and the reporting layer. This is a hands-on Master Data Management and integration role.

What you will own

Master data integrity

• Accountable for the integrity of shared commercial data across Totara's connected systems.
• Define the shared data model, terminology, and standards used across systems.
• Determine which system is authoritative for each entity and attribute.
• Define validation, standardisation, matching, deduplication, and conflict-resolution rules.
• Establish how trusted values survive when different systems contain conflicting information.
• Monitor data-quality failures and identify their underlying causes.
• Work with system owners to introduce controls that prevent defects at source.
• Make data ownership and decision-making clear enough that non-specialists can understand them.
• Ensure that downstream cleansing and manual reconciliation reduce over time.

Account identity, hierarchy and mapping

• Establish how Totara represents organisations and relationships between them.
• Define what Totara means by an account, customer, legal entity, logo, location, parent, and ultimate parent.
• Establish the rules used to determine whether records in different systems represent the same organisation.
• Design and maintain parent-child account hierarchy rules.
• Define how account identifiers and relationships map across HubSpot, Sage, product systems, acquired businesses, and the reporting layer.
• Establish matching, merging, and survivorship rules for duplicate or conflicting records.
• Determine how changes such as acquisitions, mergers, restructures, and account moves should be handled.
• Create a controlled approach to genuine exceptions without allowing a growing collection of undocumented, case-by-case rules.
• Ensure hierarchy and mapping decisions are traceable, testable, and consistently applied.

Syncari and integration ownership

• Own the day-to-day administration and development of Syncari and the rules governing how data flows between systems.
• Configure, test, publish, and monitor Syncari pipelines.
• Manage entity, object, and attribute mappings.
• Implement source-authority, transformation, validation, and conflict-handling rules.
• Design appropriate one-way and bidirectional data flows.
• Monitor synchronisation activity, exceptions, and platform health.
• Investigate failed transactions, mismatched records, authentication problems, schema changes, and API limitations.
• Reconcile data between source and destination systems and confirm that integrations have produced the intended result.
• Use native connectors and standard platform capability wherever practical.
• Challenge whether Syncari is required for a particular use case.

Source-system controls

• Agree on the cross-system data standards that each source must meet.
• Work with system owners to implement appropriate upstream controls.
• Identify where a source-system change is preferable to another downstream correction.
• Provide clear requirements covering fields, formats, identifiers, relationships, and behaviours that must remain stable.
• Escalate repeated upstream defects where they are creating avoidable downstream work.
• Help system owners understand how their changes affect the wider data flow.

Modelled data for reporting

• Own the modelled data layer supporting Power BI and other business reporting.
• Structure data so that reporting teams can build reliable measures and reports.
• Define stable relationships, keys, dimensions, and shared business definitions.
• Ensure reporting data can be reconciled to the appropriate operational source.
• Document the model and the logic applied to it.
• Work with report builders and business stakeholders to understand their data requirements.

Documentation and change control

• Document the systems, data flows, and operating rules.
• Create end-to-end system and data-flow diagrams.
• Maintain entity and attribute mappings.
• Document source-authority decisions.
• Record account hierarchy and matching rules.
• Document transformation and validation logic.
• List known constraints and approved exceptions.
• Outline testing, release, and rollback procedures.
• Define ownership and escalation routes.
• Assess the expected impact of proposed schema or system changes.

Qualifications

• Hands-on experience building and operating production data integrations using Syncari or a comparable Master Data Management or Integration Platform as a Service platform.
• Demonstrable ownership of customer, account, or other master data shared across multiple operational systems.
• Experience defining or implementing account matching, hierarchy, source-authority, deduplication, mapping, and conflict-resolution rules.
• Experience personally configuring mappings, transformations, validation, error handling, monitoring, and reconciliation.
• Experience integrating a major Customer Relationship Management platform with finance, product, or other operational systems.
• A strong understanding of data modelling and how operational data should be structured for reliable Business Intelligence reporting.
• The ability to investigate data problems methodically and distinguish their root cause from their visible downstream symptoms.
• Strong communication skills and the ability to align independent system owners.
• Evidence that you can simplify an existing system, not only build new capability.

Requirements

• Experience with Syncari.
• Experience with HubSpot as a connected Customer Relationship Management platform.
• Experience with Sage or another finance or Enterprise Resource Planning system.
• Experience with Power BI and semantic or dimensional data modelling.
• Experience with Structured Query Language.
• Experience with Application Programming Interfaces, webhooks, and authentication methods such as OAuth.
• Experience with custom connectors, scripting, or cloud-data platforms.
• Experience with product-usage or telemetry data.
• Experience with data onboarding following an acquisition.
• Experience with Lean or Six Sigma improvement methods.

Benefits

• Enhanced Parental Leave
• Private Healthcare
• Life Insurance 4x Salary
• Professional Development Opportunities
• Annual Wellbeing Allowance
• New Joiner home working set-up allowance
• Additional Paid Leave: Birthday off, Working days between Christmas and New Years Eve

Company Description

At Totara, we believe diverse perspectives make us stronger. We welcome applications from people of all backgrounds and experiences. If you're excited about this opportunity but don't meet every requirement, we'd still love to hear from you. We hire based on skills, leadership, potential, and the unique experiences people bring to our team.