Banking Data Analyst - Bronze Layer Reconciliation

RAPSYS TECHNOLOGIES PTE LTD; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

RAPSYS TECHNOLOGIES PTE LTD in Singapore seeks an experienced Data Analyst to optimize banking data ingestion and reconciliation. You will analyze data across Bronze layer domains and partner with Finance, Risk, and Tech teams to ensure data quality and robust reporting.

Responsibilities include profiling, validation, source-to-target mapping, and building dashboards with Power BI to illustrate trends and exceptions. Strong SQL and Python skills are essential.

Qualifications

• 6+ years of experience in data analysis within banking or financial services.
• Hands-on experience with data profiling and source-to-target reconciliation.
• Strong banking domain knowledge across at least one core area (e.g., Management Accounting, Financial Accounting, Regulatory Reporting, Transaction Banking).

Responsibilities

• Perform data profiling, validation, and reconciliation of source data in the Bronze layer.
• Validate source-to-Bronze ingestion for completeness and accuracy.
• Develop reconciliation checks across counts, balances, totals, and field-level validations.
• Investigate data discrepancies and collaborate with data engineering and source teams to resolve them.
• Document data lineage, mappings, and reconciliation rules; produce data quality reports.
• Create dashboards/visualizations in Power BI to communicate data quality and trends.
• Work with Finance, Risk, Regulatory Reporting, and Technology teams to support testing and verification.

Skills

Data profiling

Data validation

Data reconciliation

SQL

Databricks

Apache Spark

Python

Excel

Power BI

Data lineage

Data governance

Communication skills

Analytical thinking

Education

Degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, Engineering

Tools

Databricks notebooks

Databricks

Power BI

Job description

RAPSYS TECHNOLOGIES PTE LTD in Singapore seeks an experienced Data Analyst to optimize banking data ingestion and reconciliation. You will analyze data across Bronze layer domains and partner with Finance, Risk, and Tech teams to ensure data quality and robust reporting.

Responsibilities include profiling, validation, source-to-target mapping, and building dashboards with Power BI to illustrate trends and exceptions. Strong SQL and Python skills are essential.