Treasury BA

Capgemini; Chennai; Hybride; INR 900 000 - 1 400 000; Plein temps

Résumé du poste

Capgemini in Chennai seeks a Tech Solution Business Analyst to lead data sourcing, modelling and analysis supporting reporting, risk and P&L calculations for Treasury securities, bonds, equity and related assets. You will translate business needs into data requirements and collaborate with architects and quants to design robust data pipelines.

Responsibilities include creating data mapping documents, defining quality rules, supporting UAT and reconciliation testing, and ensuring governance and

Qualifications

• Translate complex business requirements into data requirements, data flows and models.
• Design and document data mapping, data dictionaries, and transformation rules.
• Define data quality rules and validation criteria for critical data elements.
• Support testing lifecycle including UAT and data reconciliation testing.

Responsabilités

• Lead data sourcing, modelling and analysis for reports, risk and P&L calculations.
• Collaborate with Data Architects, Data Engineers and Quants to build robust data pipelines.
• Ensure data lineage, governance and auditability for regulatory reporting.

Connaissances

Data analysis

Data modelling

Data governance

UAT testing

Stakeholder engagement

Description du poste

Tech Solution Business Analyst - Treasury/Risk Data & Analytics

• Lead the data sourcing, modelling, and analysis efforts to support reporting, risk, and P&L calculations for products including Treasury Securities, Bonds, Equity, Assets & Liabilities, and P&L.

• Translate complex business requirements for Market Risk Limits and Utilization, RWA, IM (Initial Margin) Posting, and Cashflow Hedge MI into clear Data Requirements, Data Flows, and Logical Data Models.
• Drive end-to-end data solutioning, focusing on data ingestion, transformation, quality checks, and aggregation necessary for accurate analytics and reporting.
• Collaborate extensively with Data Architects, Data Engineers, and Quants to design and implement robust, scalable data pipelines and analytical models.
• Identify opportunities to enhance data quality, lineage, and governance to improve the reliability of MI (Management Information) and regulatory reports.

Business Domain Expertise

• Deep understanding of the data attributes and lifecycle for Treasury Securities, Bonds, and Equity products, including market data (pricing, yield curves) and static data.
• Expertise in the data requirements for Market Risk Limits/Utilization and the associated risk metrics (e.g., VaR, Stress Testing).
• Solid knowledge of the underlying data needed for Cashflow Hedge MI (Hedge effectiveness, designation/dedesignation data) and IM Posting (exposure, collateral, margin calculations).
• Understanding of the data and calculations related to RWA and other regulatory capital frameworks.
• Familiarity with financial accounting concepts to ensure the accuracy of P&L (Profit & Loss) and Assets & Liabilities data reporting and reconciliation.

Execution & Delivery

• Create and manage detailed data mapping documents, data dictionaries, and transformation rules between upstream sources and the target analytical platform/data mart.
• Define data quality rules and validation criteria for critical data elements across all Treasury and Risk initiatives.
• Support the testing lifecycle, focusing on UAT and data-specific reconciliation testing to ensure the accuracy of analytics and reports.
• Align to the firms data governance and software delivery frameworks.

People and Talent

• Act as a subject matter expert on financial product data and its analytical use, guiding development teams and advising business stakeholders.

Risk Management & Governance

• Ensure the integrity and completeness of data used for regulatory reporting (RWA, Market Risk) and critical MI (Cashflow Hedge MI, P&L).
• Establish strong data governance practices within the delivery scope, ensuring clear data lineage and auditability.