Data Analyst, Exploration

DRW is hiring a Data Analyst, Exploration to onboard, manage, and maintain datasets used by traders and quantitative researchers. The role investigates data quality and production issues, supports research teams and vendors throughout the dataset lifecycle, and improves data assets and management processes.

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

Preferred

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

AWS Athena

Amazon S3

Linux

Bash scripting

Git

Data management

Data quality principles

Data quality checks

Data quality reporting

Bloomberg Terminal

Apache Airflow

Workflow orchestration tools

Benefits

Eligible for an annual discretionary bonus.

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

Company

Diversified global trading and investment firm

Chicago, Illinois, USA

http://drw.com/

Founded in 1992

1001-5000 employees

Qualifications

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

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

Required skills

SQL, Python, Financial Instruments, Market Data Symbology, PySpark, pandas, NumPy, Jupyter Notebooks, Data Quality, AWS Athena, Amazon S3, Bloomberg Terminal

Preferred skills

Familiarity with Linux and basic Bash scripting skills, Experience with version control tools such as Git, Prior experience using the Bloomberg Terminal, Experience with Apache Airflow or similar tools

Experience

1-2 years