The Data Analyst - Business Intelligence role will join DRW's Unified Platform (UP) Data Management team. UP systems are responsible for data that spans the trade lifecycle: from research, execution, through to post-trade. Our business operations generate substantial data each day. Our global footprint produces inquiries from stakeholders that require complex answers. Questions can span years of data, multiple data stores and a variety of financial domains.
This is a reporting and analysis role at the intersection of finance, trading operations, and data engineering. The work is deadline-driven; your outputs go to regulatory authorities, external auditors, and firm leadership.
What You'll DoAnswer business questions with data- 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
Make the numbers trustworthy- 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
Reduce the recurring load- 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
What We're Looking ForRequired- 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.
[#LI-KS1]
