Data Analyst, Exploration

Unchain Data; Chicago, Northern (IL, KY); Hybrid; USD 100,000 - 120,000; Full time

Benefits offered by this job

Annual bonus

Comprehensive benefits

401k with employer match

Job summary

DRW, a Chicago-based trading firm, is seeking a Data Analyst, Exploration, to help onboard, manage and maintain datasets used by traders and quantitative researchers. You will collaborate with data strategists, data engineers and front-office teams to investigate complex data issues in a fast-paced environment.

Responsibilities include profiling new datasets, assessing data quality, curating data catalog entries, supporting lifecycle management with global teams, and aiding in data quality

Qualifications

• 1-2 years of relevant experience
• Strong foundational knowledge of financial instruments and market data symbology
• Proficiency with SQL and Python for exploratory data analysis (PySpark, pandas, numpy, Jupyter Notebooks)
• Ability to document and clearly explain complex data analysis findings
• Exceptional attention to detail and effective communication skills
• Ability to think both independently and collaboratively

Responsibilities

• Analyze new datasets to profile content and surface insights for data strategists and front-office stakeholders
• Collect metrics and analyze data quality across dimensions like completeness and timeliness
• Curate data catalog entries for discoverability
• Engage with global front office research teams to support datasets through their lifecycle
• Monitor and resolve production data issues across teams
• Identify opportunities to improve datasets and data management processes

Skills

SQL

Python

PySpark

Pandas

NumPy

Jupyter Notebooks

Data analysis

Data storytelling

Tools

AWS Athena

Amazon S3

Linux

Git

Apache Airflow

Bloomberg Terminal

Job description

About Us

DRW is a diversified trading firm with over 3 decades of experience bringing sophisticated technology and exceptional people together to operate in markets around the world. We value autonomy and the ability to quickly pivot to capture opportunities, so we operate using our own capital and trading at our own risk.

Headquartered in Chicago with offices throughout the U.S., Canada, Europe, and Asia, we trade a variety of asset classes including Fixed Income, ETFs, Equities, FX, Commodities and Energy across all major global markets. We have also leveraged our expertise and technology to expand into three non-traditional strategies: real estate, venture capital and cryptoassets.

We operate with respect, curiosity and open minds. The people who thrive here share our belief that it's not just what we do that matters–it's how we do it. DRW is a place of high expectations, integrity, innovation and a willingness to challenge consensus.

The Role

As a Data Analyst, Exploration you will play an integral role in all operational aspects of onboarding, managing and maintaining various datasets used by traders and quantitative researchers. You will work closely with a variety of stakeholders, including data strategists and data engineers, as well as teams across technology, operations, research, and risk management. You should be comfortable investigating complex data issues in a fast-paced environment.

Responsibilities

• Analyze new datasets to profile their content, identify collection and storage requirements for data engineering teams and proactively surface insights about the datasets for data strategists and front-office stakeholders
• Collect metrics and analyze datasets across different dimensions of data quality including completeness, validity, accuracy, timeliness, and consistency
• Curate data catalog entries to ensure our research data assets are accurately represented and easily discoverable
• Engage with global front office research teams to support datasets throughout their lifecycle, addressing content inquiries and managing communications with external data vendors
• Monitor and resolve production data issues while engaging key stakeholders across multiple teams and facilitating global support
• Assist the wider team by identifying opportunities to improve existing datasets and data management processes

Requirements

• 1-2 years of relevant experience
• Strong foundational knowledge of financial instruments and market data symbology, with an interest in developing further expertise in these areas
• Proficiency with SQL and Python for exploratory data analysis (PySpark, pandas, numpy, Jupyter Notebooks)
• Ability to document and clearly explain complex data analysis findings
• Exceptional attention to detail and effective communication skills
• Ability to think both independently and collaboratively

Nice to Have

• Experience with cloud services such as AWS Athena and Amazon S3
• Familiarity with Linux and basic Bash scripting skills
• Experience with version control tools such as Git
• Good understanding of data management and data quality principles, with experience developing data quality checks or reports
• Prior experience using the Bloomberg Terminal
• Experience with Apache Airflow or similar tools

Compensation and Benefits

The annual base salary range for this position is $100,000 to $120,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.