Trade Support Engineer

Trade Support Engineer

Chicago – Onsite

About The Role:

As our Trade Support Engineer, you'll play a key role across several critical functions.

What You’ll Do:

Database Design and Development

• Design and build a robust database schema to manage trade, order, position, and PnL data for real-time and end-of-day reporting.

Data Collection Programs

• Develop tools to collect data from exchange drop-copy feeds, clearing APIs, EOD statements, market data feeds, internal systems, and logs.

Job Automation

• Build jobs to extract data from non-API sources like websites, text files, and PDFs.

Data Reconciliation

• Implement real-time and EOD reconciliations, flag discrepancies, and build front-end tools to display key data.

Documentation Maintenance

• Maintain clear documentation of systems, including database schemas, workflows, architecture, and Git version control.

What We’re Looking For:

Must Have

• Database Expertise: Advanced experience with medium to large relational databases—design, SQL programming, setup, optimization, monitoring, and troubleshooting.
• Programming: Strong skills in a language supporting database and system functions.
• API Experience: Skilled in handling textual and binary APIs for reliable data extraction and storage.
• GUI Development: Experience building small to mid-level GUI front-ends.
• Linux Proficiency: Fluent in Linux system management, configuration, monitoring, and troubleshooting.
• Scripting: Proficient in bash scripting and Linux automation tools like cron and systemd.
• Version Control: Comfortable with Git workflows, both CLI and IDE (e.g., VSCode).
• Documentation: Able to create and maintain detailed system docs using tools like MS Visio.
• Independent Work: Capable of interpreting brief user needs and delivering well-organized, documented solutions.
• Education: Bachelor’s degree or higher.

OOJ-1441G