Trantor
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.
Source ⇲
