Associate Index Calculation and Distribution Specialist

spgi

México

Remote

MXN 420,000 - 640,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

We are seeking an Associate ICAD Specialist at S&P Global Dow Jones Indices in Mexico City to support day-to-day calculation and production of a broad range of equity indices. You will perform QA validations, monitor real-time index calculations, and ensure timely dissemination of end-of-day values to clients across multiple platforms.

The role requires strong analytical skills, proficiency with Excel, and programming familiarity (Python/SQL/VBA).

Qualifications

  • Bachelor's degree or equivalent in Business, Mathematics, Economics, IT, or Finance preferred.
  • Strong understanding of financial markets.
  • Must be able to demonstrate excellent analytical and quantitative capabilities to solve original, non-routine problems in a timely and insightful manner.
  • Must be able to understand complex spreadsheet models and calculation algorithms.
  • Strong working knowledge of analytical applications such as Microsoft Excel, and various data vendor tools including Reuters and FactSet would be a plus.
  • Experience with Python, SQL, and VBA would be beneficial, preferably coding/automating spreadsheet calculation models
  • Ability to learn quickly, multi-task and work in a fast-paced environment
  • Excellent written and verbal communication skills in English

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 user
  • Run QA validations to the ensure accuracy and integrity of the index values distributed to clients
  • Monitor real-time calculation and distribution of global indices, investigating system alerts, price movements and index value changes where appropriate and resolving in a timely manner
  • Monitor various underlying component indices used in multi-asset methodologies for any updated values and recalculate where necessary, escalating to the respective Index Committee, where dictated by S&P DJI policy
  • Work in close coordination with the technology and production support groups in order to further automate, enhance our system capabilities and troubleshoot production issues
  • Manage and maintain key relationships with other groups within the department and across other departments, particularly Client Coverage, Index Services and IT Support

Skills

Analytical thinking
English communication
Problem solving

Education

Bachelor's degree in Finance/IT/Math

Tools

Excel
Python
SQL
VBA
Reuters
FactSet

Job description

About the Role:

Grade Level (for internal use): 09 The Role: Associate Index Calculation and Distribution Specialist (ICAD Specialist)

The Team: The Index Calculation and Distribution Team within the Global Index Management & Production Group (IMPG).

The Impact:

The team is looking for an Associate ICAD Specialist to support the Index Management & Production Group (IMPG) in the Americas region. The ICAD Team performs a crucial operational function within IMPG and is ultimately responsible for supporting the day-to-day maintenance of a wide range of S&P Dow Jones (S&P DJI) branded equity indices, with a particular focus on daily operational processes and validations.

What is in it for you?

As an Associate ICAD Specialist, your work will focus on supporting the day-to-day calculation and production of a vast range of equity indices tracked by numerous listed products. The Associate ICAD Specialist must be able to solve non-routine problems on an on-going basis in a timely manner. They will be responsible for running various Quality Assurance (QA) validations for Global indices, monitoring real-time index calculation and distribution channels, as well as the timely production of end-of-day index values for both spreadsheet based and system-calculated indices, and their dissemination to clients.

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 user
  • Run QA validations to the ensure accuracy and integrity of the index values distributed to clients
  • Monitor real-time calculation and distribution of global indices, investigating system alerts, price movements and index value changes where appropriate and resolving in a timely manner
  • Monitor various underlying component indices used in multi-asset methodologies for any updated values and recalculate where necessary, escalating to the respective Index Committee, where dictated by S&P DJI policy
  • Work in close coordination with the technology and production support groups in order to further automate, enhance our system capabilities and troubleshoot production issues
  • Manage and maintain key relationships with other groups within the department and across other departments, particularly Client Coverage, Index Services and IT Support
What we are looking for:
  • Bachelor's degree or equivalent in Business, Mathematics, Economics, IT, or Finance preferred.
  • Strong understanding of financial markets, asset classes and company fundamentals.
  • Must be able to demonstrate excellent analytical and quantitative capabilities to solve original, non-routine problems in a timely and insightful manner.
  • Must be able to understand complex spreadsheet models and calculation algorithms.
  • Strong working knowledge of analytical applications such as Microsoft Excel, and various data vendor tools including Reuters and FactSet would be a plus.
  • Experience with Python, SQL, and VBA would be beneficial, preferably coding/automating spreadsheet calculation models
  • Ability to learn quickly, multi-task and work in a fast-paced environment
  • Excellent written and verbal communication skills in English
About S&P Global Dow Jones Indices

At S&P Dow Jones Indices, we provide iconic and innovative index solutions backed by unparalleled expertise across the asset-class spectrum. By bringing transparency to the global capital markets, we empower investors everywhere to make decisions with conviction. We're the largest global resource for index-based concepts, data and research, and home to iconic financial market indicators, such as the S&P 500 ® and the Dow Jones Industrial Average ® . More assets are invested in products based upon our indices than any other index provider in the world. With over USD 7.4 trillion in passively managed assets linked to our indices and over USD 11.3 trillion benchmarked to our indices, our solutions are widely considered indispensable in tracking market performance, evaluating portfolios and developing investment strategies.

S&P Dow Jones Indices is a division of S&P Global (NYSE: SPGI). S&P Global is the world's foremost provider of credit ratings, benchmarks, analytics and workflow solutions in the global capital, commodity and automotive markets. With every one of our offerings, we help many of the world's leading organizations navigate the economic landscape so they can plan for tomorrow, today. For more information, visit www.spglobal.com/spdji .

What's In It For You?
Our Mission:

Advancing Essential Intelligence.

Our People:

We're more than 35,000 strong worldwide-so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all.From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Associate, Americas Corporate Action
Senior Associate, Americas Corporate Action

S&P Global Inc. • Ciudad de México

Hybrid
MXN 900,000 - 1,300,000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Associate , Equity Data Operations
Associate , Equity Data Operations

S&P Global Inc. • Ciudad de México

On-site
MXN 300,000 - 420,000
Health & Wellness benefits
Flexible downtime
Continuous learning opportunities
+3
Summer Intern, Quantitative Modeling
Summer Intern, Quantitative Modeling

7033 GRUPO SPGI MEXICO S. DE R.L. DE C.V. • Ciudad de México

On-site
MXN 112,000 - 167,000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Summer Intern, Quantitative Modeling
Summer Intern, Quantitative Modeling

S&P Global Inc. • Ciudad de México

On-site
MXN 112,000 - 201,000
Health & Wellness benefits
Client Services Associate
Client Services Associate

S&P Global Inc. • Ciudad de México

Hybrid
MXN 300,000 - 380,000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Finance Analyst
Finance Analyst

S&P Global Inc. • Ciudad de México

On-site
MXN 324,000 - 396,000
Health care
Flexible time off
Continuous learning
+3
Global Equity Data Operations Associate
Global Equity Data Operations Associate

S&P Global Inc. • Ciudad de México

On-site
MXN 300,000 - 420,000
Health & Wellness benefits
Flexible downtime
Continuous learning opportunities
+3
Index Production & QA Specialist
Index Production & QA Specialist

spgi • Mexico

Remote
MXN 420,000 - 640,000
Senior ML Engineer
Senior ML Engineer

S&P Global Inc. • Ciudad de México

Hybrid
MXN 900,000 - 1,500,000
Health care coverage
Flexible downtime
Continuous learning
+3
Real Time Index Production Senior Associate
Real Time Index Production Senior Associate

MSCI Inc • Monterrey

On-site
MXN 900,000 - 1,400,000