yoinka

Custody Portfolio Reconciliation Analyst

Citigroup

Bogota ColombiaMid
Sign in to applyVerified 1h ago
Location
Bogota Colombia
Work model
On-Site
Level
Mid
Posted
2h ago

Skills

PythonSQL

About this role

As a Custody Portfolio Reconciliation Analyst at Citi, you will play a critical role in safeguarding the accuracy and integrity of client and fiduciary securities and cash balances across local and international custodians within Citi's Securities Services business. Working from Colombia and collaborating daily with global teams, you will serve as a key operational control point — ensuring that discrepancies are identified, resolved, and escalated to protect Citi and its clients from financial and reputational risk. This is an opportunity for an early-career finance professional to build deep expertise in custody operations, capital markets, and financial controls within a global institution.

Responsibilities

Execute daily reconciliations of securities and cash positions for client and fiduciary accounts against local and international custodians, including centralized securities depositories such as Deceval, DCV, Euroclear, and Clearstream. Verify the consistency between internal accounting records and depository account statements to ensure balance integrity at all times. Investigate, document, and resolve reconciliation breaks and outstanding items, prioritizing resolution within established service level timeframes. Coordinate the timely escalation of unresolved discrepancies to Operations, Settlements, and Front Office teams, following defined escalation frameworks. Monitor the aging of outstanding items in balance sheet accounts, ensuring all entries are properly justified and supported for substantiation purposes. Prepare and deliver documentation, sample data, and reports required by internal and external audit teams and regulatory bodies, maintaining full process transparency. Produce and distribute daily, weekly, and monthly reconciliation status reports, tracking volume, resolution rates, and key performance and risk indicators for management review. Contribute to process improvement initiatives focused on automating repetitive reconciliation tasks and integrating AI productivity tools into daily workflows to reduce manual effort and error. Required qualifications & skills University degree in Economics, Business Administration, Accounting, Industrial Engineering, Finance, or a related field. Up to 2 years of experience in reconciliation, accounting, audit, operational control, or financial back-office functions. Advanced English proficiency with the ability to hold fluent spoken and written conversations with global counterparts, including teams based in India. Working knowledge of the Colombian securities market, including its structure, instruments, and regulatory framework. Intermediate to advanced Excel skills, including complex formulas, pivot tables, VLOOKUP/XLOOKUP, and conditional logic. Demonstrated ability to apply AI and digital productivity tools to optimize documentation, analysis, and operational workflows. Solid analytical attention to detail, with the capacity to identify subtle discrepancies across large volumes of financial data and communicate findings clearly to peers and management. Beneficial skills & qualifications Previous experience in the financial sector, including fiduciary services, securities brokerage, or capital markets operations. Familiarity with the operations and platforms of centralized securities depositories such as Deceval, DCV, Euroclear, or Clearstream. Basic to intermediate knowledge of SQL, Python, or R applied to data analysis or reconciliation automation. Experience with Excel macros or VBA for workflow optimization.

What we offer

Joining Citi's Securities Services team in Colombia means stepping into a global network where your day-to-day work has direct impact on the accuracy and reliability of client portfolios across markets. From your first day, you will gain real exposure to international custody operations, work alongside cross-border teams, and develop skills that are highly valued across the financial industry. Direct exposure to Citi's global Securities

Custody Portfolio Reconciliation Analyst at Citigroup, Bogota Colombia | Yoinka