CRS Business Intelligence Analyst - JAKARTA
Home Credit Indonesia (Recruitment Page for RISK team)
- South Jakarta, Indonesia9, Jalan Tahi Bonar Simatupang, South Jakarta, DKI Jakarta, IndonesiaSouth JakartaDKI JakartaIndonesiaIndonesia
- Penuh waktuFULL_TIME
Ditutup.
Deskripsi Pekerjaan
Responsibilities:
1. Monitoring and improvement of jobs and procedures within Oracle DB
- Daily monitoring of running jobs, spot trends in their performance
- Suggest and implement optimization
- Develop and maintain in-house scheduling/prioritization tool for PL/SQL procedures
- Standardize procedures (logging system, documentation)
- Participate in code review
2. Data calculation and storage architecture
- Suggest architecture of data tables, packages procedures and functions within the department
- Rewrite commonly used pieces of code to PL/SQL procedures/package
3. Automated Reporting
- Develop and maintain a solution for automatic refreshing and sending of the reports (OBI, Excel VBA, Python, later Tableau)
- Solution for automated upload of data (trackers, rosters, ...) from business to DB for reporting
4. Data Quality monitoring
- Prepare solution for checking source data (load of DataMart, comparison of data between systems)
- Maintain a list of tickets from CRS department, follow up with IT
Kualifikasi Minimum
- Candidate must possess at least Bachelor’s Degree majoring in Engineering (Computer/IT), Mathematics or equivalent.
- At least 2 year(s) of working experience in the similar field is required for this position, in process and analysis design with business process analysis/changes.
- Experience from the Risk department in Project Management, collections.
- Experience with Oracle query optimization - Explain plan, best practices
- Experience with programming (PL/SQL, VBA, and Python)
- Well versed skill(s) in using Excel (pivot tables / charts), Tableau.
- Have knowledge of DB architecture (normal forms,).
- Knowledge about data calculation process and possibilities
- Strong analytical and problem solving skills
- Fluent English (written, spoken)
Fasilitas dan Tunjangan
- Gym Membership
- Performance Bonus
- Life Insurance
- Medical / Health Insurance
- Maternity & Paternity Leave
Keahlian yang diperlukan
- MS SQL Server
Ringkasan Perkerjaan
- Tingkat Posisi
- Supervisor / Asisten Manager
- Spesialisasi
- IT and Software
- Persyaratan tingkat pendidikan
- Lulus program Diploma (D3)
- Respon rekruter ke lamaran
- Once in a while
- Alamat Kantor
- 9, Jalan Tahi Bonar Simatupang , South Jakarta, DKI Jakarta, Indonesia
- Lowongan
- 1 lowongan dibuka
Tentang Home Credit Indonesia (Recruitment Page for RISK team)
Home Credit Indonesia is a multi finance company which provides financing through the stores of our retail partners to consumers who want to purchase consumer durables products. Home Credit financing solutions are Easy, Simple and Fast.
Home Credit Indonesia was established in 2013. We are headquartered in Jakarta and growing our business to expand into all cities and territories in Indonesia. Today we have more than 11,600 employees and its keep growing.
We are always on the look-out for talented, enthusiastic people who are driven by results and success and if you are one of these people we would love to hear from you. In return we can offer you a career with one of the largest global financing players and an active role in helping to shape the future of our business.