Senior Reference Data Analyst

The primary purpose of this position is to research, analyze, interpret, transform and present reference data for Structured Finance securities as well as reference data pertaining to those issuers themselves that bring fixed income debt to market.

The fixed income and Equities market consists of over two million active securities and the reference data provided by ICE Data Services for said securities is used by our clients to make trading decisions, settle trades, make investment decisions, manage portfolios, analyze risk, create security master files, create client statements and conduct other back office functions. Our reference data is also used by internal stakeholders such as the Evaluated Pricing, Index and Analytics groups said reference data plays an integral role in determining evaluated prices, determining whether or not a security should be added to or deleted from an index or indices, the weighted average of a security within an index and, performing a series of analytical calculations that are used both internally within ICE and externally by these stakeholder’s clientele.

Responsibilities 

• Analyze, interpret, collate and transform reference data structures/events/sub-processes with higher complexity provided in a variety legal and financial documents, third party reports and vendor information while ensuring that the reference data provided in ICE’s products and services accurate, comprehensive and in a timely manner, namely best in class expanding subject matter expertise for additional structures and/or asset classes with minimal oversight from senior members of the team.
• Analyze discrepancies identified by Clients in reference data and conduct root cause analysis in a way to fasten the response to clients.
• Research and remediate the data discrepancies identified by Clients.
• Propose suggestions and enhancements to Product teams to change the mapping rules in the data delivery to the clients.
• Identify potential new sources of reference data to improve coverage, timeliness and accuracy. Present analysis and recommendations for use of new source(s) to team senior managers
• Identify trends and causation of inaccurate and/or incomplete data including but not limited to staying current with regulatory initiatives, new financing techniques used by the marketplace and organizations that impact coverage and completeness.
• Create more excel and macro functions to organize, analyze, convert and create reference data.
• Create charts, graphs and presentations for leadership teams.
• Mentor junior associates; provide guidance; serve as subject matter experts

• Build core competencies in the maintenance of reference data captured in alternate databases used to product products.
• Support client facing members of ICE Data Services by conducting analysis and providing responses as questions and challenges arise.
• Independently perform all assigned business processes completely and accurately.
• Participate in root cause analysis efforts to identify system data issues and participate in creating process improvements.
• Resolve complex data challenges and time critical sensitive projects.
• Conduct user acceptance testing of new enhancements and bug fixes made to the database(s) of record

Knowledge and Experience

• MBA in Finance, Economics or equivalent
• Proficiency with Microsoft Excel tools and formulas, VBA, Python or any other script language.
• Good Windows Office skills for Word, PowerPoint, etc. are also required.
• Demonstrate subject matter expertise levels for relevant markets and solid subject matter knowledge of related markets.
• Demonstrate ability to work autonomously.
• Demonstrate extensive knowledge and understanding of policies and procedures and work with training team to augment best practices as changes in the marketplace evolve.
• Demonstrate familiarity with reference data products to support client challenges and resolve data problems.
• Ability to work in a fast paced, high pressured, fluid environment
• Ability to distill large amounts of varied information into specific takeaways
• Excellent attention to detail and high degree of demonstrated decision-making and problem-solving skills
• Strong analytical skills
• Eagerness to learn and collaborate with others
• Strong excel skills required.