Credit Reporting & Data Analyst
Mantrac -
Cairo, EgyptJob Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Extract, filter, and aggregate data through logical queries.
- Analyse user data needs and determine needs resolved through automated repeatable process.
- Prepare transparent standard Receivables reports and analyze to support business needs.
- Consolidate AR information, cash receipt, disputed AR and inventory backlog information.
- Create dashboard environment for credit and risk data with automated, simplified and streamlined data refresh options.
- Create custom views to facilitate faster decision making.
- Achieve monthly performance targets with strong focus on AR v Revenue reduction/DSO, AR quality and AR conversion to cash.
- Ensure full compliance with the Global Credit Policy, adherence to LOA and DOA.
- Facilitate effective cash forecasting process and timely collection of due Receivables in line with credit terms.
- Proactively facilitate AR dispute resolution and arrange internal escalations.
- Proactively facilitate the cash application process by Transaction Processing dept
- Monitor AR exposure within credit limits established by Group Credit.
- Monitor & action orders on credit hold on the daily basis.
- Support Mantrac Group business units in establishment of new accounts with provision of required information.
- Prepare Receivable data required to perform internal and external audits.
- Ensure high data quality through regular quality checks.
- Ensure effective DMS for archiving the evidence of business process controls, both credit risk and cash collection.
- Support management team to efficiently perform fiscal month end close reporting duties within credit and collection function.
- Support and grow existing document management system.
- Create meaningful and easy to use and maintain data storage structure.
- Provide support to Head of Credit in managing group and territorial information ad-hoc requests.
- Administer (and sometimes initiate) small-scale projects, present findings, propose solutions, report outcomes/results. Collaborate in cross-functional projects.
Job Requirements
- Bachelor's degree in (Preferably in Finance, Accounting, Statistics, or a related field).
- Min. 2 years of experience in credit reporting, data analysis or a related field.
- Business reporting and complex data management experience.
- Data management experience in credit and collections environment or similar within finance/treasury industry.
- Advanced numerical and Excel skills
- Experience in data management (SharePoint / Qlik sense)
- Advanced ERP knowledge: Oracle, SAP, MS dynamics and sim.
- Knowledge of reporting software: Power BI and sim.
- Cash collection and credit knowledge in B2B environment.
- Ability to research and to present data in clear and simple format.
- Ability to multitask and adhere to deadlines.
- Time management and organizational skills
- Proactiveness and drive for operational excellence.