Systems Analyst III

Job title: AVP Debt ManagerLocation: Fully RemoteDuration: 08+months; possible extensionsWork Shift: 1 day per week/possibly moreResponsibilitiesMust 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).Role SummaryThe AVP, Debt Manager Database & Application Subject Matter Expert (SME) serves as the primary technical authority for how 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 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.