Objective
Supporting the Reporting Manager in ensuring that the Reporting tools supporting the whole range of Collections Activities are available, easy to use and regularly updated with accordance to established time-schedules would it be Internally or Externally developed while striving to automatise, optimize and propose improvements and redundancy avoidance measures to the whole range of internal clients.
Responsibilities
1. Oversight of the assigned part of the collections reporting portfolio from an availability, ease of use and business relevance perspective.
a. Proposing, designing and creation of new reports covering areas that could prove useful to internal clients.
b. Proposing and creating automations of assigned regular reports as much as possible
c. Taking over all responsibilities linked to the reporting portfolios of absent, fellow reporting Analysts as agreed with manager
d. Basic sanity checks to be done for every report sent to internal or external clients and healthcheck processes to be proposed and implemented for automated reports.
2. Close cooperation with IT to ensure minimal reporting delays on assigned portfolio
3. Supporting manager on implementation of new reporting tools and on migrating reports to new platforms.
4. Developing robust, easy to use and useful stakeholder dashboards.
5. Ensuring timely delivery of BAU reports with accuracy.
6. Providing useful insights out of the reports and sending relevant conclusions to stakeholders with suggestions and necessary future steps.
7. Proposing, modifying and optimizing existing SQL codes to achieve higher accuracy and faster processing times.
8. Working on adhoc requests while ensuring delivery on agreed timelines while making sure direct management is aware, understands and agrees with the ad-hoc task given priority relative to other tasks planned.
9.Taking the role of Subject Matter Expert in Reporting & BI discussions with other business entities about possible reports, projected timeframes, team needs and data presentation
10. Giving MS Excel or any other widely available reporting platform tool training to internal clients who are using them to receive or access reports made by Collection Strategy & Analytics Department.
11. Coaching more junior members of the team on correct and quality realization of task assignments and sharing best work practices
12. Ensuring business continuity in case of absence/unavailability of line manager.
Need to Have Areas
1.Knowledge with Oracle SQL Developer environment or MS SQL Management Studio
2.Basics of SQL Optimization skills
3.Knowledge on the topic of reports testing and sanity checks
4.Knowledge in visualizing complex data in a simple, intuitive and useful way for stakeholders
5.Advanced Excel skills and advanced knowledge of Ms Office suite
6.Knowledge of champion-challenger and pilot monitoring methodologies
7.Knowledge with VBA Scripting
8.Knowledge in creating Dashboards
9.Data Analysis skills