BI Developer/Reporting Analyst

Piper Companies is seeking a BI Developer/Reporting Analyst to join a financial services organization located in San Antonio, Texas through a hybrid contract-to-hire opportunity. The BI Developer/Reporting Analyst will provide insights into collections performance by analyzing data, automating reports and dashboards, and collaborating with teams to optimize recovery strategies and support compliance and decision-making.

Responsibilities of the BI Developer/Reporting Analyst Include:

• Analyze large volumes of collections and recovery data to identify trends, patterns, and anomalies that inform strategic decisions.
• Design, automate, and maintain performance dashboards and reports using Excel, SQL, Tableau, or Power BI.
• Interpret and present daily, weekly, and monthly performance metrics to stakeholders, highlighting actionable insights.
• Collaborate with collections, credit risk, and operations teams to evaluate and enhance debt recovery strategies and tactics.
• Ensure data accuracy, integrity, and compliance with internal policies and regulatory standards; support audit and compliance efforts.
• Develop ad hoc analyses, scorecards, and visual presentations to monitor business trends, optimize processes, and guide strategic planning.

Qualifications for the BI Developer/Reporting Analyst include:

• 2+ years of experience in a data warehouse or analytics environment, preferably within financial services or collections.
• Bachelor’s degree in Business, Data Science, Computer Science, or a related field is preferred.
• Proficiency in SQL and business intelligence tools such as Tableau or Power BI; experience with Python or other analytics languages is a plus.
• Strong understanding of data integration, ETL processes, and regulatory frameworks like FDCPA and CFPB.
• Familiarity with collections systems (e.g., FICO Platform), credit risk, customer segmentation, and financial KPIs.

Compensation for the BI Developer/Reporting Analyst Include:

• Salary Range: $85,000 - $120,000
  • Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays

This job opens for applications on 9.2.25. Applications for this job will be accepted for at least 30 days from the posting date.

#LI-MR1 #LI-HYBRID

Keywords: collections, recovery, delinquency buckets, 30 DPD, 60 DPD, 90+ DPD, roll rates, charge-off metrics, collection strategies, letters, calls, digital outreach, FDCPA, TCPA, GLBA, CFPB, liquidation rate, promise to pay conversion, contact rates, credit bureau attributes, segmentation, credit risk, performance reporting, dashboards, Excel, SQL, Tableau, Power BI, data analysis, trend analysis, anomaly detection, stakeholder reporting, strategy development, debt recovery, process optimization, cost reduction, compliance, audit support, documentation, presentations, visuals, scorecards, performance management, ad hoc reporting, business intelligence, data science, cross-functional collaboration, data integrity, regulatory compliance, remote, hybrid, work from home, WFH, contract, internal reporting, collections analytics, collections performance, collections data, collections reporting, collections strategy, collections optimization, collections segmentation, collections compliance, collections audit, collections dashboard, collections metrics, collections KPIs