Analyst, Reference Data & Security Master
Core
Design and maintain a unified Security Master database serving as the single source of truth for equity, fixed income, and derivatives reference data across S&P Dow Jones Indices products.
Role type
Senior data analyst (financial reference data)
Builds
Unified Security Master database and data quality frameworks
Domain
Financial services / Index data
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL, Python programming, Data modeling, Database technologies (SQL Server, Oracle, PostgreSQL), Corporate actions processing, Data quality automation
Preferred skills
Financial services domain knowledge (securities, trading, investment management), Cloud data platforms (Databricks, Snowflake, Azure Data Factory), ETL tools (Power Automate, Informatica, Talend), Financial data standards (ISIN, CUSIP, SEDOL)
Technologies
SQL, Python, SQL Server, Oracle, PostgreSQL, Databricks, Snowflake, Azure Data Factory, Power Automate, Informatica, Talend
Responsibilities
Design and maintain the unified Security Master database; Develop and implement robust data quality frameworks including automated validation and reconciliation; Process and integrate complex corporate actions; Build and optimize complex SQL scripts and Python automation tools; Collaborate with index calculation, product development, and client support teams; Lead process improvement initiatives to enhance operational efficiency.
Seniority
Mid-Senior, hands-on IC
