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