Business Data Analyst

Role: Business / Data Analyst 
Experience: 5-8 Years 
Location: Pune, Gurgaon, Bangalore 
Work Mode: 5 days’ work from office 
Key Role and 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 

• Design and develop subject-oriented data marts (Finance, Risk, Regulatory Reporting) 

• 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-off for data mart releases 

• Act as a bridge between business stakeholders and technical teams 

Must Have: 

• Strong understanding of banking data domains (Finance, Risk, Regulatory Reporting) 

• Expertise in data warehousing and data mart design (star/snowflake schema) 

• Advanced SQL skills (query optimization, performance tuning) in TOAD, etc 

• Hands-on experience with ETL/ELT tools (Informatica, etc) 

• Experience working with databases such as Oracle, Netezza, or similar platforms EXL Service 

• Strong knowledge of data reconciliation, controls, and validation frameworks 

• Familiarity with data lineage and governance practices 

• Understanding of file-based and API-based data integration Preferred Skills (Good to Have) 

• Exposure to BCBS 239, CCAR, Basel, or other regulatory frameworks 

• Experience with cloud data platforms (AWS, Azure, GCP) 

• Familiarity with BI/reporting tools (Tableau, Power BI) 

Education: Bachelor’s degree in computer science, Information Technology, Finance, or related field

 • 5–8 years of experience in banking data, data warehousing, or data engineering roles EXL Service