Senior Data Analyst

DRW; City Of London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading trading firm is seeking a Senior Data Analyst to manage and maintain datasets crucial for trading operations. The ideal candidate will have over 3 years of experience in data analysis, proficiency in SQL and Python, and knowledge of financial instruments. This role requires strong problem-solving skills and the ability to work independently in a fast-paced environment.

Qualifications

• 3+ years of experience working as a data analyst.
• Knowledge of financial instruments, especially derivatives.
• Python skills: PySpark, Pandas.

Responsibilities

• Onboarding and managing datasets used by traders.
• Ensure data accuracy and consistency across systems.
• Conduct preliminary root cause analysis.

Skills

Data analysis

SQL

Python programming

Cloud storage solutions

Workflow management tools (Airflow / Argo)

Tools

Jupyter Notebooks

Git

Job description

Overview

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.

Responsibilities

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.

• 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

Qualifications

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

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.