Data Analyst: Banking Data Ingestion & Reconciliation

Ambition Singapore; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Ambition Singapore is seeking an experienced Data Analyst with strong banking domain knowledge to ensure data accuracy, completeness, and integrity for source data ingested into the Bronze layer of our data platform. This role focuses on data profiling, validation, reconciliation, and source-to-target analysis across core banking domains.

You will work with business, finance, data engineering, and technology teams to validate ingestion outcomes, document data lineage, and implement data quality

Qualifications

• 6 years of experience in data analysis within banking/financial services.
• Hands-on data profiling and source-to-target reconciliation in raw data ingestion layers.
• Strong domain knowledge in Banking (e.g., Management Accounting, Regulatory Reporting, Transaction Banking).
• Experience documenting data lineage, validation rules, and reconciliation procedures.

Responsibilities

• Perform data profiling, validation, and reconciliation of source data in the Bronze layer.
• Validate ingestion outcomes for completeness, accuracy, and integrity.
• Develop and execute reconciliation checks focused on counts, balances, and data quality rules.
• Investigate discrepancies between source systems and the data platform; identify root causes and collaborate with teams.
• Create source-to-target mappings and data lineage documentation; produce data quality reports.
• Use SQL, Databricks, Spark, Python, notebooks, and Excel for large-scale data analysis.
• Build Power BI dashboards to communicate data quality, reconciliation results, and trends.
• Collaborate with Finance, Risk, Regulatory Reporting, and Technology teams; support testing and QA.

Skills

Data profiling

Data validation

Data reconciliation

Source-to-target analysis

SQL

Databricks

Spark

Python

Notebooks

Excel

Power BI

Data lineage

Data governance

Communication

Cross-functional collaboration

Tools

Databricks Notebooks

Databricks

Apache Spark

Excel

Job description

Ambition Singapore is seeking an experienced Data Analyst with strong banking domain knowledge to ensure data accuracy, completeness, and integrity for source data ingested into the Bronze layer of our data platform. This role focuses on data profiling, validation, reconciliation, and source-to-target analysis across core banking domains.

You will work with business, finance, data engineering, and technology teams to validate ingestion outcomes, document data lineage, and implement data quality