Data Analyst, Exploration

drweng; Chicago (IL); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Group medical

Dental and vision insurance

401k with discretionary match

Short and long-term disability

Life and AD&D insurance

Health savings accounts

Flexible spending accounts

Job summary

DRW in Chicago is seeking a data engineer to analyze new datasets, profile content, and surface insights for data strategists and front-office stakeholders. You will curate data catalog entries so assets are easily discoverable and ready for analysis.

You will monitor data quality across completeness, validity, accuracy, timeliness, and consistency, collaborate with global teams, resolve production issues, and help improve data processes and governance.

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 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.

Skills

SQL

Python

Financial instruments knowledge

Data storytelling

Tools

PySpark

pandas

numpy

Jupyter Notebooks

Git

Linux

Bash scripting

Airflow

AWS Athena

Amazon S3

Bloomberg Terminal

Job description

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.

What you will do in this role:

• 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

What you will need in this role:

• 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

Additional skills or experience which enhance consideration for this role:

• 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

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.

Benefits:

• 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
• flexible spending accounts

For more information about DRW's processing activities and our use of job applicants' data, please view our Privacy Notice at https://drw.com/privacy-notice. California residents, please review the California Privacy Notice for information about certain legal rights at https://drw.com/california-privacy-notice.