Long applicationsign-up on Oracle

Business Data Analyst

EXL • Bachelor's Degree • SQL • Tableau • Power BI • ETL/ELT • Informatica • Dimensional Modeling • Collibra • 5 days ago

Apply now

Similar jobs

1,115,425open jobs

64,401companies

189,702added this week

Browse all

Salary

≈ $16k – $31k per year (Estimated)

Location

In office (Pune)

Seniority

Senior · 5+ years exp

Confirmed on the employer's own hiring board on Oct 3, 2026. First seen by Alion on Sep 28, 2026. EXL scores B on the Alion truth index.

Overview

Company

Impact

Profile match

EXL

EXL, legally ExlService Holdings, is a data analytics, AI and digital operations company headquartered in New York that runs outsourced business processes and builds data and AI solutions for insurers, healthcare organisations, banks, media and retail companies. Founded in 1999 and listed on Nasdaq, it has more than 60,000 employees across six continents, with large delivery centers in Noida, Gurgaon, Pune, Bengaluru and Chennai and a newer AI hub in Dublin. It hires data scientists and data engineers, GenAI and MLOps engineers, analytics managers, solution consultants and client partners, plus talent acquisition, finance and medical coding staff.

exlservice.com • HQ: New York, United States • 5000+ employees • Est. 1999

Tech stack of EXL

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

Required Skills

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)

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

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

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

Free account

Stop reading job ads. Get the ones that fit.

One free account turns this page into a shortlist built around your stack, your level and your pay.

Match on every job. Stack, seniority, pay and location, scored against your profile.

1,115,425 open roles. Read straight off company career pages, refreshed every day.

Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.

3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.

Create a free account Continue with Google

Free forever. No card. Under a minute.

Your match

How well do you fit this role?

Two answers are enough for a real match. No account needed.

Check my fit

Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics

Similar stack

Same company

Pune

Business Analyst 1 hour ago

≈ $16k – $32k per year (Estimated) • Hybrid • 5+ years exp • Gurgaon

SQL

AI/ML

Copilot

ChatGPT

Management

Agile

Apply