Job Description: We are seeking a Business / Data Analyst with Data Engineering expertise to support the design and development of banking data marts for regulatory reporting, analytics, and downstream consumption. The role will focus on translating business requirements into scalable data models, ensuring data quality, reconciliation, and traceability across enterprise data platforms.

Key Responsibilities

Business & Data Analysis
Engage with business stakeholders (Finance, Risk, Regulatory teams) to gather and document data mart requirements:
Translate requirements into data mappings, transformation logic, and business rules:
Define KPIs, metrics, and regulatory data elements(e.g., capital, liquidity, exposure)
Perform data profiling and analysis to identify gaps, inconsistencies, and anomalies:
Build dimensional data models (fact/dimension tables)optimized for analytics and reporting and create ER Diagram
Work with enterprise platforms such as Oracle, Netezza, or cloud data warehouses:
Optimize queries and data structures for performance and scalability:




Define control totals, data validation rules, and exception handling mechanisms:
Document and maintain data lineage (source to report)at table and column level
Support integration with lineage/governance tools (e.g., MANTA, Collibra)
Ensure adherence to data governance policies and regulatory standards(BCBS 239, SOX, etc.)
Maintain metadata, data dictionaries, and transformation documentation:
Work closely with data engineers, architects and business users:
Participate in Agile delivery cycles (sprint planning, UAT, defect management):
Ensure proper testing, validation, and sign-offfor data mart releases
Act as a bridge between business stakeholders and technical teams
Required Skills:
Solid understanding of banking data domains(Finance, Risk, Regulatory Reporting)
Expertise in data warehousing and data mart design (star/snowflake schema):
Advanced SQL skills(query optimiza

📌 Business Analyst Gurugram
🏢 EXL Service
📍 Gurugram