Core duties include mapping externally provided files into the Citco Normalized Data Container (NDC) tool and 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.
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.
Assist management to evolve and enhance set processes and procedures
Take a proactive approach to solving issues, display initiative and good example by contributing ideas for increased efficiencies and/or automation of the various support procedures
About You:
Bachelor or master level degree in accounting, finance, business, economics or other relevant professional designation (CFA, CGA, CMA, CA, CPA);
General knowledge of databases or experience using SQL Server (T-SQL) and/or Oracle is required. General ETL process experience
Any 1-4 years experience in Financial Services with an exposure Operations processing is preferred.
Product knowledge, Domestic, Global and OTC security markets, Fixed Income and derivative product knowledge.
Business Analyst experience is desired besides comfort with the Microsoft Office suite.
Ideal candidate has a strong understanding of financial products and strategies that a hedge fund might use.
Must possess excellent communication skills.
Good problem solving skills. Candidates are required to research problems reported by operations teams to determine if an actual problem exists or if additional training is required. When actual problem exists, they need to recommend a workaround until an actual fix to the problem is implemented.
Ability to explain technical concepts to users in terms that can be easily understood.
Experience working with data files is a must.
Hedge fund operations/ admin experience preferable, preferably with cash reconciliations