Zuora Data Engineer

INSPYR Solutions is a technology-focused company that delivers flexible technology and talent solutions. They are seeking a Senior Finance Data Analyst to lead the automation of Net Renewal Forecasting capabilities, transforming manual processes into scalable data products using Zuora and Snowflake.

Responsibilities:

• Partner with FP&A and Finance leadership to define and operationalize: Net Renewals, Gross Renewals, Churn (logo and revenue), Renewal timing and forecasting assumptions
• Translate business logic into scalable data models and automated processes
• Validate and reconcile forecast outputs against actuals and financial reporting
• Own analysis and modelling of Zuora billing and subscription data, including: Rate Plans, Charges, Amendments, and Subscriptions
• Identify and resolve data gaps, inconsistencies, and edge cases in billing data
• Define repeatable logic for renewal classification and attribution
• Build and optimize SQL-based data models in Snowflake to support renewal forecasting
• Collaborate with Analytics Engineering to productionize models using dbt
• Replace manual workflows with automated, governed data pipelines
• Ensure models are aligned with enterprise data standards and certified data products
• Perform deep data validation and reconciliation across systems (Zuora, Snowflake, Excel outputs)
• Identify root causes of discrepancies (e.g., billing timing, connection changes, credits)
• Implement and monitor data quality checks and controls
• Deliver clear, finance-ready outputs and explanations of renewal performance and forecast drivers
• Support executive reporting with accurate, trusted metrics
• Communicate complex billing and data concepts in a business-friendly way

Requirements:

• Strong hands-on experience with Zuora (billing + subscriptions)
• Deep understanding of rate plans, amendments, renewals, and billing flows
• Advanced SQL skills (complex transformations, performance tuning)
• Experience working with Finance / FP&A teams on forecasting or revenue analytics
• Proven ability to translate business logic into data model
• Experience with Snowflake and modern data stack (dbt, ELT pipelines)
• Background in subscription SaaS metrics (ARR, churn, renewals, billings)
• Experience automating manual Excel-based financial processes
• Familiarity with systems like Salesforce, NetSuite, or Connect-type product data
• Exposure to predictive modelling or forecasting techniques