Description

THE PRODUCT: 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. CORE RESPONSIBILITIES: The candidate will be responsible for design, implementation, and maintenance of FlexTCAs data processing, data management, data automation, 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 time series 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. Validate both internal and Sisense-related processes; data, analytics, alerting, admin, etc. Design & Development of data components, dashboards, widgets, and analytics. Test - Perform developer testing for all software modifications. Product and Component Testing. Work to expand regression test plans for software modifications. Job requirements Degree in Computer Science or equivalent industry experience acceptable. Two years' experience required. Excellent SQL skills are required. Strong experience Python Experience with any business intelligence tool, optimally Sisense, will be strongly preferred. Excellent communication and problem-solving skills. Knowledge or experience of trading analytics would be a big plus. Implement - The candidate will be responsible to implement generic and custom business intelligence dashboard solutions. UNIX / Shell scripting preferred. Experience with Pandas a plus. Degree in Computer Science or equivalent industry experience acceptable. Experience with Big Data and/or Time Series databases will be useful. Experience with data modeling and query optimization. Experience with databases such as Mongo, Redshift, MySQL, Snowflake, Postgres. Experience with REST APIs. Experience with scripting languages such as HTML/JavaScript, CSS, and other JavaScript libraries. Experience working with JDBC framework a plus.

Role and Responsibilities

• THE PRODUCT: 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. CORE RESPONSIBILITIES: The candidate will be responsible for design, implementation, and maintenance of FlexTCAs data processing, data management, data automation, 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 time series 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. Validate both internal and Sisense-related processes; data, analytics, alerting, admin, etc. Design & Development of data components, dashboards, widgets, and analytics. Test - Perform developer testing for all software modifications. Product and Component Testing. Work to expand regression test plans for software modifications. Job requirements Degree in Computer Science or equivalent industry experience acceptable. Two years' experience required. Excellent SQL skills are required. Strong experience Python Experience with any business intelligence tool, optimally Sisense, will be strongly preferred. Excellent communication and problem-solving skills. Knowledge or experience of trading analytics would be a big plus. Implement - The candidate will be responsible to implement generic and custom business intelligence dashboard solutions. UNIX / Shell scripting preferred. Experience with Pandas a plus. Degree in Computer Science or equivalent industry experience acceptable. Experience with Big Data and/or Time Series databases will be useful. Experience with data modeling and query optimization. Experience with databases such as Mongo, Redshift, MySQL, Snowflake, Postgres. Experience with REST APIs. Experience with scripting languages such as HTML/JavaScript, CSS, and other JavaScript libraries. Experience working with JDBC framework a plus.