About the role
Job Title: Zuora Subscription Data Migration Specialist
Experience Level: 5-8+ Years
Location: Remote, Canada
Employment Type: Full-time
Job Overview:
We are looking for a seasoned Zuora Subscription Data Migration Specialist who will act as the go-to resource for end-to-end data migration activities in the context of transitioning Lead-to-Cash operations from Veritas to Cohesity systems . The ideal candidate will have strong experience with Zuora Billing and Subscription Management , excellent SQL/data analysis skills , and a good understanding of revenue operations and subscription lifecycle processes .
In addition to data extraction, reconciliation, and advisory responsibilities, the candidate should be comfortable collaborating across business, IT, and QA teams and provide support for business-as-usual (BAU) tasks post-migration such as bug fixes and minor system enhancements.
Key Responsibilities:
Data Migration & Analysis
- Lead and execute data extraction and transformation activities from legacy systems (Veritas) and prepare data for ingestion into Cohesity systems using Zuora as the subscription platform.
- Write, optimize, and maintain SQL queries for extracting, transforming, and validating large sets of financial, billing, and subscription data.
- Conduct thorough data analysis to identify discrepancies, anomalies, and mapping gaps across billing, subscription, invoicing, and customer account datasets.
- Support data cleansing, transformation logic, and loading mechanisms , ensuring data integrity throughout the migration pipeline.
- Perform data reconciliation and validation post-migration , collaborating with cross-functional teams to ensure migrated data aligns with business rules and functional expectations.
BAU Support & Enhancements
- Act as an advisory resource for business stakeholders on Zuora-related workflows, especially in Subscription, Product Catalog, Invoicing, and Billing modules.
- Support bug fixes, minor enhancements, and configuration updates as needed in response to BAU issues or process refinements.
- Provide input to IT teams and data architects on Zuora best practices , schema relationships, and custom data models.
- Collaborate with QA teams for testing strategy and support UAT cycles with relevant test data sets and validation queries.
Must-Have Skills:
- 5–8+ years of experience in data migration, with at least 3+ years working on Zuora (Billing & Revenue modules) .
- Proven experience in Lead-to-Cash workflows , especially Subscription Management, Product Catalog, Rate Plans, Invoicing, Payments, and Amendments.
- Strong proficiency in SQL and relational data modeling for extraction, transformation, and validation of subscription and financial data.
- Solid understanding of Zuora object model , key tables (e.g., Subscription, RatePlan, RatePlanCharge, Invoice, Payment), and custom field handling.
- Demonstrated ability in data reconciliation and root cause analysis with strong attention to detail and data accuracy.
- Experience with data migration lifecycle including requirement gathering, mapping, transformation logic, testing, and post-go-live support.
- Ability to communicate technical findings clearly to non-technical stakeholders and provide advisory inputs.
- Familiarity with error-handling mechanisms during data loads and rollback strategies.
- Hands-on experience with data profiling tools , Excel, and structured reports for reconciliation.
Good-to-Have Skills:
- Knowledge of ETL tools (e.g., Informatica, Talend, Boomi) and integration frameworks used with Zuora.
- Familiarity with Zuora REST APIs and Data Query (ZOQL) for advanced reporting or automation.
- Experience in working with Salesforce-Zuora integration or middleware solutions (MuleSoft, Dell Boomi, Workato).
- Understanding of GAAP revenue recognition principles and Zuora Revenue module (formerly RevPro).
- Familiarity with NetSuite, Salesforce CPQ, or any other ERP/CRM system connected with the Zuora ecosystem.
- Experience in Agile/Scrum project environments with JIRA/Confluence documentation.
- Exposure to data governance, audit tracking, and compliance frameworks like SOX, GDPR as applied to subscription data.
Knowledge of data visualization tools (e.g., Power BI, Tableau) to build reconciliation dashboards or audit summaries.
About Trantor
Trantor is a pioneer in creating enterprise technology solutions and state-of-the-art CaptiveCoE™ assisting enterprises across the globe with their digital transformations and business needs. Our commitment to excellence and authenticity has led to long-term working relationships with our clients and solution partners.
Since 2012, Trantor has helped enterprises across the globe expand their engineering capabilities and build successful technology products. With deep expertise in cloud strategy, cloud-native development, containers, application modernization, AI/ML, and Security/Compliance we help our customers leverage the full capabilities of the AWS cloud to accelerate innovation.
Trantor’s expertise in AWS cloud services helps customers achieve operational excellence, security & compliance on AWS Cloud. Trantor helps customers to optimize the usage of AWS through Managed DevOps services and commits to accurately forecast migration costs and build a detailed AWS migration plan. Trantor helps customers to take control of cost and continuously optimize spending while building modern, scalable cloud applications to meet their needs.
Trantor leverages the trifecta of Analytics, Automation, and AI to deliver intelligent automation solutions. We enable customers to scale their strategic technology and marketing Initiatives. Our deep experience in Fintech, Martech, E-commerce, and Captive Centers is visible in our comprehensive portfolio and globally spread customer base.
We also nurture strong partnerships with leading technology providers, including Amazon Web Services(AWS), Microsoft, Oracle, Adobe, Cloud Lending, Genpact, etc.
To learn more about Trantor, please visit www.trantorinc.com
About the role
Job Title: Zuora Subscription Data Migration Specialist
Experience Level: 5-8+ Years
Location: Remote, Canada
Employment Type: Full-time
Job Overview:
We are looking for a seasoned Zuora Subscription Data Migration Specialist who will act as the go-to resource for end-to-end data migration activities in the context of transitioning Lead-to-Cash operations from Veritas to Cohesity systems . The ideal candidate will have strong experience with Zuora Billing and Subscription Management , excellent SQL/data analysis skills , and a good understanding of revenue operations and subscription lifecycle processes .
In addition to data extraction, reconciliation, and advisory responsibilities, the candidate should be comfortable collaborating across business, IT, and QA teams and provide support for business-as-usual (BAU) tasks post-migration such as bug fixes and minor system enhancements.
Key Responsibilities:
Data Migration & Analysis
- Lead and execute data extraction and transformation activities from legacy systems (Veritas) and prepare data for ingestion into Cohesity systems using Zuora as the subscription platform.
- Write, optimize, and maintain SQL queries for extracting, transforming, and validating large sets of financial, billing, and subscription data.
- Conduct thorough data analysis to identify discrepancies, anomalies, and mapping gaps across billing, subscription, invoicing, and customer account datasets.
- Support data cleansing, transformation logic, and loading mechanisms , ensuring data integrity throughout the migration pipeline.
- Perform data reconciliation and validation post-migration , collaborating with cross-functional teams to ensure migrated data aligns with business rules and functional expectations.
BAU Support & Enhancements
- Act as an advisory resource for business stakeholders on Zuora-related workflows, especially in Subscription, Product Catalog, Invoicing, and Billing modules.
- Support bug fixes, minor enhancements, and configuration updates as needed in response to BAU issues or process refinements.
- Provide input to IT teams and data architects on Zuora best practices , schema relationships, and custom data models.
- Collaborate with QA teams for testing strategy and support UAT cycles with relevant test data sets and validation queries.
Must-Have Skills:
- 5–8+ years of experience in data migration, with at least 3+ years working on Zuora (Billing & Revenue modules) .
- Proven experience in Lead-to-Cash workflows , especially Subscription Management, Product Catalog, Rate Plans, Invoicing, Payments, and Amendments.
- Strong proficiency in SQL and relational data modeling for extraction, transformation, and validation of subscription and financial data.
- Solid understanding of Zuora object model , key tables (e.g., Subscription, RatePlan, RatePlanCharge, Invoice, Payment), and custom field handling.
- Demonstrated ability in data reconciliation and root cause analysis with strong attention to detail and data accuracy.
- Experience with data migration lifecycle including requirement gathering, mapping, transformation logic, testing, and post-go-live support.
- Ability to communicate technical findings clearly to non-technical stakeholders and provide advisory inputs.
- Familiarity with error-handling mechanisms during data loads and rollback strategies.
- Hands-on experience with data profiling tools , Excel, and structured reports for reconciliation.
Good-to-Have Skills:
- Knowledge of ETL tools (e.g., Informatica, Talend, Boomi) and integration frameworks used with Zuora.
- Familiarity with Zuora REST APIs and Data Query (ZOQL) for advanced reporting or automation.
- Experience in working with Salesforce-Zuora integration or middleware solutions (MuleSoft, Dell Boomi, Workato).
- Understanding of GAAP revenue recognition principles and Zuora Revenue module (formerly RevPro).
- Familiarity with NetSuite, Salesforce CPQ, or any other ERP/CRM system connected with the Zuora ecosystem.
- Experience in Agile/Scrum project environments with JIRA/Confluence documentation.
- Exposure to data governance, audit tracking, and compliance frameworks like SOX, GDPR as applied to subscription data.
Knowledge of data visualization tools (e.g., Power BI, Tableau) to build reconciliation dashboards or audit summaries.
About Trantor
Trantor is a pioneer in creating enterprise technology solutions and state-of-the-art CaptiveCoE™ assisting enterprises across the globe with their digital transformations and business needs. Our commitment to excellence and authenticity has led to long-term working relationships with our clients and solution partners.
Since 2012, Trantor has helped enterprises across the globe expand their engineering capabilities and build successful technology products. With deep expertise in cloud strategy, cloud-native development, containers, application modernization, AI/ML, and Security/Compliance we help our customers leverage the full capabilities of the AWS cloud to accelerate innovation.
Trantor’s expertise in AWS cloud services helps customers achieve operational excellence, security & compliance on AWS Cloud. Trantor helps customers to optimize the usage of AWS through Managed DevOps services and commits to accurately forecast migration costs and build a detailed AWS migration plan. Trantor helps customers to take control of cost and continuously optimize spending while building modern, scalable cloud applications to meet their needs.
Trantor leverages the trifecta of Analytics, Automation, and AI to deliver intelligent automation solutions. We enable customers to scale their strategic technology and marketing Initiatives. Our deep experience in Fintech, Martech, E-commerce, and Captive Centers is visible in our comprehensive portfolio and globally spread customer base.
We also nurture strong partnerships with leading technology providers, including Amazon Web Services(AWS), Microsoft, Oracle, Adobe, Cloud Lending, Genpact, etc.
To learn more about Trantor, please visit www.trantorinc.com