DRW
Chicago, IL

Senior Database Engineer, SQL/Python at DRW

| Chicago
Sorry, this job was removed at 2:44 p.m. (CST) on Wednesday, September 30, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

DRW is a technology-driven, diversified principal trading firm. We trade our own capital at our own risk, across a broad range of asset classes, instruments and strategies, in financial markets around the world. As the markets have evolved over the past 25 years, so has DRW – maximizing opportunities to include real estate, cryptoassets and venture capital. With over 1,000 employees at our Chicago headquarters and offices around the world, we work together to solve complex problems, challenge consensus and deliver meaningful results. It’s a place of high expectations, deep curiosity and thoughtful collaboration.

As a Senior Database Engineer/Developer, you will be responsible for a wide range of tasks including technology selection and recommendation, development of stored procedures, data cleansing, database maintenance, performance tuning, and monitoring of database that are used by a critical trading system.  You will also be actively involved in the ongoing enhancement and automation of system processes.  

Responsibilities:

  • Design/write SQL stored procedures used for core trading system software
  • Develop methodology of maintaining code for production/QZ/dev using Git and process for promoting/deploying code
  • Develop python code to perform various database maintenance such as financial security data, database reporting, error checking, etc.
  • Design relationships and constraints and develop monitoring to ensure referential integrity and data validity in production databases
  • Manage database code consistency between dev, QA, and production for all regions
  • Develop security methodology for handling access rights to DB objects
  • Able to gather, understand, and suggest requirements for database usage for core development group, to include databases other than SQL
  • Experience with other data systems to be able to offer perspectives on different data solutions for different needs
  • Troubleshoot production issues related to data and SQL code
  • Work with software developers, quantitative research, app support, and QA on data related development needs
  • Provide reporting services that gives required data without impacting production use
  • Work with QA to create regression testing of stored procs and any DB code, including performance testing
  • Work with DB admins on implementing changes and issues

Requirements:

  • At least 5 years of professional experience with Microsoft SQL
  • 3+ years of experience with Python development
  • Experience with Trading Securities data (futures, options, equities, currencies, corp actions, etc.)
  • Experience with other DB technologies (Postgres, Oracle, influx, mongo, etc.)
  • Experience in data warehousing a plus

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.

See More
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

Situated in Chicago's thriving West Loop, our HQ is convenient for Metra and CTA riders alike - and foodies looking for a bite on "Restaurant Row."

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PerlLanguages
    • PythonLanguages
    • RubyLanguages
    • ClojureLanguages
    • ElixirLanguages
    • RustLanguages
    • D3JSLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • PhoenixFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • RiakDatabases
Previous
Next

What are DRW Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Our remote work program includes work from home remotely on occasion as needed.
Family Medical Leave
Adoption Assistance
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
We offer employees Paid on-site garage parking.
Recreational Clubs
Relocation Assistance
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
DRW hosts lunch and learn meetings once per month.
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes Cross-department program, Career mentoring, Leadership mentoring.
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

Additional Perks + Benefits

Daily catered breakfast and lunch. On-site yoga and meditation classes. Trivia nights. Chair massages. Wine, beer, and whiskey tastings. Mentorship program. Game tournaments. Speaker series and "Geek Lunches."

An Insider's view of DRW

How does your team reward individual success?

Our team acknowledges individual success and provides an environment to further new ideas. The team then ensures higher management is aware of your contribution. These accomplishments become part of the individual’s and team’s record at the end of the year. This approach I believe has led to a lot of innovations on my team.

Kumbi

Network Engineer

What kinds of technical challenges do you and your team face?

During my internship in Chicago, I built models in python, ones that are still used on that desk today. The next summer, I returned as a full-time trading analyst and picked up right where I left off. I focus on systematic research and the development and execution of new strategies for the foreign exchange (FX) options desk in Chicago.

Alex

Quantitative Trading Researcher

What are some things you learned at the company?

We’re free to choose the technology stack that best solves each individual problem, so the learning happens project to project. I started programming in C#, but changing teams exposed me to a new suite of languages that I’m now working in regularly

Carissa

Software Engineer

How do your team's ideas influence the company's direction?

Working on the risk team, I combine the principles of risk management and computer science. I help direct how we take risk across the organization, and ensure reliability with the use of really innovative tech.

Brawnski

Software Engineer

What are some social events your company does?

DRW is not all work, all the time. We offer a number of activities and events for all interests, like monthly wine tastings, sports leagues, hobby clubs and movie outings to name a few.

Michelle

Systems Team Lead

Jobs at DRW
39

All Jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Operations
Tap to close

DevOps Engineer

DRW
Chicago
10 hours ago
+60
Support DRW’s multiple Kubernetes clusters in different geo-locations. Help guide our team's services and tools toward a more cloud-native approach. Evangelize the Kubernetes platform throughdemos, "lightning talks", etc.  Assist developers in different business units to onboard their applications to our Kubernetes platform. Senior engineers will provide leadership and direction to junior members of the team. Identify and automate repetitive manual tasks . Participate in our Kubernetes platform on-call rotation.

Algorithmic Trader

DRW
Chicago
14 hours ago
+60
As a Algorithmic Trader, you will have an opportunity to combine the disciplines of risk management, research and technology to operate trading strategies across multiple asset classes. You will work closely with experienced traders, software engineers and quantitative researchers to ensure optimal system performance.  Note: The working hours are 12am-9am, Monday-Friday.

Senior Python Engineer

DRW
Chicago
2 days ago
+60
We are looking for an experienced Senior Python Engineer to join a newly created Infrastructure Development team. The role will include designing, developing, and deploying applications for teams across the Infrastructure Technology Services organization. You will also be working closely with other groups within the organization, such as Networking, Telecom, and Core Infrastructure Services, in a mentorship capacity. You will be working primarily in a Linux/macOS environment.

Commodities Quantitative Trading Strategist

DRW
Chicago
3 days ago
+60
This strategist will support market-making as well as proprietary trading strategies using fundamental analysis to develop trading opportunities that are quantitatively well defined and robust.  You will be directly involved in identifying trading opportunities.

Quantitative Trading Analyst

DRW
Chicago
3 days ago
+60
As a Quantitative Trading Analyst, you will have an opportunity to combine the disciplines of risk management, research and technology to create optimal trading and investment strategies within the regulatory framework. You will work closely with experienced traders, software engineers and quantitative researchers. You will gain exposure to multiple asset classes through hands on trading experience and data analysis. Individual discovery and collaboration with fellow team members are encouraged to develop your understanding of market behavior.

Trading System Software Developer

DRW
Chicago
3 days ago
+60
As a Trading System Software Developer, you will be an integral member of a team of experienced technologists, quantitative researchers, and traders. Your team will work closely to solve challenging technological problems by contributing to our full tech stack, from hardware and software development to grid computing. We are looking for individuals eager to learn new technologies to create innovative solutions and choose the right tools to directly impact our business. You will be surrounded by cutting-edge technology, given immediate responsibility, mentored by industry-leading engineers, and attend a robust training program, all to provide you with the best possible environment to succeed at DRW.

Quantitative Researcher

DRW
Chicago
3 days ago
+60
Our formula for success is to hire exceptional people, encourage their ideas and reward their results. As a Quantitative Researcher, you will develop mathematical models using advanced statistical learning methods to build automated trading strategies across multiple asset classes. Our research team collaborates on idea generation and strategy development, while encouraging independent exploration and original approaches. You will have access to

Lead Software Engineer, Futures Trading Desk

DRW
Chicago
3 days ago
+60
We are starting a new trading desk and we’re looking for a Lead Software Engineer to bootstrap the effort. In this role, you’ll be expected to design, development and test proprietary trading software. The firm has built up a significant set of tools and technology, which you will have access to. You will be expected to pragmatically focus on business value by leveraging our existing tools and infrastructure wherever possible.

Microwave Tower Technician (No Travel)

DRW
Chicago
3 days ago
+60
DRW is looking for a Microwave Tower Technician in the Chicago, IL area to support our internally managed wireless networks. This position would involve local travel only (in the Chicago area).  This position will challenge you to provide quick and consistent responses to network needs while working with some of the smartest people in the financial industry. Experience with millimeter wave installations including path alignments and troubleshooting is strongly preferred. This role may include downtime in the office, and additional responsibilities may include assistance with lab testing, path design, equipment configuration and testing, and planning with stakeholders. We are looking for candidates who want to expand their skills beyond climbing and spend some time in an office environment helping to optimize our solutions.

Senior Software Engineer, Cryptoassets

DRW
Chicago
3 days ago
+60
As a member of this team, you will work with other software engineers to design and develop the full stack of software needed to enable a global trading operation. You are expected to design and develop trading systems, exchange connectivity solutions, monitoring systems, and tools to integrate with DRW’s core infrastructure services. The team’s existing systems are written in Java, C++, and Python. Future systems, of which there are many still in the green-field phase, will likely be written in Java, C++, Python, or JavaScript. 

Senior Software Engineer, Ruby/Clojure

DRW
Chicago
3 days ago
+60
You'll be helping DRW manage its funds efficiently by developing and maintaining simple and robust data pipelines written mostly in Ruby and Clojure that perform complex analysis on all of the firm's and some of the market's data. You'll care about interest rates, charges, trade limits, risk based limits, liquidity, and much more. You'll be using some calculation engines you write and some that are provided by third parties. You'll get to find innovative ways to integrate disparate technologies and provide real and valuable insights to the business. You'll decide which data needs to be up-to-the-second actionable and which data needs to be curated over long periods to gain daily, weekly, monthly, or yearly insights. You'll enable the communication mechanism for that data whether it be alerting, dashboards, ad-hoc querying, or complex data visualization. You'll work closely with your customers inside the firm to bring reliable, concrete, and introspect-able numbers to fuel their deep industry expertise.

Senior FPGA Engineer

DRW
Chicago
3 days ago
+60
We are currently seeking a Lead/Senior FPGA Engineer to join one of our trading teams. While DRW has been leveraging FPGA technology for a number of years, you will have the opportunity to build an FPGA application from scratch for an existing team. We’re seeking a candidate that has a strong understanding of software and hardware interaction. This person will participate in the full development lifecycle, including system and block level testing, of low latency high throughput FPGA design.

Senior Software Engineer, C++

DRW
Chicago
3 days ago
+60
Have significant experience developing high-availability systems in C++ and Python with very tight resource/latency constraints. Have a background in multi-threaded programming and a strong understanding of hardware/software interaction. Are comfortable working “under the hood” and you are quite skilled in performance tuning (applications, Linux, socket I/O, etc.) and troubleshooting. Have experience working with C++ libraries like STL and Boost. Are up to date on the C++0x/11 standards and have opinions about them. Have worked on challenging projects that involved things like building a custom compiler, writing a matching engine, or working with large amounts of data in real time. Have strong verbal and written communication skills.

Senior Software Engineer, Trading Infrastructure

DRW
Chicago
3 days ago
+60
Building systems with a constant focus on testing, reliability, scalability, and maintainability. Designing, modeling, and programming in a variety languages and technologies. Working on legacy code as well as green field development. Initiative driving projects to completion. Learning and promoting new technologies with a focus on best practices. Providing on-call support as needed. Sometimes working alongside other developers on the same task.

Software Engineer, C++

DRW
Chicago
3 days ago
+60
DRW is looking for an outstanding Software Engineer with an expertise in C++. You will be joining a team of highly talented Engineers who are tasked with building a cutting edge, low latency trading application that's being used on a global scale. You will have the opportunity to rotate through various areas of the stack, including order routing, market data, strategy, and risk.

Quantitative Researcher

DRW
Chicago
3 days ago
+60
As a Quantitative Researcher, you will have an opportunity to solve challenging problems arising in a trading environment while utilizing statistical scientific algorithms and mathematical modeling techniques. You will find great minds with diverse backgrounds, who are passionate about cultivating new ideas and exploring ways to bring them to life. Our quantitative researchers work closely with experienced traders and software engineers.

Senior Quantitative Researcher, FICC Options Trading

DRW
Chicago
3 days ago
+60
Research new market features for predictive properties. Identify inefficiencies in the financial markets and characterize them with mathematical models. Predict price movements using statistics, signal processing and machine learning. Design automated trading agents that achieve efficient execution.

Senior Linux Engineer (Data Capture)

DRW
Chicago
3 days ago
+60
As a Network Capture Engineer, you will be responsible for supporting our firm-wide, business-critical network capture solution. Alongside your colleagues, you will monitor the health and utilization of the environment to detect and prevent problems, and ensure reliable data capture. Help us maintain and improve this vital infrastructure component through rigorous testing in our lab environment.

Research Developer

DRW
Chicago
3 days ago
+60
As a Research Developer, you will be an integral member of an algorithmic trading team comprised of experienced technologists, quantitative researchers, and traders. Your team will work closely to solve challenging technological problems and contribute to our full tech stack, from hardware and software development to grid computing. You will be surrounded by cutting edge technology, mentored by industry-leading engineers, offered training and continuing education opportunities, and given immediate responsibility. We are looking for creative technologists, natural programmers, and disciplined engineers eager to develop new technologies that directly impact our business.

Senior Frontend Engineer, Cryptoassets

DRW
Chicago
4 days ago
+60
As a member of this team, you will be expected to design and develop all UX/UI software and to play a critical role in the design of various inter-process APIs.  The team’s existing interfaces are written in TypeScript and JavaScript with a heavy emphasis on React. Candidates should have strong initiative and have proven experience independently driving projects to completion.  We work from high-level requirements and programmers are expected to gain an intimate understanding of the business and work directly with traders and researchers on a daily basis.

Investment Analyst Intern

DRW
Chicago
6 days ago
As an Investment Analyst Intern, you will collaborate with the investment team to research and evaluate investment opportunities. The ideal candidate will have meaningful exposure to private company investing and a passion for quantitatively and qualitatively evaluating investment opportunities in the venture capital landscape. The ideal candidate has a passion for understanding business models and a curiosity about companies. This internship will provide meaningful exposure and responsibility to make an impact on a growing team. Prior interns have spent time supporting portfolio companies by assisting with financial models and pitch presentations while also researching new opportunities in the FinTech and Enterprise Tech space. 

Senior DevOps Engineer

DRW
Chicago
1 week ago
Contribute to the design and evolution of our service offerings to multi-office teams who support all manner of trading and backoffice functions. Build, test, release, and support internal applications. Help guide our team's services and tools toward a more cloud-centric approach. Contribute to standup meetings, demos, "lightning talks", etc.. Provide leadership and direction to junior members of the team. Identify and automate repetitive manual tasks. Help the team support CodePlatoon.org as we jump-start grads in IT careers via 3-month internships with DRW.

Software Engineer, Options Trading Platform

DRW
Chicago
1 week ago
DRW is looking for an exceptional  Software Engineer with an expertise in Java to join a team of highly talented technologists tasked with building a proprietary options trading platform. Your role will focus on all areas of software engineering, including design, development, implementation, testing, and post-trade analysis while using the latest technologies and low latency techniques.

Strategy & Execution Analyst

DRW
Chicago
1 week ago
As a Strategy and Execution Analyst, you’ll join a team of highly talented business development, traders, relationship managers and researchers in our Chicago office.  You will be tasked with taking a data-driven approach to solving some of the most important challenges facing the business. Beyond just forming strategies and making recommendations, you will manage critical projects and have a direct impact on the implementation of important business initiatives.  You will routinely interface with a variety of business functions across the team and the larger firm, as well as with external counterparties. This is a unique opportunity to contribute to the growth of a market leader in the cryptoasset trading ecosystem and benefit from professional development in a highly supportive and collaborative environment. 

Senior Financial Analyst

DRW
Chicago
1 week ago
As a Senior Financial Analyst, you will join our Accounting & Finance team and utilize your technical and analytical skills to automate processes and generate new and innovative reporting. This is a great opportunity for someone who is interested in developing their skills in an aggressive, fast-paced and rapidly growing trading environment.

Software Engineer, C++ (FICC Options)

DRW
Chicago
1 week ago
DRW is looking for an exceptional Software Engineer with an expertise in C++ to join a team of highly talented technologists tasked with building a proprietary options trading platform. Your role will focus on all areas of software engineering, including design, development, implementation, testing, and post-trade analysis while using the latest technologies and low latency techniques.

Credit Risk Manager

DRW
Chicago
1 week ago
DRW is seeking a Risk Manager. This position will report to the Director of Risk Management in Chicago and be responsible for performing daily risk monitoring of many of our portfolios and for assisting in the ongoing development and enhancement of our credit risk management framework.  

Trading Systems Engineer

DRW
Chicago
1 week ago
As a Trading Systems Engineer supporting our QA & Development environments, you will provide mission critical support for our core proprietary trading systems.  You will manage a wide variety of technical support and engineering functions, including application support in testing and development environments, software deployment, and configuration and system monitoring.  It’s a fast-paced, dynamic environment that provides new technical challenges constantly and demands that you learn new things daily. 

Cloud Engineer

DRW
Chicago
1 week ago
We are seeking a Cloud Engineer to work with teams across the firm to empower engineers as we explore firmwide solutions to empower quantitative engineers and researchers. The position will help evolve team-specific AWS environments, strengthen a cloud-based development cycle, facilitate large data flows between an on-premise network and the cloud, work with multiple stakeholders to standardize firm-wide utilization of cloud resources, and help with deployment via Terraform or similar tools. Members of the Core Infrastructure Services team are dedicated to providing reliable, flexible services which are utilized by the entire firm for many business-critical activities. A successful candidate will be able establish and build an infrastructure-as-code (IAC) repository and be quickly responsive to teammates request and work closely with colleagues in information security and infrastructure.  

Software Engineer, FICC Options (Python)

DRW
Chicago
2 weeks ago
We are seeking a Software Engineer to join our FICC Options trading team.  In this role, you’ll be working closely with traders and developers to build out our trading platform.

Operations Specialist - Fixed Income, Currency & Commodities Trading

DRW
Chicago
2 weeks ago
As an Operations Specialist, you’ll provide support to a group of trading desks based in Chicago. This is an opportunity to solve challenging problems while working closely with experienced traders, researchers and software engineers to optimize operational workflow and use the right tools and technology for the job.

HRIS Analyst

DRW
Chicago
2 weeks ago
As an HRIS Analyst, you will act as both a functional and technical HR subject matter specialist on the HR team.  You will help our HRIS team administer and configure DRW’s current global HR system, Workday.  You will collaborate with other HR team members on various HR initiatives relating to our HR system, such as immigration, new hire orientation, global payroll, employee benefits and performance management. 

Technical Operations Engineer

DRW
Chicago
2 weeks ago
As a Technical Operations Engineer, you will have a ground floor opportunity to shape the overall direction of DRW’s Technology Operations Center, a new team acting as the global, front-line of defense in monitoring and response for our business-critical systems.  As a part of this team, you will rapidly respond to events and outages, ensuring a consistent and thorough response globally, while working to minimize any potential business impact.  You will also lead efforts to further enhance the Technology Operations Center’s capabilities through automation and the buildout of new tool sets and processes.  You will be uniquely positioned to interact with individuals and teams across all areas of DRW, requiring you to quickly build a working understanding of the relationships between systems and the organizations dependent on them.

Security Engineer

DRW
Chicago
3 weeks ago
Our global Security Engineering team is looking for a talented Security Engineer to join the team in our Chicago HQ office.  To flourish in this role, you will need a strong drive to learn and improve.  And when it comes to new technology, you’ll enjoy researching and evaluating new solutions using custom and commercial testing tools.

Software Engineer - Surveillance Application Developer

DRW
Chicago
3 weeks ago
As a Software Engineer on our Compliance technology team, you'll be part of a tight knit team of software engineers working closely with our UK and US Compliance Officers to make sure that our (incredibly important) regulatory requirements are fulfilled. You'll experiment with emerging technologies to monitor trading behaviors and deliver critical reporting and analytics. You’ll wrestle a mountain of data into human understandable insights. 

Business Operations Specialist - Market Data

DRW
Chicago
3 weeks ago
As a Business Operations Specialist - Market Data, you’ll help manage the firm’s global market data program, including acquiring new market data, tracking the firm’s market data inventory and usage, ensuring compliance with licensing policies, and generating required reporting.

Linux Systems Engineer

DRW
Chicago
3 weeks ago
As a Linux Engineer, you will be responsible for designing, deploying, and supporting Linux for our end-users. You will monitor the health and utilization of the environment to detect and prevent problems, ensure high availability for users, and plan future growth to meet needs. You will also be instrumental in helping software teams improve their efficiency in deploying custom tools to traders. This is an opportunity for someone to influence overall systems architecture as well as rapid deployment initiatives, build processes, packaging, monitoring and more. In this role, you will have an opportunity to regularly interact with a number of development groups to gather requirements, make recommendations and implement change.

Software Development Engineer in Test

DRW
Chicago
3 weeks ago
The Software Development Engineer in Test provides mission critical support for our core proprietary trading systems.  As a SDET, you will develop test plans and test cases for various trading platforms that are used globally by trading and research teams across the firm. We are seeking a candidate with experience working in fast-paced development environments who has a strong regression testing background and significant experience developing automated testing strategies and test cases.

Senior Systems Engineer (Desktop)

DRW
Chicago
3 weeks ago
Our Systems and Mobile Platforms team is the front line of support for all users across the firm. We work with a wide range of the best technology available - - and we get to test, configure and deploy it all in an environment that continually challenges us and demands that we learn new things daily. The pace is fast but we also obsess about leaving no stone unturned when there is a problem to be solved. We believe in healthy debate, creative and collaborative problem solving and active knowledge sharing. Strong technical aptitude and a passion for technology are critical for success in the Desktop Systems Engineer role but initiative, strong analytics and drive are equally important.