Data reconciliation - Capital Markets

Job description

**TCS BPS is hiring for Data Reconciliation Analyst – Capital Markets @ Tata Consultancy Services @TCS Nagpur** Kindly go through the norms below and apply only if its relevant for **Job Role:** Data Reconciliation Analyst **Job Location:** Nagpur **Experience required:** 4- 8 Years **Key Responsibilities:** - Transaction-Level Reconciliation: Perform end-to-end reconciliation for transactions with and without offsets, including Buy/Sell trades, Cash movements (Dividends, Interest, Gains, Return of Capital/Principal), Expense postings and internal journals, Corporate Actions (Stock Splits, Reverse Splits, Spin-Offs, Mergers, Expirations, Assignments). Validate offsets for reinvested dividends, gains, and other complex events. - Corporate Action Processing: Scrub and validate corporate action events such as Stock Split / Reverse Stock Split, Spin-Off In/Out, Merge In/Out (Exchange and Non-Exchange), Dividend Reinvestments (Qualified/Non-Qualified), Expired / Assigned Options. Ensure accurate posting and reconciliation of corporate action transactions across systems. - Break Analysis & Resolution: Investigate breaks arising from mismatched positions, cash balances, or transaction offsets. Collaborate with Front Office, Middle Office, and Finance teams to resolve discrepancies within SLA. - Sign-Off & Reporting: Complete daily sign-off for reconciliations across positions, cash, transactions, and corporate actions. Provide commentary on unresolved breaks and escalate as per governance framework. - Process Optimization & Automation: Identify opportunities for automation and process improvement in reconciliation workflows. Support User Acceptance Testing (UAT) for reconciliation tools and enhancements. Contribute to continuous improvement initiatives to enhance efficiency and accuracy. **Technical Skills Required:** - Strong understanding of Capital Market instruments: Equities, Fixed Income, Derivatives. - Expertise in transaction types and offset logic, including Buy/Sell (with and without offsets), Dividend to Cash / Dividend Reinvested, Corporate Actions (Stock Split, Reverse Split, Spin-Off, Merge In/Out, Expirations, Assignments), Gains (Short/Long Term) to Cash or Reinvested, Interest Paid/Receivable, Internal Journals and Expense Postings. - Familiarity with reconciliation tools, data scrubbing techniques, and exception management. - Advanced Excel (Pivot Tables, VLOOKUP, Macros); SQL/VBA preferred. - Ability to interpret and apply offset logic for complex transaction scenarios.