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
Skills Required
- Bachelor's degree in Computer Science, Information Technology, Finance, or a related field
- 5–8 years of experience in banking data, data warehousing, or data engineering roles
- Strong understanding of banking data domains, including Finance, Risk, and Regulatory Reporting
- Expertise in data warehousing and data mart design, including star and snowflake schemas
- Advanced SQL skills, including query optimization and performance tuning
- Hands-on experience with ETL/ELT tools such as Informatica
- Experience 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
- Exposure to BCBS 239, CCAR, Basel, or other regulatory frameworks
- Experience with cloud data platforms such as AWS, Azure, or GCP
- Familiarity with BI and reporting tools such as Tableau or Power BI
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
