AVP Debt Manager

• Seeking an experienced AVP, Debt Manager Database & Application SME to serve as the primary technical authority for collections strategy operations within Debt Manager and supporting databases. The role involves partnering with technology and operations teams to troubleshoot complex production issues, optimize performance, and ensure data integrity across the end-to-end account lifecycle.

Key Responsibilities

• Serve as SME for database structure and data lineage, including table/column locations and account data storage.
• Provide expert-level SQL support, including filters, queries, and account selection logic.
• Maintain and troubleshoot stored procedures, partitions, and related database objects; implement amendments as needed.
• Support backend processes for archiving and purging accounts in line with records retention requirements.
• Provide SME support for worklists, segmentation logic, tags, and segment flow; train users and stakeholders.
• Advise on account relationship modeling, resolving duplication and linking/delinking issues.
• Support decisioning and workflow timing elements, including next contact logic and table/rules integration.
• Provide expertise on payment processing, suspended account handling, future transactions, and soft delete impacts.
• Support batch scheduling and automation (cron jobs) and investigate latency/performance issues.
• Explain and troubleshoot application integration patterns, including REST APIs interaction with stored procedures or microservices.
• Provide end-to-end support for collections flow, diagnosing breaks, timing issues, and data mismatches across systems.
• Offer guidance on integrations and changes based on prior experience with external vendors.
• Conduct user training for Debt Manager backend functionality, processes, controls, and troubleshooting.

Qualifications / Experience

• Advanced SQL skills and strong database troubleshooting experience (stored procedures, partitioning, performance).
• Proven expertise with Debt Manager and complex account lifecycle processing, including segmentation and downstream execution channels.
• Strong understanding of end-to-end collections data flows.
• Ability to translate technical details into actionable guidance for operations and leadership.

Work Authorization

Visa sponsorship may be considered on a case-by-case basis in accordance with applicable laws.