AVP Debt Manager

Axis Technologies; United States; Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading technology firm in the United States seeks an AVP, Debt Manager Database & Application Subject Matter Expert. The role requires advanced SQL skills and database troubleshooting expertise. You will act as the primary technical authority for operational strategies, support backend processes, and provide user training. Candidates must demonstrate proven experience with Debt Manager and end-to-end collection data flows. This position offers flexibility in work shifts with a strong emphasis on database performance and data integrity.

Qualifications

• Strong database troubleshooting skills, including stored procedures and performance optimization.
• Proven expertise supporting Debt Manager and complex account lifecycle processing.
• Ability to translate technical details into actionable guidance.

Responsibilities

• Act as SME for database structure and data lineage within Debt Manager.
• Provide expert-level SQL support for account selection logic and queries.
• Support backend processes for archiving and purging accounts.
• Serve as SME for worklists and segmentation logic within Debt Manager.
• Explain and troubleshoot application integration patterns and APIs.

Skills

Advanced SQL

Database troubleshooting

Job description

Duration: 4/6/26 to 12/31/26 w/possible extension

Work Shift: 1 day per week/possibly more

Role Summary

The AVP, Debt Manager Database & Application Subject Matter Expert (SME) serves as the primary technical authority for how SYF Commercial Prox collection strategy operates within Debt Manager and its supporting database and services. This role partners with technology and operations, and external vendors to troubleshoot complex production issues, optimize performance, and ensure data integrity across the end-to-end account lifecycle—from system of record through segmentation and work execution, including downstream dialer integration.

Key Responsibilities

• Act as SME for database structure and data lineage, including table/column locations and where key account data is housed.
• Provide expert-level SQL support, including correct syntax for filters, queries, and account selection logic.
• Provide understanding on maintenance and troubleshoot stored procedures, partitions, and related database objects; recommend and implement amendments as needed.
• Strong understanding of deep functional/technical knowledge of the SYF Commercial PROX collection strategy, including how strategy executes inside Debt Manager.
• Support backend processes for archiving and purging accounts to manage active record volumes in alignment with records retention requirements.
• Serve as SME for worklists, segmentation logic, tags, and segment flow within Debt Manager, train users, and stakeholders.
• Support and provide SME support for User Defined Pages, including configuration, intended use, impacts to workflows, and troubleshooting.
• Support and advise on account relationship modeling (primary/secondary ownership), including linking/delinking and one-to-many/many-to-many relationships; resolve record duplication issues.
• Support decisioning and workflow timing elements, including next contact date logic and Blaze table/rules integration.
• Provide expertise on payment update processing, suspended account handling, future transactions, and soft delete impacts.
• Support batch scheduling and automation (cron jobs) and investigate latency/performance issues (e.g., AR table delays).
• Explain and troubleshoot application integration patterns, including REST APIs and how they interact with stored procedures and/or microservices.
• Support end-to-end expertise of the full collections flow, including how accounts and attributes move from the system of record into Debt Manager and onward to downstream channels (e.g., dialer); diagnose breaks, timing issues, and data mismatches across the chain.
• Leverage prior experience working with external companies to identify risks, pitfalls, and best practices during integrations or changes.
• Provide user training for Debt Manager backend functionality, including processes, controls, and troubleshooting guidance.

Qualifications / Experience

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

Must Haves

• Advanced SQL and strong database troubleshooting skills (stored procedures, partitioning, performance).
• Proven expertise supporting Debt Manager and complex account lifecycle processing, including segmentation and downstream execution channels.
• Strong understanding of end-to-end collections data flows (system of record → Debt Manager → dialer and related interfaces).