ROLE OVERVIEW
In the role of Reference Data Operations Analyst, the employee will be responsible for the following:
- Driving the highest quality reference data for trading, risk, and operations through the application of data quality techniques
- Develop and apply expertise in the interpretation of corporate actions impact on the Firm and on trading
- Supporting Risk and Financial engineers in the modeling of referential data to support analyses
- Responsible for the creation and ongoing maintenance of security set-ups which include but are not limited to Equities, Bonds, IRS, CDS, Listed Options, Forwards, and Exotic Derivatives (FRA’s, FVA,s Digital Options, Contingent Options, Worst of Options, etc…)
- Supporting various firm-wide stakeholders of Referential elements (Account Master, Broker Master, Charge Mgmt Tool, etc...) that enable trading, settlements, and reporting needs
- Working with vendors to source data on demand
- Working with IT development teams to build out new capabilities to streamline daily operations
- Responding to trader queries on positions and PNL showing in firm-wide systems
- Working with our Operations outsourcer on corporate action and security master queries
QUALIFICATIONS & REQUIREMENTS:
- In order to effectively represent the Company and communicate with clients, the employee must be someone who has:
- High levels of curiosity and is a self-starter and has proven this by coming up with ideas and enhancements to improve security master processes
- High levels of responsibility and organization and has been able to meet daily and ad-hoc initiatives
- Effective communication skills to ensure proper hand offs and escalation between team members
- Passion and drive for analyzing, researching, and resolving data issues using various tools
- An outgoing personality that has demonstrated to effectively work with people across risk, compliance, technology, front, middle, and back office.
EDUCATION, TRAINING & EXPERIENCE:
- Bachelors’ Degree in Finance or economics
- Minimum 3 years of relevant work experience, including specific experience outlined below is mandatory:
- Heavy data entry experience maintaining static/reference data primarily around security master data
- Minimum 3 years’ experience maintaining security master data for Equity, Fixed Income, Options, Credit Default Swaps, and Interest Rate Swaps.
- Minimum 3 years’ experience working resolving data quality exceptions and reconciliations
- Minimum 1 year experience using JIRA or similar Issue tracking system
- Added technical skills
- Has used Excel for 3 years effectively with financial services data
- Ability to run VLOOKUPS, HLOOKUP, COUNTS, SEARCHES and leverage Pivot tables to join, organize, and analyze data across large datasets
- Has used SQL Editor for 1 year with financial services data
- Ability to run SEARCH, JOIN, ORDER BY, and GROUP BY queries to analyze data across large db tables
- Proficient using Bloomberg Terminal and related functions
- Ability to use the terminal to research and analyze various BBG data points
- Ability to create formulas to pull data into Excel
- Understand various mechanisms BBG offers has to help drive automated security master processes
