Fund Services.Senior Analyst
The Citco Group Limited
Ayala Ave, Manila , Philippines
4d ago

Company Overview

Citco Fund Services companies is the world's pre-eminent hedge fund administrator with over 40 years’ experience in the provision of administration and extended value-add services to hedge fund clients - many of whom are leading names in the industry.

Operating out of 19 strategic centers globally, our global presence reflects our philosophy to provide support wherever our clients are located.

This approach gives us an opportunity to utilize this global reach to ensure specific client needs are met on timely basis.

Citco Fund Services offer a full range of fund administration services and complete front-to-back offering for single manager funds, combining portfolio capture and real-time position monitoring technology, using the Æxeo Technology system, with middle and back office operations support.

The Citco Fund Services companies are the world's pre-eminent hedge fund administrators and have over 40 years experience in the provision of administration and other services to their hedge fund clients, many of whom are leading names in the industry.

Department Overview

Interface Solutions is responsible for all aspects of portfolio data exchange and support trade activity, pricing and position data.

The group has both an operational and a strategic mandate to fulfill. This is accomplished through a location strategy that combines presence in strategic locations close to our client needs and the utilization of standardization, centralization and scale in our operational Centre of Excellence (CoE) locations.

Team Overview

The Data Management Team creates, maintains, and monitors the successful and timely processing of inbound and outbound files for various CFS teams.

Through the monitoring of various data interfaces and platforms, the team ensures connectivity is always maintained and critical issues are immediately addressed.

Operational :

Configuration & maintenance of electronic interfaces that exchange inbound / outbound data to / from Citco applications.

Proactive monitoring of data flows end to end data is an integral pre-cursor to Citco’s service to clients.

Strategic :

Provide leadership in establishing standards & benchmark in the area of portfolio data interfaces - for Citco and the industry as a result.

Collaborate with Citco Technology to analyze, develop & enhance internal tools that support increased levels of automation and intuitive self-service for operations.

Position Overview

As a Data Management Support Analyst, the successful incumbent will work as part of a global team supporting several CFS systems and intermediary data interfaces and applications that facilitate data flow to and from these systems.

Working with a global team of Data Management Support Analysts, the successful candidate will be responsible for daily aspects of the trading lifecycle for CFS clients (Investment Managers, Hedge Funds, etc) located around the world.

Based on time zones, Data Management Support Team uses a follow-the-sun model to ensure 24 / 5 support that the appropriate operational tasks are completed.

Open tasks will be passed to the next shift in another time zone.

Strategic alignment and process improvement (50%)

Manage the Interface Solution’s NEXA dashboard, an SQL-based application

Extraction of data from Microsoft / Oracle SQL Servers & Third-party applications

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

Support management in identifying, analyzing and implementing process and system improvement initiatives.

  • Data analysis via Microsoft Excel
  • Tabulating & ensuring NO discrepancies
  • Sorting & interpreting usage data
  • Drafting & presenting data in monthly progress report to managers
  • Refine and automate regular processes, track issues, and document changes

    Interface with developers and application support with complex query tuning and schema refinement.

    Identify and drive initiatives aimed at reducing file delivery manual work, improving quality of feeds and reducing errors and alerts.

    Daily Operational Support (40%)

    Setup inbound / outbound file routing jobs in response to requests from internal and external business and technical teams

    Work with brokers, vendors and investment managers to setup FTP accounts and establish connectivity.

    Use key file delivery tools and dashboards to proactively identify failed and missing files and work with brokers, vendors and clients to address issues in a timely manner.

    Keep user community updated and manage their expectations by proactively providing regular updates about file issues, delays and ETAs.

    Respond to file alerts sent to the Data Management and ensure effective action is taken to address the issue highlighted by the alerts.

    Ad-hoc work as required (10%)

    This job description is not intended to be all-inclusive. The Employee may perform other related duties to meet the ongoing needs of the organization.

    Education, Qualifications and Experience

  • The candidate is required to have a bachelor’s Degree in Computer Sciences or related disciplines.
  • 3+ years MS SQL Server Administration experience required

    Previous exposure in the financial services industry or as a consultant to the financial services industry is preferred.

    Experience in an operational role is highly desirable.

    Must possess excellent oral and written communications skills.

    Experience in querying databases through use of SQL expert level required

    The candidate is required to have a bachelor’s Degree in Computer Science or related discipline

    Candidates must have demonstrated ability to work with both internal and external clients, vendors and brokers as well as developing good working relationships with each of these groups.

    Candidates must have the ability to explain difficult concepts to users in terms that they can easily understand.This should include developers, technical users and non-technical users.

    Candidates must have good organizational skills and have the ability to work on several work items simultaneously.

    Key Competencies

    Microsoft / Oracle SQL Servers experience

    VBA and experience in creating / maintaining macros would be an advantage

    Quality & Risk Control


    Working Hours and Location

    Mainly APAC / EMEA hours but is expected to report during NA hours if required

    Operational requirements will require staff to periodically support on weekends.

    Roles are open for both the Alabang and Makati offices.

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form