Integration developer • toronto on
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 ... Voir plus
ServiceNow Integration Developer / Consultant .ServiceNow Integration Developer / Consultant.We are seeking a ServiceNow Integration Developer/Consultant to design, develop, and maintain integrati... Voir plus
SummaryAt PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency.These individu... Voir plus
We are looking for a Workday reporting and integration specialist to join our Business Intelligence team on a contract basis.You will be responsible for building the data pipelines that extract Wor... Voir plus
Reporting to the Manager, ESG Strategy & Integration, this role plays a central part in delivering Canadian Tire Corporation’s ESG priorities, with a primary focus on enterprise ESG reporting, rati... Voir plus
Developers and test specialists from diverse backgrounds, united by one goal: delivering high-quality solutions that meet and exceed our customers’ evolving needs.We build integrations that are sec... Voir plus
Senior Java Angular Developer – API Integration.Hybrid- 2 days a week in office.Banking and Financial Technology~Core Java~Application Integration Architecture.Act as the end-to-end technical owner... Voir plus
At Alstom, we understand transport networks and what moves people.From high-speed trains, metros, monorails, and trams, to turnkey systems, services, infrastructure, signalling and digital mobility... Voir plus
We are looking for a highly motivated Director – Data Integration Subledgers who will lead and provide strategic direction for the Finance and Risk Data PlatformThe Director – Data Integration Subl... Voir plus
This is a product-focused engineering role where you'll play a key part not just in building, but also in shaping our integration platform (supporting 250+ integrations).You’ll have the opportunity... Voir plus
Senior Java Integration Developer (REST APIs).Shape the future of backend integration solutions within the insurance industry.This hybrid opportunity offers the chance to work on impactful initiati... Voir plus
Guidewire Integration Engineer - Contract.Our client is a global Tier 1 Systems Integrator with projects in Canada and we are looking for someone at the Senior Consultant level for a Guidewire Inte... Voir plus
Job Description -</b></p> <b>SAP RISE Integration Consultant</b><br /> <b>Location - Downtown Toronto, ON (Hybrid 4 Days Onsite)</b><br /> <b&... Voir plus
At eBay, we're more than a global ecommerce leader — we’re changing the way the world shops and sells.Our platform empowers millions of buyers and sellers in more than 190 markets around the world.... Voir plus
We are looking for a highly motivated Director – Data Integration Subledgers who will lead and provide strategic direction for the Finance and Risk Data Platform.The Director – Data Integration Sub... Voir plus
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Join a purpose-driven, high-performing team committed to innovation and impact.We are seeking a... Voir plus
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?
The Data Integration Developer is responsible for the design, development, implementation, and support of robust Finance, HR, Projects, Procurement and Sales/CRM data integrations between our core SaaS business systems and our enterprise data lake. The role will involve working with sources like Workday, Salesforce, and ServiceNow and target platforms including our Snowflake data warehouse, ensuring data quality, reliability, and accessibility for analytics and reporting. This role will work closely with the Senior Business Analyst, SaaS Data & Analytics to build and design the solutions that meet technical integration specifications and business requirements and will work with Finance, HR, Projects, Procurement and Sales/CRM resources to understand, load and test the data.Development and Implementation
Design, develop, test, and implement high-performance, scalable data pipelines, connectors and integrations to extract, transform, and load (ETL/ELT) data from SaaS platforms (Workday, Salesforce, ServiceNow) into the Snowflake data lake.
Write complex SQL queries, stored procedures, and scripts to ensure efficient data manipulation and transformation within the integrations that feed into the Snowflake environment.
Build and optimize data models within Snowflake for high-performance querying.
Ensure data privacy during integrations using masking and/or other anonymization/aggregation technology
Ensure data security during integrations using the most secure authentication and encryption technologies supported by the platforms involved
Design and orchestrate complex integrations across iPaaS platforms, APIs, and other enterprise data services.
Build monitoring dashboards, alerts, and automated testing for pipelines and operations.
Collaborate with the Senior Business Analyst and other technical teams to understand data requirements and translate them into effective integration solutions.
Automate and optimize data integration processes for speed and reliability, monitoring and tuning existing pipelines as needed.
Testing, Quality Assurance, and Support
Help develop detailed unit and integration test plans, scripts, and execute testing to ensure the accuracy and integrity of integrated data.
Support the full business testing cycle, including providing technical support for User Acceptance Testing (UAT) led by the Senior Business Analyst.
Troubleshoot and resolve data integration issues, defects, and performance bottlenecks in a timely manner.
Create and maintain technical documentation, including data flow diagrams, ETL/ELT specifications, and process guides.
Collaboration and Mentorship
Partner closely with the Senior Business Analyst, SaaS Data & Analytics and other technical stakeholders to ensure alignment between integration solutions and business analytics needs.
Adhere to and promote best practices for data governance, security, and quality throughout the data integration lifecycle.
Act as the functional subject matter expert (SME) during the design, development, and implementation phases of new analytics capabilities.
Identify, assess, and solve complex business problems for integrating SaaS source data into the analytics platform.
Act as an ambassador to promote and educate the enterprise on the available analytics +
Must Have(s)
A minimum of 5 years of proven experience in data integration, ETL/ELT development, and data warehousing.
Expert-level experience with SQL for complex querying, data transformation, and performance tuning.
Demonstrated experience developing data integrations from enterprise SaaS applications, such as Workday, Salesforce, or ServiceNow.
Hands-on experience with modern cloud data warehousing technologies, specifically Snowflake.
Experience with one or more ETL/data integration tools (e.g., Fivetran, Informatica, Talend, Azure Data Factory).
Experience with AWS Data Integration tools like Managed Airflow, Lambda, etc.
Strong understanding of data modeling concepts (e.g., dimensional modeling) and data pipeline design.
Proven experience working in an Agile-based project environment.
Excellent analytical, problem-solving, and communication skills, with an ability to work independently.
Bachelor's degree in Computer Science, Information Technology, or a related field.
Salary Range: 105K/year - 115K/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 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.
.
