Security Master Data Architect & Automation Analyst

S&P Global; Ciudad de México; Híbrido; MXN 900.000 - 1.200.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health & Wellness

Flexible Downtime

Continuous Learning

Invest in Your Future

Family Friendly Perks

Beyond the Basics

Descripción de la vacante

S&P Dow Jones Indices seeks an Analyst, Reference Data and Security Master to design and deliver a unified Security Master for equities, fixed income, and derivatives, defining canonical data models and lifecycle states. You will design the database, implement data quality frameworks, process corporate actions, and collaborate with index calculation and product teams.

This hybrid role in Mexico City requires strong SQL, Python, and English, with a passion for data integrity in fast-moving

Formación

• 5+ years of experience in financial services with knowledge of securities business, including equity markets, trading operations, or investment management.
• Advanced SQL skills with proven ability to independently build complex scripts for data extraction, transformation, and validation across large relational databases.
• Strong programming experience in Python for data automation, workflow development, and integration tasks.
• Deep understanding of database technologies (such as SQL Server, Oracle, or PostgreSQL) with experience in data modeling and performance optimization.
• Ability to work effectively in a hybrid environment in Mexico City with strong English communication skills (written and verbal).

Responsabilidades

• 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 innovative solutions for handling emerging security types and market structures

Conocimientos

5+ years experience

Advanced SQL

Python

Database knowledge

Financial services

Educación

Bachelor's degree or equivalent

Herramientas

SQL Server

Oracle

PostgreSQL

Descripción del empleo

S&P Dow Jones Indices seeks an Analyst, Reference Data and Security Master to design and deliver a unified Security Master for equities, fixed income, and derivatives, defining canonical data models and lifecycle states. You will design the database, implement data quality frameworks, process corporate actions, and collaborate with index calculation and product teams.

This hybrid role in Mexico City requires strong SQL, Python, and English, with a passion for data integrity in fast-moving