Junior Data Analyst
Core
Extract, consolidate, and clean data from multiple sources to analyze portfolio debt, recoveries, and non-payments, while preparing information for business management. (via careerplan.io/jobs/2827830-junior-data-analyst-at-netolympus-slu)
Role type
Junior data analyst (finance)
Builds
Dashboards and reports on debt recovery KPIs
Domain
Financial services / Debt management
Deliverable
dashboards & analysis
Required skills
Advanced Excel (PivotTables, XLOOKUP, formulas), Data consolidation, ERP systems (Microsoft Dynamics 365), Portfolio analysis, KPI tracking, Data validation
Preferred skills
Power Query, Power BI, CFGS in Administration and Finance
Responsibilities
Extract and clean data from various sources, Analyze portfolio debt and recovery metrics, Create and maintain reports and dashboards, Identify trends and anomalies in payment data, Reconcile information between ERP and payment systems, Prepare data for business management, Propose improvements to reporting and processes
Seniority
Junior, hands-on IC