17 ago
|
S&P Global
|
Ciudad de México
17 ago
S&P Global
Ciudad de México
About the Role:
Grade Level (for internal use):
10
The Team:
The Equity Data value stream at S&P; Dow Jones Indices is a collaborative, detail-oriented team that takes pride in being the foundation for globally recognized financial products. We value precision, innovation, and cross-functional partnership as we manage critical data that powers flagship indices used worldwide. Our team thrives on solving complex data challenges and continuously improving processes to maintain the highest standards of data integrity in fast-moving financial markets.
Responsibilities and Impact:
The Analyst, Reference Data and Security Master is accountable fordesigning and delivering a unified Security Masterthat serves as thesingle source of truthfor security reference data across products. This includes defining thecanonical data model(IDs, classifications, instrument terms, listings/venues, issuer links, and lifecycle states), and ensuring it supportsEquities, Fixed Income, and Derivatives .
Responsibilities include:
- Design and maintain the unified Security Master database serving as the single source of truth for equity, fixed income, and derivatives reference data across all S&P; DJI products
- Develop and implement robust data quality frameworks including automated validation, auditing, and reconciliation processes to ensure 99%+ data accuracy and completeness
- Process and integrate complex corporate actions (mergers, acquisitions, splits, dividends) into the security master, ensuring timely and accurate reflection across downstream systems
- Build and optimize complex SQL scripts and Python automation tools to streamline data workflows and reduce manual processing time by 30%+ Collaborate with index calculation, product development, and client support teams to align security master capabilities with evolving business requirements and new product launches
- Lead process improvement initiatives to identify data gaps, enhance operational efficiency, and contribute to innovativ
📌 Analyst, Reference Data (Ciudad de México)
🏢 S&P Global
📍 Ciudad de México