Senior Data Engineer, Unified Platform

DRW Holdings, LLC.; Chicago (IL); On-site; USD 200,000 - 250,000; Full time

Benefits offered by this job

Comprehensive medical benefits

401k with employer match

Flexible spending accounts

Job summary

A leading trading firm based in Chicago is seeking a Senior Data Engineer to enhance their data platforms. You will design data pipelines, ensure data quality, and collaborate with various teams to implement governance processes. Candidates should have over 7 years of data technology experience, strong skills in SQL, Java or Python, and a proven track record in a trading environment. This position offers a salary range of $200,000 to $250,000, along with an annual bonus and comprehensive benefits.

Qualifications

• 7+ years of experience working with modern data technologies and products.
• Expert knowledge of SQL and Java or Python.
• Proven ability to deliver results in a collaborative and fast-paced environment.

Responsibilities

• Model, build, and manage data products on DRW's Unified Data Platform.
• Work closely with Data Strategists to manage new datasets.
• Design data governance processes for data quality control.

Skills

Data pipeline design

SQL

Java

Python

Data modeling techniques

Data migration

Project management

Data governance processes

Data quality monitoring

Collaboration

Tools

Flink

Spark

S3

NoSQL

Kafka

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 Engineer on our Data Experience team, you will play an integral role in bringing vendor datasets into our data platform, governing our centralized data pipelines, consolidating data delivery infrastructure across disparate systems, and working alongside individual Traders, Quantitative Researchers, and Back-Office personnel to best utilize the firm’s data and platform tools.

Technical requirements summary:

• Have extensive experience designing and building data pipelines
• Have experience working within modern batch and streaming data ecosystems
• An expert in SQL and Java or Python
• Extensive knowledge of data modeling techniques
• Able to own the delivery of data products, working with analysts and stakeholders to understand requirements and implement solutions
• Able to contribute to project management and project reporting
• Have experience driving nontrivial data migrations across platforms
• Able to establish, follow, and enforce data modeling standards across a large ecosystem.

What you will do in this role:

• Model, build, and manage data products built atop DRW’s Unified Data Platform.
• Work closely with Data Strategists to determine appropriate data sources and implement processes that onboard and manage new datasets for trading, research, and back-office purposes.
• Design data governance processes that enable discovery, cost-sharing, usage tracking, access controls, and quality control of datasets to address the needs of DRW trading teams and strategies.
• Continually monitor data ingestion pipelines and data quality to ensure stability, reliability, and quality of the data. Design monitoring and quality control software and processes.
• Own the technical aspects of vendor ingestion pipelines, coordinating with vendor relationship managers on upcoming changes, performing routine data operations without breaking internal users, and contributing to the team’s on-call rotation to respond to unanticipated changes.
• Rapidly respond to user requests, identifying platform gaps, and self-service opportunities that make the user experience more efficient.

What you will need in this role:

• 7+ years of experience working with modern data technologies and building data-first products.
• Excellent written and verbal communication skills.
• Proven ability to work in a collaborative, agile, and fast-paced environment, prioritizing multiple tasks and projects, and efficiently handle the demands of a trading environment.
• Proven ability to deliver rapid results within processes that span multiple stakeholders.
• Strong technical problem-solving skills.
• Extensive familiarity with SQL and Java or Python, with a proven ability to develop and deliver maintainable data transformations for production data pipelines.
• Experience leveraging data modeling techniques and ability to articulate the trade-offs of different approaches.
• Experience with one or more data processing technologies (e.g. Flink, Spark, Polars, Dask, etc.).
• Experience with multiple data storage technologies (e.g. S3, RDBMS, NoSQL, Delta/Iceberg, Cassandra, Clickhouse, Kafka, etc.) and knowledge of their associated trade-offs.
• Experience with multiple data formats and serialization systems (e.g. Arrow, Parquet, Protobuf/gRPC, Avro, Thrift, JSON, etc.).
• Proven experience in managing the operational aspects of large data pipelines such as backfilling datasets, rerunning batch jobs, monitoring event throughput, and handling dead-letter queues.
• Prior experience triaging data quality control processes, correcting data gaps and inaccuracies.

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

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 .