Data Operations Counterparty Management Analyst

About Citco:

The market leader. The premier provider. The best in the business. At Citco, we’ve been the front-runner in our field since our incorporation in 1948 led to the evolution of the asset servicing sector itself. This pioneering spirit continues to guide us today as we innovate and expand, push beyond the boundaries of our industry, and shape its future. From working exclusively with hedge funds to serving all alternatives, corporations and private clients, our organization has grown immensely across asset classes and geographies. For us, this progress is a pattern that we’ll only maintain as we move forward, always prioritizing our performance. So for those who want to play at the top of their game and be at the vanguard of their space, we say: Welcome to Citco.

About the Team & Business Line:

Fund Administration is Citco’s core business, and our alternative asset and accounting service is one of the industry’s most respected. Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience.

Position Overview 

The successful candidate will be part of the Counterparty Management Team whose responsibility will be to manage all aspects for currently supported reconciliations commencing with ensuring all counterparty account requirements are addressed, sourcing data, inclusive of rec and statements, and addressing daily production support issues.

 The Analyst will be responsible for requesting and following up on all data requests between parties, and insuring that all needed information is obtained on a timely basis. He or she will be responsible to self manage their workload, meet and report on deadlines to managers, and provide feedback to other departments on availability for the purpose of managing internal and external expectations around world. 

The Analyst will collaborate with tech and dev teams to ensure smooth roll out of functionality, testing and optimization of performance including use of API to capture broker data.

The Analyst should perform data analysis on incoming data, providing metrics and feedback on timing and data quality.

n will require the ability to effectively building and maintain strong working relationships between CFS and Prime Brokers, Counterparties, and Banks. 
 

Main Job Functions/Responsibilities

Supporting Reconciliations

• Collectively, the Counterparty Management team is responsible for ensuring that data/file / statements delivery is established and is flowing as expected when new interfaces are implemented or new clients go live.
• Based on requests from Internal Operations and Integration Staff, manage onboarding onto the reconciliation tools.
• Work collaboratively to establish expected delivery dates, and effectively manage expectations with internal operations staff. 
• Work collaboratively with the Data Management team to effectively hand off data files and statements that require monitoring for all reconciliation tools. This should include transferring knowledge of all auxiliary processes that require monitoring to ensure data successfully interfaces to the reconciliation tools e.g. replication.
• Escalation point for all reconciliation issues where data content discrepancies are encountered. Assist when external interaction is necessary.
• Ensure that any reconciliation or broker data issues that are raised are addressed timely.

ETL/Data Mapping/Data Analysis

• Core duties include mapping externally provided files into the Normalized Data Container (NDC) and the Xceptor ETL tool
• SQL knowledge is required (this can be learned) in order to create logic to translate broker-specific files into the normalized values required in the Normalized Data Container.   
• Ensure client data is flowing as expected when new interfaces are implemented and new broker feeds are added.   
• Analyze files and validate that all product/ asset class specific data is being provided. 
• Interpret business logic to define and translate data mappings; QA test and validate output using a suite of mapping tools and downstream target applications. 
• Ensure successful delivery and customer satisfaction as well as management of service expectations including work products, timing, and value to be delivered. 
• Create, maintain and enhance a repeatable process to ensure a quality experience for each client of Citco. 

Working with Counterparties

• Liaise with counterparties where data (on files or statements) delivered is not accurate or incomplete. Where necessary undertaking small mapping tweaks to address reconciliation data issues.
• Proactively work with counterparties to obtain new files / statements according to new Industry s