Data Reconciliation Analyst Job in Nagpur at Tata Consultancy Services

Tata Consultancy Services is hiring for the role of Data Reconciliation Analyst!

Responsibilities of the Candidate:

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

Requirements:

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