Data Integration DeveloperResponsible for the design, development, implementation, and support of robust Finance, HR, Projects, Procurement, and Sales/CRM data integrations between core SaaS business systems and the enterprise data lake. Works with sources such as Workday, Salesforce, and ServiceNow, targeting the Snowflake data warehouse to ensure data quality, reliability, and accessibility for analytics and reporting.Responsibilities- Design, develop, test, and implement high-performance, scalable data pipelines, connectors, and integrations to extract, transform, and load (ETL/ELT) data from SaaS platforms into the Snowflake data lake.- Write complex SQL queries, stored procedures, and scripts to efficiently manipulate and transform data within the integrations feeding the Snowflake workplace.- Build and optimize data models within Snowflake for high-performance querying.- Ensure data privacy during integrations using masking and/or anonymization/aggregation technologies.- Ensure data security during integrations using secure authentication and encryption technologies.- 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 translate data requirements into effective integration solutions.- Automate and optimize data integration processes for speed and reliability,



monitoring and tuning existing pipelines as needed.- Develop detailed unit and integration test plans and scripts; execute testing to ensure 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.- Act as the functional subject-matter expert (SME) during 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.- Collaborate 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.Qualifications- 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.CompensationSalary 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.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.EEO StatementTMX 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.#J-18808-Ljbffr

📌 Integration Developer - C$105,000 - C$115,000 A Year (Toronto)
🏢 TMX
📍 Toronto