Data Analyst – Banking Data Ingestion & Reconciliation
Summary
Data Analyst responsible for validating and reconciling banking data ingested into raw data layers, ensuring accuracy and integrity for downstream use.
Key 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 record counts, balances, control totals, field-level comparisons, duplicates, null values, data types, and business-rule validations.
- Investigate and analyze data discrepancies between source systems and the target data platform.
- Identify root causes of data quality and reconciliation issues and work with data engineering and source-system teams to resolve them.
Required Experience
- 6 years of experience in data analysis within the banking or financial services industry.
- Demonstrated hands-on experience in data profiling and source-to-target reconciliation, particularly for source-to-Bronze or similar raw data ingestion layers.
Degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, Engineering, or a related discipline. Experience working on large-scale banking data transformation, modernization, or data platform programs. Exposure to data governance, data quality frameworks, financial controls, or regulatory reporting environments. Understanding of medallion architecture.