# Associate Index Calculation and Distribution Specialist (ICAD Specialist)

**Company**: S&P Dow Jones Indices
**Location**: Mexico City
**Job type**: full-time
**Category**: Finance
**Industry**: Finance

**Apply**: https://spgi.wd5.myworkdayjobs.com/en-US/SPGI_Careers/job/Mexico-City-MX/Associate-Index-Calculation-and-Distribution-Specialist_331038-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_cb1e0cfe-c72

## Description

The Index Calculation and Distribution Team within the Global Index Management & Production Group (IMPG) is looking for an Associate ICAD Specialist to support the day-to-day maintenance of a wide range of S&P Dow Jones (S&P DJI) branded equity indices.

The Associate ICAD Specialist will focus on supporting the day-to-day calculation and production of a vast range of equity indices tracked by numerous listed products. The role involves solving non-routine problems in a timely manner, running various Quality Assurance (QA) validations for Global indices, monitoring real-time index calculation and distribution channels, and producing end-of-day index values.

Responsibilities:

- Calculate S&P DJI branded indices daily, ensuring timely and accurate delivery of real-time and end-of-day index data to clients and end users.

- Run QA validations to ensure accuracy and integrity of index values distributed to clients.

- Monitor real-time calculation and distribution of global indices, investigating system alerts, price movements and index value changes.

- Monitor various underlying component indices used in multi-asset methodologies for any updated values and recalculate where necessary.

- Work in close coordination with technology and production support groups to further automate system capabilities and troubleshoot production issues.

- Manage and maintain key relationships with other groups within the department and across other departments.

Requirements:

- Bachelor's degree or equivalent in Business, Mathematics, Economics, IT, or Finance preferred.

- Strong understanding of financial markets, asset classes and company fundamentals.

- Excellent analytical and quantitative capabilities to solve original problems.

- Ability to understand complex spreadsheet models and calculation algorithms.

- Strong working knowledge of analytical applications such as Microsoft Excel, and various data vendor tools.

- Experience with Python, SQL, and VBA would be beneficial.

- Ability to learn quickly, multi-task and work in a fast-paced environment.

- Excellent written and verbal communication skills in English.

Benefits:

- Health & Wellness: Health care coverage designed for the mind and body.

- Flexible Downtime: Generous time off helps keep you energized.

- Continuous Learning: Access a wealth of resources to grow your career.

- Invest in Your Future: Competitive pay, retirement planning, and financial wellness programs.

- Family Friendly Perks: Benefits for partners and little ones.

- Beyond the Basics: Retail discounts and referral incentive awards.

## Skills

### Required
- Microsoft Excel
- analytical applications
- Python
- SQL
- VBA
- data vendor tools

### Nice to have
- coding/automating spreadsheet calculation models

---

Source: [Apply at spgi.wd5.myworkdayjobs.com](https://spgi.wd5.myworkdayjobs.com/en-US/SPGI_Careers/job/Mexico-City-MX/Associate-Index-Calculation-and-Distribution-Specialist_331038-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)