Job Purpose
The position involves the design of new index and methodology prototypes and working with the quant and development teams for their implementation. Once the index is approved and coded for production, the position also requires the verification and checking that the correct rules have been applied to the new indices and the calculations are accurate. The position requires working with large amounts of data and analyzing and interpreting it, both at the index and underlying security level. Knowledge of Excel tools is a fundamental part of the job, as is knowledge of Python and SQL. Many tasks will be carried out using the ICE Index Platform, which will be learned on the job. Knowledge of equity and fixed income index calculation methodologies will be needed and will be acquired if not currently possessed.
Responsibilities
- Work with IDI product, R&D and quant teams to design and build bespoke and standard indices and prototypes to meet client demand
- Verification of new index builds and the validation of calculated data
- Work with Python and large spreadsheets including both index and securities data, using the tools needed for the corresponding analysis
- Analyze, interpret, and validate data and analytics both at the bond and index level
- Work with databases and carryout analysis using Excel tools and/or Python
- Assist IDI Operations team to design, build and productionize automated QC checks to streamline routine tasks
- Command of and use of the ICE Index Platform will be fundamental to carry many tasks, e.g. Index Constituents, Profiling tool, Data Download, Custom Index tool, etc. Learning about the Platform will be on the job
- Apply problem-solving skills to identify innovative work-flow efficiencies and process improvements resulting in increased accuracy levels
- Ad hoc research or data analysis to support IDI product team globally
Knowledge and Experience
- Undergraduate degree required, preferably in Math, Finance, Engineering, Physics or Technology
- 2+ years of relevant work experience
- Proficiency with Python and Microsoft Excel tools and formulas
- Good Windows Office skills for Word, PowerPoint, etc. are also required
- Familiarity with SQL
- Professional certificates such CFA/CIPM are also a plus
- Data science background or coursework a plus
- Strong analytical and judgment skills with the ability to comprehend complex materials and be able to connect the dots. Ability to distill large amounts of information into specific takeaways
- Good organizational skills, with the ability to work under stringent time constraints, multi-task and prioritize workload
- Familiar with common construction methodologies for equity and fixed income indices, and with index and portfolio analytics and associated systems
- Strong written and verbal communication skills in English are essential
- Excellent attention to detail and high degree of demonstrated decision-making and problem-solving skills
- Eagerness to learn and collaborate with others
- Personable and with the ability to work as a part of a team and independently in a fast paced, high pressured, fluid environment
