Quick overview
Job description
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
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ON

FP&A Data Analyst Auto Apply
Onecom · Gurugram · On-site · Posted 5 Nov 2026 🇮🇳
SQLMicrosoft ExcelLooker+5TechnologySalary not listed - BH

Senior Data AnalystRecently posted Auto Apply
Blink Health · India · Hybrid · Posted 19 Nov 2026 🇮🇳
SQLTableauArticulate+3TechnologySalary not listed - WG
Associate Director | Analytics - Solutions | Banking and Financial ServicesRecently posted Auto Apply
WNS Global Services · Bangalore, KA · Hybrid · Posted 18 Nov 2026 🇮🇳
ETLKYCRegulatory Reporting+2FinanceSalary not listed - WG
REF113298U- Consumption data (Neilson, NIQ IQVIA)-Power BI, Advance Excel and Data Bricks, - Lead Associate-AnalyticsRecently posted Auto Apply
WNS Global Services · Gurgaon, HR · On-site · Posted 17 Nov 2026 🇮🇳
Microsoft ExcelSnowflakeProcess Improvement+2TechnologySalary not listed - NI
Principal Data Operations AnalystRecently posted Auto Apply
NielsenIQ · Gurgaon, HR · On-site · Posted 17 Nov 2026 🇮🇳
Stakeholder ManagementMicrosoft ExcelMicrosoft Office+2Operations & Project ManagementSalary not listed - B2
GCP Data Specialist - R01572732 Auto Apply
Brillio 2 · Bengaluru · Hybrid 🇮🇳
GCPSQLT-SQL+4Salary not listed - RS

Data AnalystRecently posted Auto Apply
Redwood Software · Hyderabad · Hybrid · Posted 17 Nov 2026 🇮🇳
SQLMicrosoft ExcelTableau+5TechnologySalary not listed - NI
Visualization AnalystRecently posted Auto Apply
NielsenIQ · Chennai, TN · On-site · Posted 16 Nov 2026 🇮🇳
Microsoft PowerPointGoogle WorkspaceFigmaOperations & Project ManagementSalary not listed - A2
Costing & Insights EngineerRecently posted Auto Apply
A2MAC1 · Chennai, Tamil Nadu · On-site · Posted 16 Nov 2026 🇮🇳
AssemblyCapacitorLean ManufacturingEngineeringSalary not listed - TI
Manager, Analytics, Fraud, UKRecently posted Auto Apply
Tide · Hyderabad · Hybrid · Posted 16 Nov 2026 🇮🇳
OnboardingSQLMicrosoft Excel+4Salary not listed - EU
Reporting Executive Auto Apply
Eurofins · Bengaluru, KA · On-site · Posted 13 Nov 2026 🇮🇳
TechnologySalary not listed - ON

Team Lead- Data and Analytics Auto Apply
Onecom · Gurugram · On-site · Posted 12 Nov 2026 🇮🇳
RecruitingStakeholder ManagementOnboarding+18Operations & Project ManagementSalary not listed
