Oracle SQL Data Analyst: Reconciliation & Finance Insights

PT Lawencon Internasional; Jakarta Selatan; On-site; IDR 60,000,000 - 120,000,000; Full time

Job summary

PT Lawencon Internasional is seeking a Data Analyst to extract and process data from Oracle Database using SQL, identify discrepancies, and perform reconciliations across General Ledger and operations. The role collaborates with Finance and IT to investigate data issues and prepare actionable analysis and recommendations.

The ideal candidate will have a Bachelor’s degree in Information Systems or Computer Science, 1+ year of data analysis experience, and proficiency in Python and Excel for

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or related field.
• Minimum 1 year of experience as a Data Analyst.
• Proficient in SQL, particularly Oracle Database.
• Proficient in data analytics tools such as Python and Microsoft Excel.
• Strong data analysis skills with the ability to identify root causes.
• Detail-oriented, with strong problem-solving skills and the ability to work with large volumes of data.
• Knowledge of Finance/Accounting or General Ledger processes is an added advantage.

Responsibilities

• Extract and process data from Oracle Database using SQL.
• Analyze data to identify discrepancies and anomalies.
• Perform data reconciliation related to General Ledger and operational transactions.
• Prepare analysis reports along with recommendations for resolution.
• Collaborate with Finance and IT teams for data investigation.
• Develop queries or analytical methods to improve the efficiency of the reconciliation process.

Skills

Oracle SQL

Data analysis

Excel

Problem solving

Finance knowledge

Education

Bachelor's degree in Information Systems / Computer Science

Tools

Python

Excel

Job description

PT Lawencon Internasional is seeking a Data Analyst to extract and process data from Oracle Database using SQL, identify discrepancies, and perform reconciliations across General Ledger and operations. The role collaborates with Finance and IT to investigate data issues and prepare actionable analysis and recommendations.

The ideal candidate will have a Bachelor’s degree in Information Systems or Computer Science, 1+ year of data analysis experience, and proficiency in Python and Excel for