Senior Data QA Analyst

Venture outside the ordinary - TMX Careers

The TMX group of companies includes leading global exchanges such as the Toronto Stock Exchange, Montreal Exchange, and numerous innovative organizations enhancing capital markets.  United as a global team, we’re connecting cross-functionally, traversing industries and geographies, moving opportunity into action, advancing global economic growth, and propelling progress. Through a rich exchange of ideas, meaningful collaboration, and a nimble operating model, we're powering some of the nation's most critical systems, fueling capital formation and innovation, bringing increased opportunity to business visionaries, product ingenuity to consumers, and career exploration to our team.

Ready to be part of the action?

We are looking for a technical Senior Data QA to join our Datalinx cluster. This is a backend-heavy engineering role focused on high-volume trade simulation and data integrity. You will use Python to build automation frameworks that simulate thousands of real-time trades, ensuring our systems can handle market volatility. You will use complex SQL to deep-dive into our databases, validating that every byte of data flowing through our AWS pipelines is accurate, compliant, and timely.

If you enjoy breaking data pipelines, automating complex scenarios, and working in a high-stakes trading environment, this is the role for you.

This role reports to: Senior Manager, Data & Analytics & Enterprise Data Architect 

Job Location: Hybrid (2-3 days in office) - based in Toronto, ON.

Key Accountabilities:

• Build Simulation Frameworks: Design and maintain Python-based automation scripts (using Pytest/Requests) to simulate thousands of real-time trades and stress-test our trading platforms.
• Data Pipeline Validation: Validate ETL/ELT processes within AWS. Ensure data flows correctly from ingestion to storage, identifying data loss or transformation errors.
• Deep-Dive Analysis: Execute advanced SQL queries against MySQL/Snowflake/Hive databases to verify data accuracy, consistency, and completeness across the Datalinx ecosystem.
• Performance Engineering: Identify bottlenecks in the data product lifecycle. Analyze how the system behaves under high load and work with developers to optimize performance.
• Root Cause Analysis: Go beyond "reporting bugs." Trace issues back to the specific service, API endpoint, or database procedure causing the failure.

The Tech Stack:

• Language: Python (Heavy scripting, Pytest, Pandas, Requests).
• Database: SQL (MySQL, Snowflake, Hive, Athena).
• Cloud: AWS (S3, Data Pipelines, EC2, EMR, Lambda functions, REST APIs).
• Tools: GitHub, JIRA, Confluence
  
  

Must Haves:

• 5+ years in Software Quality Assurance with a specific focus on Data QA and Backend Automation.
• Python Expertise: You aren't just running scripts; you can write Python code from scratch to generate test data, mock APIs, and simulate user traffic.
• Advanced SQL Skills: You can write complex joins and window functions to validate large datasets without relying on a GUI.
• AWS & Cloud Data: Proven experience testing data pipelines and understanding how data moves through cloud infrastructure (AWS preferred).
• API Testing: Strong experience testing RESTful APIs and integrating them into automation suites.
• Performance Testing: Experience with load testing tools and strategies (simulating high-volume transactions).
• Operational Support: Support releases during off-business hours, when planned. Also providing support in case of adhoc issues to ensure system reliability.
  
  

Nice to Haves:

• Capital Markets Experience: Understanding of equity markets, trade lifecycles, and financial instruments.
• Big Data Tech: Experience with Hadoop, Spark, or Hive.
• Shell Scripting: Working knowledge of shell scripting in a Linux environment.

Salary Range: 100,000/year - 120,000/year CAD. Please note that the salary range included is a guideline only. The salary offered may vary based on factors, including, but not limited to, the successful candidate’s relevant knowledge, skills, and experience.

The recruiting efforts for this role are intended to fill a vacant position.

In the market for…

Excitement - Explore emerging technology and innovation, as well as ventures and digital finance that shape the future of global markets! Experience the movement of the market while grounded in the stability of close to 200 years of success.

Connection - With site hubs in some of the world’s most multicultural cities, we leverage our size and structure to create rich connections and belonging while experiencing powerful global impact through our work.

Impact - More than a platform, we use our talents to power mission-critical systems that drive global economic advancement, innovation, and growth. As well, our employee-led Team Impact spreads social good via our giving strategy.

Wellness - From empathetic leadership to a culture of flexibility and balance, we believe wellness at work creates the maximum yield and a stronger “we”. Plus, with a cloud-first and hybrid workstyle, as well as generous time-off and leaves, we support a life well lived! 

Growth - From a growth mindset in our work, to expansion in our business, TMX is home to action-takers energized by the achievement of ambitious growth.

Ready to enrich your career with impactful work, leaders who truly care, and the flexibility and programs to help you thrive as part of #TeamTMX ? Apply now.

Please note that our company is not currently sponsoring work permit applications and the applicant must be authorized to work in the country where this position is located. 

TMX is committed to creating and sustaining a collegial work environment in which all individuals are treated with dignity and respect and one which reflects the diversity of the community in which we operate. We provide accommodations for applicants and employees who require it.