Data Analyst - Trading Desk
Role Overview
We are looking for a Data Analyst to transform high-velocity data into clear financial insights that inform and strengthen our trading strategies.
Working with real-time data pipelines built on Kafka, RabbitMQ, and ClickHouse, you will help ensure that P&L reporting and trading analytics are accurate, timely, and actionable. Positioned at the intersection of engineering and finance, this role requires strong technical and analytical capabilities, along with a solid understanding of financial markets.
Responsibility
Develop and maintain automated PnL reporting frameworks that pull 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 to handle large-scale financial datasets efficiently.
Collaborate with stakeholders to define and implement key performance indicators (KPIs) for various trading desks.
Monitor data quality and integrity across the pipeline to ensure financial reporting remains compliant and accurate.
Use Python to build robust data processing scripts that automate repetitive analytical tasks.
Design data models and schemas that specifically support high-frequency reporting and business objectives.
Key Skills for This Role
Full Job Posting
About the role
We are looking for a Data Analyst to transform high-velocity data into clear financial insights that inform and strengthen our trading strategies.
Working with real-time data pipelines built on Kafka, RabbitMQ, and ClickHouse, you will help ensure that P&L reporting and trading analytics are accurate, timely, and actionable. Positioned at the intersection of engineering and finance, this role requires strong technical and analytical capabilities, along with a solid understanding of financial markets.
Responsibility
Develop and maintain automated PnL reporting frameworks that pull 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 to handle large-scale financial datasets efficiently.
Collaborate with stakeholders to define and implement key performance indicators (KPIs) for various trading desks.
Monitor data quality and integrity across the pipeline to ensure financial reporting remains compliant and accurate.
Use Python to build robust data processing scripts that automate repetitive analytical tasks.
Design data models and schemas that specifically support high-frequency reporting and business objectives.
Must have
- University degree in Finance, Economics, Computer Science, or a related quantitative field.
- Prior experience working within the finance or fintech industry, with an understanding of financial instruments or trading data.
- Advanced SQL knowledge and experience with OLAP databases like ClickHouse.
- Strong programming skills in Python for data manipulation and automation tasks.
- Experience with data visualisation tools to represent real-time data effectively.
- Ability to convey technical findings clearly to both technical and non-technical stakeholders.
- Detail-oriented mindset with a focus on data accuracy and compliance with governance policies.
- Must have
- Exposure to ClickHouse (or another columnar/OLAP store — Druid, BigQuery, Snowflake)
- Airflow or similar orchestration; dbt; Git-based workflows
- BI tooling (Superset, Metabase, Power BI, Grafana)
Nice to have
- Exposure to ClickHouse (or another columnar/OLAP store — Druid, BigQuery, Snowflake)
- Airflow or similar orchestration; dbt; Git-based workflows
- BI tooling (Superset, Metabase, Power BI, Grafana)
Benefits
- Competitive salary and performance-based bonuses.
- Opportunities for career growth and development within a global company.
- Collaborative and inclusive work environment with exposure to cross-region operations.
- Health and wellness benefits.
- Flexible working arrangements.
About TMGM
Private online CFD and forex broker serving global traders across forex, crypto, metals, indices, and shares.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at TMGM
Forex CFD Account Manager I Mandarin Speaking
Canberra, AUS
TMGM is seeking a Forex industry Account Manager to drive sales, build client relationships, and provide responsive service across communication channels. Candidates need at least one year of Forex industry experience, s
Forex CFD Account Manager I Mandarin Speaking
Adelaide, AUS
TMGM is seeking a Forex CFD Account Manager to grow sales and client relationships while providing service across communication channels. Candidates need at least one year of Forex industry experience, comfort with outbo
Trading Operations Engineer
Sydney, AUS
Forex CFD Account Manager I Mandarin Speaking
Canberra, AUS
Forex CFD Account Manager I Mandarin Speaking
Adelaide, AUS
Senior Liquidity Analyst
Sydney, AUS
HR Business Partner
Sydney, AUS
Creative & Digital Project Manager
Sydney, AUS
Partnership Manager
Melbourne, AUS
Assistant Accountant
Sydney, AUS