Key Responsibilities:

- Design, develop, and maintain ETL/ELT pipelines to ingest data from core lending systems, LOS, LMS, CRM, and finance systems into AWS Redshift.

- Build and optimize data warehouse models (fact and dimension tables) for housing finance analytics.

- Develop data models supporting loan lifecycle data including applications, sanctions, disbursements, repayments, foreclosures, NPA, and write-offs.

- Write and optimize complex SQL queries in MySQL and Redshift for performance and scalability.

- Implement incremental loads, CDC, batch processing, and reconciliation checks for financial data.

- Ensure data accuracy, completeness, and consistency, especially for regulatory and MIS reporting.

- Optimize Redshift performance using distribution styles, sort keys, and query tuning.

- Support and create Tableau dashboards for business MIS, portfolio monitoring, collections, credit, and management reporting.

- Collaborate with Risk, Finance, Compliance, Operations, and Business teams to understand reporting and analytics requirements.

- Monitor and troubleshoot ETL jobs and data pipeline issues.

- Maintain detailed technical and functional documentation.

- Ensure adherence to data security, audit, and compliance standards relevant to NBFCs.