Business Data Analyst
EXL (company site, opens in a new tab)5–8 yrsPuneHybridDirect career pageEst. 12–20 LPA
Posted on 28 Sept
Reach people at EXL
People at this company you can reach
Log in to see who works here
Create a free account or log in to see the people at EXL you could write to:
- Recruiters & HR
- People in this function
- Work addresses
Your match
Against your primary resume
Log in to see your match score
Create a free account or log in to unlock your CV match score across:
- Role fit
- Experience
- Industry relevance
Protocol Intelligence
How competitive this role is
Competition
Background fit
Strictness
Log in to see why each signal reads the way it does.
Job description
Structured overview of role & requirements
About This Role
- Translate business requirements from Finance, Risk, and Regulatory teams into scalable data mart designs for banking data domains.
- Design and develop subject-oriented dimensional data marts and data models optimized for regulatory reporting and analytics.
- Ensure data quality, reconciliation, lineage, and governance compliance across enterprise platforms like Oracle and Netezza, including testing and validation for data mart releases.
Minimum Requirements
- 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.
- Strong expertise in SQL, data warehousing/data mart design (star/snowflake schema), and ETL/ELT tools (e.g., Informatica).
- Experience with enterprise databases such as Oracle or Netezza and familiarity with data reconciliation, control totals, and validation processes.
Ideal Candidate Profile
- Experience working closely with Finance, Risk, and Regulatory stakeholders to translate and implement business requirements into technical solutions.
- Proven ability to manage data lineage, governance, and regulatory standards compliance (e.g., BCBS 239, SOX).
- Operational expertise in agile delivery cycles including sprint planning, UAT, defect management, and interfacing between business and technical teams.