Data Analyst - Trading Desk
Core
Transform high-velocity data into clear financial insights to inform and strengthen trading strategies.
Role type
Data Analyst (Trading Desk)
Builds
Automated P&L reporting frameworks, trading analytics dashboards, and data models for high-frequency reporting.
Domain
Financial services / Fintech / Trading
Deliverable
production ML models | dashboards & analysis
Required skills
SQL (OLAP/ClickHouse), Python, financial market understanding, data visualization, data modeling, stakeholder communication
Preferred skills
Airflow, dbt, Git workflows, BI tooling (Superset, Metabase, Power BI, Grafana), other OLAP stores (Druid, BigQuery, Snowflake)
Technologies
Kafka, RabbitMQ, ClickHouse, Python, SQL
Responsibilities
Develop and maintain automated PnL reporting frameworks from real-time data streams; Conduct deep-dive trading analytics to identify execution patterns, slippage, and market impact; Write and optimise complex SQL queries in ClickHouse; Collaborate with stakeholders to define and implement KPIs for trading desks; Monitor data quality and integrity across the pipeline; Use Python to build robust data processing scripts; Design data models and schemas supporting high-frequency reporting.
Seniority
Mid-level, hands-on IC