Business Data Analyst

EXL Service

---

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
• 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