Business Intelligence Analyst

Piper Companies is seeking a Data Analytics consultant to join a financial services organization located in McLean, VA through a hybrid contract-to-hire opportunity. The Data Analytics Consultant 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 Data Analytics Consultant 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.
• Utilize Data governance tools such as Collibra, Ataccama, or Informatica
• 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 Data Analytics Consultant include:

• 3+ 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.
• Familiarity with Data governance tools
• Experience with Snowflake or similar tools
• 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 Data Analytics Consultant Include:

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

#LI-RL1 #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, Snowflake, Data governance