Credit Collections Reporting Analyst
Job Summary
:
The Credit/Collections Reporting Analyst delivers analytical support for Direct Energy’s active and inactive credit and debt portfolios. Through reporting and analysis, the role assesses credit risk strategies, portfolio results, dunning effectiveness, and bad debt trends to inform operational and strategic decisions.
As part of the Direct Energy Consumer Credit & Collections team, the Analyst provides insights into portfolio risk, scorecard results, and broader business performance.
Success in this role requires strong cross-functional collaboration and practical expertise in risk management, analytics, and reporting.
Essential Duties:
1. Reporting & Analytics
- Develop and maintain performance reporting for active and inactive portfolios
- Track credit risk, delinquency, and bad debt trends
- Create dashboards, scorecards, and operational reports
- Deliver variance analysis and actionable performance insights
- Support portfolio forecasting and modelling
- Ensure vendor reports are accurate and timely
2. Business Intelligence & Data Management
- Build tools to extract, combine, and analyze data from multiple systems
- Produce ad hoc reports and analyses
- Support operational and strategic analytics
- Identify opportunities to improve reporting and processes
- Contribute to business intelligence and data governance initiatives
3. Vendor Reporting & Performance Monitoring
- Develop and maintain vendor scorecards
- Monitor the accuracy and timeliness of vendor reporting
- Validate vendor data and performance measures
- Investigate and resolve reporting discrepancies
- Analyze vendor performance and provide insights
4. Process Improvement & Strategy Support
- Contribute to process improvement initiatives
- Prepare business cases and loss-and-gain analyses
- Provide insights to support bad debt targets
- Provide analytical support for operational and strategic initiatives
- Recommend policy and process enhancements
- Support cross-functional improvement efforts
5. Cross-Functional Collaboration
- Partner with Credit, Collections, Finance, Operations, and external vendors
- Support Supply Chain, Sales, and Marketing as needed
- Participate in cross-functional project teams
- Provide analysis to guide operational decisions
Minimum Requirements:
Education
- A Bachelor’s degree in Business Analytics, Data Science, Computer Science, or a related field from an accredited four-year institution is preferred A two-year diploma combined with relevant work experience may also be considered
Experience
- At least three years of experience in credit, collections, risk, or business analytics
- Strong background in analytics and reporting
- Advanced Microsoft Power BI skills, including DAX, Power Query, and data modelling
- Experience using SQL, Python, R, or similar languages to create views and data consumption layers and to transform and integrate SQL database data
- Experience analyzing large datasets
- High attention to detail and accuracy
- Experience working across functions and teams
Preferred Qualifications:
- Experience in the utility or energy industry
- Collections or bad debt analysis experience
- Vendor performance reporting experience
- Experience in a regulated environment
- Familiarity with SAP, Salesforce, NICE, or comparable systems
Technical Skills
- Advanced Microsoft Excel
- SQL and PL/SQL
- SAS Enterprise Guide or Base SAS preferred
- Microsoft Word, PowerPoint, and Access
- Data visualization tools, preferably Power BI or Tableau
- Working knowledge of Visual Basic or VBA preferred
Key Skills & Competencies
- Advanced analytical and problem-solving ability
- Expertise in data mining and analytics
- Sound independent judgment and initiative
- Strong planning and organizational skills
- Ability to balance multiple priorities
- Clear communication and presentation skills
- Effective stakeholder management and collaboration
- Ability to develop compelling business cases
- Risk assessment and decision-support capability
- Commitment to continuous improvement