Business Data Analyst
About the Role
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 Skills for This Role
Full Job Posting
Qualifications
- 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
- - 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
Responsibilities
- - 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
About EXL
EXL is a global data and AI company that provides analytics, digital operations, and industry-specific services to enterprises in insurance, healthcare, banking, retail, media, and energy.
Visit company websiteApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at EXL
Clinical Validation Auditor (CVA) Auditor III
, USA
Now Hiring: Clinical Validation Auditor (Fully Remote in US). Use your clinical expertise to make a real impact – all from the comfort of your home!
Assistant Manager - Coding Auditor
Chennai, IND
Coding Assistant Manager is responsible for APC & Professional Surgery Audit review. This includes leveraging advanced medical coding analysis, enforcing policy adherence, and driving overpayment recovery programs. Creat
Manager
, IND
Professionals in this group are expected to create new algorithms from scratch. They work with large data sets and relational databases and have excellent problem-solving skills and the ability to analyze issues, identif
Manager - Quality Excellence
Kochi, IND
Manager – Quality Excellence (Kochi) to lead quality governance and process improvement for a US Healthcare Client. Lean Six Sigma GB/BB preferred.
Technical Business Analyst – Underwriting Analytics
London, GBR
Clinical Validation Auditor (CVA) Auditor III
, USA
Engagement Manager (Personal Line Insurance)
London, GBR
Assistant Manager - Coding Auditor
Chennai, IND
Senior Executive
Bengaluru, IND
Manager
, IND
Business Analyst
Gurugram, IND
Manager - Quality Excellence
Kochi, IND