Senior Data Analyst

DRW Holdings, LLC.; London; On-site; GBP 50,000 - 90,000; Full time

Job summary

An established industry player is seeking a Senior Data Analyst to enhance data quality and support trading teams globally. In this pivotal role, you will verify and clean datasets, analyze data for insights, and collaborate with various stakeholders to optimize data pipelines. The firm values innovation and integrity, providing a dynamic environment where you can thrive. If you have a passion for data and a strong analytical background, this is an exciting opportunity to make a significant impact in a fast-paced trading environment.

Qualifications

• 3+ years of experience as a data analyst with strong SQL skills.
• Proficient in Python, especially with PySpark and Pandas.

Responsibilities

• Ensure data accuracy and consistency across systems used for analysis.
• Analyze datasets to provide insights and address stakeholder questions.

Skills

Data Analysis

SQL

Python (PySpark, Pandas)

Data Quality Control

Documentation Skills

Problem-Solving

Workflow Management Tools (Airflow/Argo)

Cloud Storage Solutions

Git

Bash Scripting

Education

Bachelor's Degree in a relevant field

Tools

Jupyter Notebooks

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.

As a Senior Data Analyst 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 technology, front office, operations, research, and risk management. You should be comfortable investigating complex data support issues and develop sustainable solutions to address root causes.

What you will do in this role

• Help verify, clean, and ensure data is accurate and consistent across systems used for research and analysis by the various trading teams globally.
• Analyse datasets in order to draw conclusions and provide insight to address stakeholder or project-related questions.
• Collect metrics and analyse datasets across different dimensions of data quality including; completeness, validity, accuracy, timeliness, and consistency.
• Perform preliminary root cause analysis and make recommendations for modifications in data pipelines to increase data quality.
• Monitor and work through production data issues whilst engaging key stakeholders across multiple teams and facilitating global support.
• Proactively identify opportunities for improvement in processes and engage with developers to determine the appropriate course of action.

What you will need in this role

• 3+ years of experience working as a data analyst.
• Knowledge of a variety of financial instruments, in particular exposure to derivatives instruments.
• Experience working with SQL.
• Experience with cloud storage solutions.
• Experience with workflow management tools (Airflow / Argo).
• Prior experience writing documentation for senior stakeholders; the ability to accurately abstract and summarize technical information is critical.
• Python programming skills: PySpark, Pandas, Jupyter Notebooks (3+ years in a professional environment).
• Prior experience working with git in a professional environment.
• Ability to work independently in a fast-paced environment; prioritize multiple tasks and projects.

Additional skills or experience which enhance consideration for this role

• Prior experience developing data quality control processes to detect data gaps or inaccuracies is a plus.
• Familiarity with compressed/optimized file formats for data storage such as Parquet and HDF5.
• Prior experience providing technical guidance to junior data analysts.
• Prior experience mapping security identifier data or working with a security master database would be beneficial.
• Prior experience working with Bloomberg Terminal.
• Familiarity with Linux and basic Bash scripting skills.