Deskripsi Pekerjaan

Job Description
Create and prepares MIS and ad hoc analysis for Collections (desk, field and legal) – daily, weekly monthly. Provide calculation in targeting, Incentives calculation, Commission calculation and prepare final report by using Oracle SQL developer / Pl_SQL Developer to access the data warehouse data.
     - Design the report based on business needs (structure, charts) by conduct searching, prepare, transform, calculate and extract the data from data warehouse and dialer source tables (SQL)
     - Provide process automatization (SQL jobs, procedures, ODBC to excel) to support and improve current business process.
     - Maintain and generate the regular reports (daily, weekly, monthly) and make sure the analysts check regularly the data to understand the trends, highlight the issues, propose next steps, explain the reported figures to management and calculate incentives for desk and field collectors,
     - Propose and prepare ad hoc analysis to understand the collection issues and to be able to fix them 5. Develop collections scorecards to analyze overall CRS performance
Requirements
     - University degree – preferably statistics, economy, IT
     - Excellent SQL knowledge
     - Advanced excel skills – lookup functions, pivot tables, validations, macros
     - Experience with MIS or analysis
     - English – written and spoken
Nice to have:
     - Experience from collections
     - Experience with OBI

Tentang Perusahaan

No. Telepon

021 - 29539655 ext : 73109

Address

Gd.Plaza Oleos Lt.8 - 10, Jl.TB Simatupang No.53A

Lowongan Kerja Rekomendasi