Data Analyst

TMGM; Sydney; On-site; AUD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Bonuses

Career growth

Collaborative environment

Health & wellness

Flexible working

Job summary

TMGM, a global online trading and investment firm, is seeking a Data Analyst in Sydney to transform high-velocity data into financial insights that inform trading strategies. You will work with real-time data streams and PnL reporting to support decision making.

Responsibilities include SQL, Python scripting, data modeling, and KPI development for trading desks, ensuring data quality and governance, and collaborating with engineering and finance teams.

Qualifications

• University degree in Finance, Economics, Computer Science or related quantitative field.
• Experience in finance/fintech with understanding of trading data.
• Advanced SQL and OLAP experience with ClickHouse.
• Python for data manipulation and automation.
• Experience with data visualization to present real-time data.
• Ability to explain technical results to diverse stakeholders.
• Detail-oriented with governance and data accuracy focus.

Responsibilities

• Develop and maintain automated PnL reporting frameworks from real-time data streams.
• Conduct deep-dive trading analytics to identify execution patterns and market impact.
• Write and optimise complex SQL queries in ClickHouse for large datasets.
• Collaborate with stakeholders to define KPIs for trading desks.
• Monitor data quality and governance to ensure accurate reporting.
• Use Python to build data processing scripts automating analyses.
• Design data models and schemas supporting high-frequency reporting.

Skills

Advanced SQL

Python

Data visualization

Communication

Attention to detail

Education

University degree in Finance, Economics or Computer Science

Tools

ClickHouse

Job description

About TMGM

TMGM stands at the forefront of online trading and investment services, proudly serving as Chelsea FC's Official Regional Online Forex and Trading Partner in Asia Pacific. With a global presence and offices spanning three continents, TMGM has earned its reputation as a trusted CFD trading provider. We embody excellence through a commitment to regulatory compliance, technological innovation, and unparalleled customer service.

At TMGM, our vision goes beyond providing a platform for trading; we aspire to empower our clients with the best trading conditions. We leverage industry-leading and cutting-edge innovative platforms to ensure that your trading experience is nothing short of exceptional. Our relentless commitment to research and development continually pushes the boundaries of liquidity and usability, giving you the tools you need to thrive in an ever-evolving financial landscape.

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.

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)

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