Reference Data Analyst

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