Billing Data Analyst — Subscription billing Intelligence
Location: Mexico and Canada
Duration: 9-12 month
JD
About the Role
A hands-on analyst-engineer bridging CBO, Finance, Data Engineering, and BI. You will own and expand an internal validation engine to identify and mitigate core subscription billing anomalies, audit key metrics (LBS, ALPP), and reconcile perpetual license records against subscription LPP to fix legacy migration gaps using Oracle SQL.
Key Responsibilities
- Anomaly Identification & Engine Maintenance: Detect, audit, and investigate subscription billing anomalies, false positives/negatives, and edge cases (ramps, co-termination, 4-4-5 calendars, split-line billing); propose logic updates after sizing population impact.
- Discrepancy Remediation & Asset Reconciliation: Triage and systematically mitigate legacy migration gaps (missing entitlements, stale pricing) across perpetual asset records and subscription models; track backlogs across quarterly cycles.
- SQL Delivery & Engineering: Write, test, and deploy Oracle SQL MERGE scripts, verification queries, duplicate-key guards, and rollback plans to apply automated anomaly corrections to Oracle Fusion/CPQ tables.
- Stakeholder Collaboration: Partner with CPQ, Finance, and BI/Looker teams to answer ad-hoc anomaly inquiries, document mitigation decisions for audits, and ensure compliance.
Required Qualifications
- Oracle SQL (Intermediate–Advanced): Deep experience writing MERGE statements, complex joins, and pre/post-verification scripts.
- Subscription Billing Mechanics: Proven ability to identify billing anomalies and evaluate LastBillSchedule, AnnualizedLastPricePaid, ramp deals, co-term, credit memos, and perpetual-to-subscription models.
- Analytical Rigor: Ability to mathematically verify anomaly mitigation fixes and size population impacts prior to code deployment.
Preferred Experience & Domain Knowledge
- Oracle Fusion (quotes, orders, billing schedules, credits, asset records).
