Technical Product Manager

Overview

Today, the business uses several Access databases to fill functionality gaps in Mortgage (notably email/SMS) and to create Lease campaigns end‐to‐end. As part of CGT 3.0, we are consolidating those capabilities into CGT, expanding digital channels, and migrating components from .NET + Angular to Java Spring Boot + React to improve scalability, speed, and configurability.

System analysis & decomposition

• Deep‑dive CGT 2.0 and associated legacy assets (Access DBs, .NET services, SQL processes) to document current behavior, data dependencies, and campaign execution paths.
• Identify functional gaps and required data elements to enable configuration for Mortgage, Consumer, and Lease.
• Translate business goals into clear, testable requirements and acceptance criteria for UI (React), API (Spring Boot), and data layers.
• Partner with the Product SME to sequence work and manage scope across migrations and net‑new features.

Data validation & SQL analysis

• Write simple SQL queries to validate segmentation results, investigate anomalies, and confirm regulatory treatments are applied as expected. (No authoring of stored procedures required.)
• Review outputs from existing stored procedures and ETL jobs to verify correct execution of business rules.

Cross‑functional leadership

• Serve as the on‑shore point of contact for offshore front‑end, back‑end, ETL, and QA teams; drive clarity, unblock issues, and ensure end‑to‑end cohesion.
• Maintain alignment across Angular→React and .NET→Java migrations while preserving current business outcomes.

Quality & delivery

• Support QA in defining test scenarios, data sets, and validation checkpoints for campaign configuration and execution.
• Provide crisp documentation of configuration logic, data mapping, and workflow design.

Must‑Have Skills

• Background in mortgage, consumer loan, or lease servicing, ideally in outreach/collections, delinquency cure, loss‑mitigation, or similar domains requiring regulatory treatments.
• Strong grasp of coding principles and system design; able to lead developers and converse fluently on trade‑offs.
• SQL proficiency for validation (joins, filters, aggregations) and comfort investigating data issues.
• Familiarity with:
• API‑driven architectures (e.g., .NET or Java Spring Boot
  )
• ETL concepts and data pipelines (SSIS, Informatica)

Nice‑to‑Have Skills

• Experience with dialer/outreach systems or rules engines for segmentation/treatments.
• Exposure to stored procedure workflows (reading/triaging, not authoring).
• Hands‑on collaboration with distributed (offshore) teams.

Soft Skills

• Excellent communicator who can represent technical details to business stakeholders.
• Highly autonomous; comfortable operating as the sole on‑shore delivery partner.
• Structured problem solver with a strong sense of ownership and urgency.