Banking Data Analytics & Bronze Reconciliation Specialist

AMBITION GROUP SINGAPORE PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

AMBITION GROUP SINGAPORE PTE. LTD. seeks an experienced Data Analyst with strong banking domain knowledge to ensure data completeness and integrity for the Bronze layer of the data platform.

You will perform data profiling, validation, and source-to-target analysis across Management Accounting, Financial Accounting, Regulatory Reporting, and Transaction Banking. You will work with business, finance, data engineering, and technology teams to identify data quality issues, validate ingestion

Qualifications

• 6 years of experience in data analysis within the banking or financial services industry.
• Hands-on experience with data profiling and source-to-target reconciliation.
• Strong knowledge in at least one banking domain: Management Accounting, Financial Accounting, Regulatory Reporting, or Transaction Banking.
• Strong understanding of banking data, data structures, accounting concepts, and data quality controls.
• Experience investigating complex data discrepancies and performing root-cause analysis.
• Proficiency in SQL, Databricks/Spark, Python, and advanced Excel for data analysis and automation.

Responsibilities

• Perform detailed data profiling, validation, and reconciliation of source data loaded into the Bronze layer.
• Validate source-to-Bronze ingestion for completeness, accuracy, consistency, and integrity.
• Develop and execute reconciliation checks covering counts, balances, control totals, field-level comparisons, duplicates, null values, data types, and business rules.
• Investigate and analyze data discrepancies between source systems and the target data platform.
• Identify root causes of data quality and reconciliation issues and coordinate with data engineering and source-system teams to resolve.
• Analyze data across banking domains: Management Accounting, Financial Accounting, Regulatory Reporting, Transaction Banking.
• Translate business requirements into data validation and reconciliation rules.
• Create and maintain source-to-target mappings, data lineage documentation, reconciliation evidence, and data quality reports.
• Use SQL, Databricks, Spark, Python, notebooks, and Excel to perform large-scale data analysis and profiling.
• Build dashboards and visualizations using Power BI to communicate data quality, reconciliation results, trends, and key metrics.
• Collaborate with Finance, Risk, Regulatory Reporting, Transaction Banking, Data Governance, Data Engineering, and Technology teams.
• Support testing activities including data validation, SIT/UAT reconciliation, defect investigation, and production data verification.

Skills

Data profiling

Data reconciliation

SQL

Python

Excel

Power BI

Tools

Databricks

Apache Spark

Power BI

Excel (Advanced)

Notebook environments

Job description

AMBITION GROUP SINGAPORE PTE. LTD. seeks an experienced Data Analyst with strong banking domain knowledge to ensure data completeness and integrity for the Bronze layer of the data platform.

You will perform data profiling, validation, and source-to-target analysis across Management Accounting, Financial Accounting, Regulatory Reporting, and Transaction Banking. You will work with business, finance, data engineering, and technology teams to identify data quality issues, validate ingestion