SQL/Python Database Developer

| Chicago
Apply now

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 SQL/Python Database 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.

Read Full Job Description
Apply now

Technology we use

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

Location

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."

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

What are DRW Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Group brainstorming sessions
Pair programming
Open office floor plan
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
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Adoption Assistance
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
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Acme Co. hosts lunch and learn meetings once per month.
Promote from within
Mentorship program
Our mentorship program includes Cross-department program, Career mentoring, Leadership mentoring.
Online course subscriptions available
Customized development tracks

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."

More Jobs at DRW38 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Internships
Marketing
Operations
Product
Project Mgmt
Data + Analytics
new
Chicago
Finance
new
Chicago
Internships
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Apply now
Save jobView DRW's full profileSee more DRW jobs