Data Engineer (Python / SQL)

Job description

About Us:

FlexTrade Systems is a global leader in high performance multi-asset execution management and order management systems for equities, fixed income, foreign exchange, futures, and options. A pioneer in the field, FlexTrade is internationally recognized for introducing FlexTRADER®, the world’s first broker-neutral, execution management trading system, which allows clients to completely control and customize their execution workflows through a comprehensive ability to search/access liquidity while maintaining the confidentiality of their trading strategies.

FLEXTRADE: Data Engineer (Python / SQL) –FlexTCA

Join a dynamic FlexTCA (FlexTrade Transaction Cost Analysis) development team. FlexTrade is looking for a Data Engineer to be a part of a rapidly evolving technology group supplying top quality solutions to our growing top tier global client base. This role offers the opportunity to work closely with data scientists and data engineers within FlexTrade’s Quantitative Solutions team, as well as exposure to cutting edge analytics and machine learning technologies.


FlexTCA is our Post & Pre-Trade transaction cost analysis and execution quality management solution offering historical and real-time analytics for trading portfolios and single securities across global equities, FX, futures and fixed income. FlexTCA is used by investment managers and brokerages to analyze, evaluate, and improve trader, algo, broker, and venue performance. The product includes an intuitive and flexible web interface for data visualization, exploration, and analysis.


The candidate will be responsible for design, implementation, and maintenance of FlexTCA’s data processing, data management, and BI tooling. The product exposure offers the opportunity to the candidate to learn vast depth and breadth of trading and analytics technologies and the associated trade life cycle.

  • Should be able to write queries to facilitate data warehouse integrity checks
  • The individual will contribute to the design, development, and management of order, execution, and market data along with bucketed timeseries ticks for various assets classes.
  • Create and Maintain Extract, Transform, and Load (ETL) workflows for a range of datasets.
  • Write and maintain API interfaces with third party data vendors.
  • Will be responsible for all Production, QA and Dev ETL and data integrity checks on a Linux environment.
  • Provide automation support and backup to DBA team.
  • Help automate Business Intelligence environment maintenance and visualization roll-out using native Python wrapper.



  • Degree in Computer Science or equivalent industry experience acceptable. 2+ years experience required.
  • Excellent SQL skills are required.
  • Strong experience Python and UNIX / Shell scripting.
  • Experience with any business intelligence tool, optimally Sisense, will be strongly preferred.
  • Experience with numpy / pandas a plus.
  • Excellent communication and problem-solving skills.
  • Knowledge or experience of trading analytics would be a big plus.

**FlexTrade Systems, Inc. is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or any other status protected by law.**