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