Analytics Engineer

FlexTrade Systems is a global leader in high-performance multi-asset execution management and order management systems across equities, fixed income, foreign exchange, futures, and options. FlexTrade is internationally recognized for introducing FlexTRADER®, the world’s first broker-neutral execution management trading system, enabling clients to control and customize execution workflows while maintaining the confidentiality of their trading strategies.

At FlexTrade, we hold our values close to our hearts, with pride and gratitude, as they guide us in everything that we do. We are dedicated to giving our clients a competitive edge, taking ownership of our responsibilities, being flexible to adapt to an ever-changing environment and technology, bringing integrity to every interaction, and continuing to improve, grow together, and collaborate as one team. All of these, while having fun, truly make FlexTrade a wonderful place to work.

The Product:

FlexTCA is our Post & Pre-Trade transaction cost analysis and execution quality management solution. It provides historical and real-time analytics across global equities, FX, futures, and fixed income, helping investment managers and brokerages analyze, evaluate, and improve trader, algo, broker, and venue performance through an intuitive web-based analytics and visualization interface.

Role Objective
This role is intended for a hands-on Python engineer who will help scale FlexTCA reporting operations through automation. The engineer will work closely with senior Engineer, who will train and manage the role, with a focus on Sisense administration, Elasticube builds, dashboard deployment, production troubleshooting, and operational monitoring.

Core Responsibilities

• Develop and maintain Python-based automation used to deploy, migrate, validate, and maintain FlexTCA dashboards across Development, UAT, and Production environments.

• Administer and support the Sisense reporting environment, including dashboard configuration, access management, user onboarding, security setup, and operational support.

• Extend native UI capabilities to enhance user experience and address client requirements.

• Create, run, troubleshoot, and optimize Elasticube builds, data models, dashboard datasets, and related reporting dependencies.

• Perform dashboard deployment, customization, migration, and lifecycle management for internal teams and client-facing reporting workflows.

• Develop and maintain SQL / T-SQL queries, stored procedures, validation checks, dashboards, and reporting extracts.

• Monitor and build process automation around dashboard jobs, report delivery, data refreshes, production alerts, and log/report emails to ensure timely and accurate reporting output.

• Diagnose report issues, including data discrepancies, failed refreshes, missing values, performance bottlenecks, incorrect formulas, visualization defects, and access issues.

• Troubleshoot frontend and backend issues within the reporting stack, coordinating with data engineering, DBA, infrastructure, and support teams as needed.

• Build reusable operational tools for dashboard diagnostics, environment comparison, validation, deployment tracking, and support automation.

• Document dashboard support procedures, recurring diagnostics, deployment processes, production checks, and known issue resolutions.

• Partner with product, analytics, engineering, and client-facing teams to translate reporting requirements into scalable and maintainable automation solutions.

• Contribute ideas for applying LLMs, AI agents, and agentic workflows to areas such as report diagnostics, support triage, test generation, data validation, and operational automation.

Required Experience

• 2-4 years of experience in software development, data engineering, reporting automation, or BI platform support.

• Strong Python programming skills, with demonstrated ability to build scripts, automation utilities, data validation tools, or API integrations.

• Strong SQL skills, including data analysis, debugging, joining datasets, validation, and reporting workflows.

• Experience working with reporting, dashboards, analytics, or operational data platforms.

• Ability to work in Linux / Unix environments and investigate logs, scheduled jobs, and production support issues.

• Strong problem-solving skills with the judgment to distinguish symptoms from root causes.

• Clear communication skills and willingness to coordinate with engineering, analytics, support, and client-facing stakeholders.

Preferred / Nice-to-Have Experience

• Sisense administration, dashboard development, dashboard migration, or Elasticube build experience.

• Experience with BI platform user management, access control, dashboard sharing, or production support.

• Experience with Pandas, NumPy, data profiling, or Python-based data analysis.

• Familiarity with ETL workflows, data quality checks, data warehouse concepts, or production reporting pipelines.

• Exposure to financial markets, trading analytics, TCA, market data, or institutional reporting workflows.

• Familiarity with LLMs, AI agents, prompt engineering, AI-assisted development, or agentic workflow automation.

Why Join FlexTrade?

At FlexTrade, we value innovation, ownership, collaboration, and continuous improvement. You’ll work with a global team of experts, contribute to mission-critical projects, and help shape the future of trading technology.

**FlexTrade Systems, Inc. does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an authorized agreement for a particular SOW (Statement of Work) in place is hired: such resumes are deemed the sole property of FlexTrade Systems, Inc.**

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