Data Analyst

Key Responsibilities

• 10+ years of experience as a Data Analyst / Techno-functional Analyst, with meaningful exposure to commercial banking or BFSI data. Analyze and validate commercial banking data (loans, deposits, credit risk, trade finance) flowing into the Enterprise Data Warehouse from core banking and upstream source systems.
• Perform SQL-based data profiling, data quality checks, validation, and reconciliation to ensure accuracy and consistency across EDW and downstream reporting layers.
• Design and maintain source-to-target mappings, data flow diagrams, data models, and data dictionaries; translate business rules into SQL/ETL transformation logic.
• Collaborate with ETL/data engineering teams to define requirements for new commercial banking data feeds and troubleshoot data quality or pipeline issues.
• Support data governance practices — identifying and classifying PII/sensitive data, maintaining RoPA (Record of Processing Activities), and verifying masking, hashing, and encryption controls for downstream consumption.
• Support regulatory and compliance reporting (e.g., CCAR, Call Report, Basel/RBI equivalents, AML/Sanctions, Trade Finance compliance such as UCP 600/SWIFT messaging where applicable) by validating underlying EDW data used in submissions.
• Partner with Risk, Finance, Compliance, and Technology stakeholders to gather requirements, document business/functional specifications (BRD/FSD), and translate them into technical data solutions.
• Build or support BI dashboards and reports (Tableau/Power BI) for portfolio performance, risk, and regulatory monitoring.
• Participate in SIT/UAT, defect resolution, and production support for EDW and reporting releases; prepare change management and governance documentation.
• Maintain data lineage, retention, and archival documentation in line with enterprise data governance and audit standards.