Data Analyst - Business Intelligence

• →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

• Validate every extract before delivery — cross-foot detail against aggregates, reconcile against source systems, and investigate discrepancies rather than explaining them away
• Document the business rules behind each report, including who made the decision and why

• Identify patterns across incoming requests
• Partner with engineering teams to translate those patterns into durable solutions: reporting dashboards, self-service views, scheduled reports
• Write the specification: define the business logic, the edge cases, and the validation criteria that a tool needs to get right

• 5+ years in a data analysis, business intelligence, financial reporting, or analytics engineering role
• Advanced SQL — you are comfortable with complex multi-table joins, aggregation across different grains, CTEs, and reasoning about query performance.
• Python for data work — pandas, database connectivity, and building repeatable scripts rather than one-off notebooks
• Experience working with financial data: trades, positions, pricing, or reference data
• Demonstrated care with accuracy.
• Clear written communication — you'll be explaining methodology to accountants, lawyers, and auditors who don't read SQL
• 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

The annual base salary range for this position is $100,000 to $130,000 depending on the candidate’s experience, qualifications, and relevant skill set. The position is also eligible for an annual discretionary bonus. In addition, DRW offers a comprehensive suite of employee benefits including group medical, pharmacy, dental and vision insurance, 401k (with discretionary employer match), short and long-term disability, life and AD&D insurance, health savings accounts, and flexible spending accounts.