Team Lead, Reference Data

Job Description

Job Purpose

The primary purpose of this position is to research, analyze, interpret, transform and present reference data for equities and funds securities.

The Equities and fixed income 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

• Conduct root cause analysis for large-scale client inquiries to determine causation and develop solutions.
• Conducts in-depth analysis and review of work conducted by junior members of the team to identify both individual and systemic data problems.
• Assists in the planning and coordinating of work assignments for the team and across teams.
• Work with internal stakeholders including business analysts, IT, product management and customer service teams to identify and implement process improvements as needed.
• Create business rules for complex excel and macro functions to organize, analyze, convert and create reference data.
• Increase knowledge of content sets supported by other RDO teams from both database and product perspectives
• Create business rules for SQL and Python queries with medium complexities to identify erroneous data and to build data quality / quality control reports.
• Analyze content to identify data gaps and erroneous data that when fixed, will have a significant impact on reference data clients.
• Monitor government regulations and identify new market trends creating new processes and new reference data needs required to satisfy the changing market
• Participate in the hiring process for the team and work with the manager of the team, recruiting and HR teams to ensure that the onboarding process is consistent and adheres to ICE policies and procedures.
• Manage the day-to-day operations of a team of 10-20 individuals responsible including motivating, mentoring and coaching team members.
• Set priorities for the group when multiple priorities exist.
• Ensure all work product is completed on time and in an accurate fashion; required work varies because of both economic and seasonal causes and due to shifts in resource availability.
• Conduct manager roles and responsibilities when the manager is out of the office
• Participant in manager training initiatives to continue personal development.

Knowledge And Experience

Skills Required

Excel, Python, Sql