Data Analyst, Stewardship

Summary

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

Skills

• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 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

Benefits

• Eligible for an annual discretionary bonus
• Comprehensive suite of employee benefits including group medical, pharmacy, dental and vision insurance
• 401k with discretionary employer match
• Short- and long-term disability insurance
• Life and AD&D insurance
• Health savings accounts
• Flexible spending accounts
• Hybrid schedule; can sit in the Chicago or Houston office; remote may be possible for the right candidate