Data Analyst, Stewardship

DRW is a diversified trading firm that combines sophisticated technology and experienced people to operate across global financial markets. The Data Analyst, Stewardship will provide production support for EOD valuation and reference data, investigate and resolve data issues, and collaborate with engineering and Data Management teams to improve data workflows and controls.

Responsibilities:

• Monitor and support the production of EOD valuation data and reference data used for PnL, including coverage during evening hours to bridge global support windows
• Respond to global requests via Slack and email to create, update, and troubleshoot financial instrument reference data
• Investigate and explain why and how data appears the way it does — tracing issues back through source systems, feeds, and business logic
• Diagnose data problems quickly under pressure and build ad-hoc scripts or tooling to resolve them
• Work across reference data and valuation data stores and related reference data tooling
• Escalate and collaborate with engineering and other Data Management teams on systemic issues

Requirements:

• Proficiency in SQL and Python, with hands-on experience troubleshooting data issues or writing ad-hoc scripts to fix problems quickly, standing up tactical fixes in a scheduling environment, building data quality metric reports, and comfortable accessing different types of data storage and file formats
• You should be comfortable with financial instruments and markets well enough to understand what the data represents, particularly for futures, options, and crypto on all asset classes across global exchanges
• Calm under pressure, with strong critical thinking — able to assess the real impact of a request or problem and respond with the right level of urgency and context to pull in the correct teams
• Comfortable fielding requests from a global, technical user base across Slack and email, and explaining data behavior clearly to non-technical and technical audiences alike
• Experience building data governance rules/controls and writing runbook procedures for resolving support issues
• Familiarity with Oracle SQL, Python (requests, pandas, numpy, pyplot, and spark libraries), Bloomberg back-office-files, S3/Athena, Bloomberg Terminal and Bloomberg's Excel API plug-in is helpful
• exposure to solving problems/workflows using AI CLI, Airflow scheduling, is a bonus