About the Role
Totara is seeking a hands-on Master Data & Integration Lead to own the integrity of shared commercial data across its systems. This role involves defining and implementing rules for data consistency, accuracy, and explainability across platforms like HubSpot, Sage, and product systems, ensuring a trustworthy data foundation.
Responsibilities
- 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, standardization, 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.
- Establish how Totara represents organizations and relationships between them.
- Define what Totara means by an account, customer, legal entity, logo, location, parent, and ultimate parent.
- Establish rules for determining if records in different systems represent the same organization.
- Design and maintain parent-child account hierarchy rules.
- Define how account identifiers and relationships map across systems.
- 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.
- Ensure hierarchy and mapping decisions are traceable, testable, and consistently applied.
- Own the day-to-day administration and development of Syncari and data flow rules.
- 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 synchronization activity, exceptions, and platform health.
- Investigate failed transactions, mismatched records, authentication problems, schema changes, and API limitations.
- Reconcile data between source and destination systems.
- Use native connectors and standard platform capability wherever practical.
- Challenge whether Syncari is required for a particular use case.
- Agree 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 behaviors.
- Escalate repeated upstream defects.
- Help system owners understand how their changes affect the wider data flow.
- Own the modeled 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.
- Document systems, data flows, and operating rules.
- Create end-to-end system and data-flow diagrams.
- Document entity and attribute mappings.
- Document source-authority decisions.
- Document account hierarchy and matching rules.
- Document transformation and validation logic.
- Document known constraints and approved exceptions.
- Document testing, release, and rollback procedures.
- Document ownership and escalation routes.
- Document the expected impact of proposed schema or system changes.
Requirements
- 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 modeling 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 without relying solely on formal authority.
- Evidence that you can simplify an existing system, not only build new capability.
- Prefer the least complex solution that reliably meets the need.
- Use native and default platform capability before reaching for custom development.
- Fix defects at source rather than building permanent downstream workarounds.
- Make explicit decisions about ownership, authority, and exceptions.
- Test changes before releasing them and confirm that the expected outcome occurred.
- Treat monitoring, reconciliation, and documentation as part of the solution.
- Explain complex systems in plain language.
- Challenge unnecessary tooling and integration.
- Build systems that other people can understand and safely maintain.
Skills
- Syncari
- Workato
- Boomi
- Celigo
- Tray.ai
- MuleSoft
- SnapLogic
- Reltio
- Profisee
- Semarchy
- Informatica
- HubSpot
- Sage
- Power BI
- semantic data modelling
- dimensional data modelling
- Structured Query Language
- Application Programming Interfaces
- webhooks
- OAuth
- Custom connectors
- scripting
- cloud-data platforms
- Product-usage data
- telemetry data
- Data onboarding
- Lean
- Six Sigma
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
About the Company
- Totara is a global learning platform trusted by more than 1,500 organisations and 21 million users worldwide.
- We help organisations build workforce readiness through flexible learning, compliance, and talent development solutions designed for complex and highly regulated environments across both the public and private sectors.
- Totara is building a connected and trustworthy data foundation across its commercial, finance and product systems.
Equal Opportunity
- 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.
