Senior Finance Data Analyst, SQL & Python BI

Drweng; Chicago (IL); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Annual bonus

Comprehensive benefits package

Job summary

DRW in Chicago seeks a Data Analyst - Business Intelligence to join the UP Data Management team. You will answer business questions with data and build durable reporting solutions across the trade lifecycle, interfacing with finance, trading operations, and engineering.

The role requires 5+ years in BI/data analysis, strong SQL and Python, and experience with financial data. Competitive salary and discretionary bonus accompany a comprehensive benefits package.

Qualifications

• 5+ years in a data analysis, business intelligence, financial reporting, or analytics engineering role.
• Advanced SQL — complex multi-table joins, aggregates, CTEs, and performance considerations.
• Python for data work — pandas, database connectivity, repeatable scripts.
• Experience with financial data: trades, positions, pricing, or references.
• Demonstrated care with accuracy.
• Clear written communication — explain methodology to non-SQL audiences.
• Bachelor's degree in a quantitative or technical field.
• Experience specifying requirements for engineering teams, or building BI tooling (Tableau, Power BI, or similar).
• Exposure to tax, VAT/GST, or regulatory reporting.

Responsibilities

• Build and run extracts against the firm's data stores to answer requests from the front office and other units like Tax and Legal.
• Drive improvements to market share reporting and analytics.
• Support quarterly and annual tax and regulatory inquiries across multiple global jurisdictions.
• Respond to audit, litigation, and class-action data requests, often under short turnaround.

Skills

Advanced SQL

Python

BI tools

Communication

Bachelor's degree

Education

Bachelor's degree in a quantitative or technical field

Tools

Tableau

Power BI

Job description

DRW in Chicago seeks a Data Analyst - Business Intelligence to join the UP Data Management team. You will answer business questions with data and build durable reporting solutions across the trade lifecycle, interfacing with finance, trading operations, and engineering.

The role requires 5+ years in BI/data analysis, strong SQL and Python, and experience with financial data. Competitive salary and discretionary bonus accompany a comprehensive benefits package.