Data Integration Specialist

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?

About TMX VettaFi
VettaFi is a differentiated index provider, helping asset managers across the globe build and grow their product suites. With an industry-leading index platform, we partner with issuers to develop innovative investment solutions and bring them to market. Beyond that, our modern distribution solutions help clients scale products and achieve success.
Significant investments and the backing of TMX Group have further strengthened our ability to help our partners by expanding our capability set and geographic reach. Our combined strength and entrepreneurial spirit empower us to deliver the specialized insights and services that enable asset managers and investors to achieve growth and success.
Position Summary
The Data Integration Specialist will own the end-to-end data pipelines moving in and out of our internal databases. You will be primarily responsible for designing, building, and maintaining integrations that push internal data (such as user activity and lead data) to 3rd-party platforms like HubSpot, as well as ingesting data from external vendors and platforms back into our internal systems.
You will work closely with the data, engineering and client service teams to ensure data flows securely, accurately, and reliably across our entire tech stack.

Key Responsibilities

• Build & Manage Integrations: Design, develop, and maintain robust API integrations and data pipelines connecting internal databases with external 3rd-party platforms (e.g., HubSpot, Salesforce).
• Pipeline Architecture: Develop and maintain ETL/ELT processes using custom code (Python).
• Data Quality & Integrity: Implement monitoring, alerting, and error-handling mechanisms to identify and resolve data discrepancies, API rate limit issues, and synchronization failures.
• Security & Compliance: Ensure all data transfers comply with data privacy regulations (GDPR, CCPA) and internal security protocols, utilizing OAuth, API keys, and encryption standards.
• Cross-Functional Collaboration: Partner with stakeholders across product and client service teams to gather requirements, map data fields, and translate business needs into technical integration specs.

Qualifications & Experience

• Experience: 5+ years of experience in data engineering, backend development, or a specialized data integration role.
• API Expertise: Deep understanding of RESTful APIs, Webhooks, GraphQL, and OAuth authentication. You should know how to read 3rd-party API documentation and build resilient connections.
• Programming Languages: Strong proficiency in Python or a similar backend language used for scripting and building custom integrations.
• Database & SQL Skills: Advanced SQL skills with hands-on experience querying and modeling data in modern relational databases or cloud data warehouses.
• Problem-Solving: Strong debugging skills with the ability to untangle complex data mapping issues and track down data discrepancies across disparate systems.

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.