About the role
We are looking for a Data Integration Specialist to join an enterprise team and help build, optimize, and maintain reliable data solutions that support operational decision-making.
This role is ideal for someone with a strong background in data engineering, database development, ETL/ELT processes, and data quality management who enjoys working with complex datasets and building scalable solutions.
Location: Downtown Toronto (Hybrid) Employment Type: Full-Time
What You’ll Be Doing: Design, develop, and maintain relational database structures using PostgreSQL Build and enhance ETL/ELT workflows to integrate data from multiple sources Develop data transformation, validation, and automation processes using SQL and Python Create data models and optimize database performance for operational datasets Perform data reconciliation, cleansing, standardization, and quality improvements Develop processes for entity matching, record validation, and maintaining trusted datasets Collaborate with business and technical teams to improve data reliability and accessibility Identify opportunities to automate manual processes and improve efficiency What We’re Looking For: 3+ years of experience in Data Integration, Data Engineering, Database Development, or related roles Strong hands-on experience with SQL and Python Experience working with PostgreSQL including database design, schemas, indexing, and optimization Experience building and maintaining data pipelines and ETL/ELT solutions Strong understanding of relational data modelling and database structures Experience with data quality, validation, reconciliation, and standardization Ability to work with large, complex datasets from multiple sources Nice to Have: Experience with Master Data Management (MDM) Knowledge of entity resolution, matching algorithms, or record linkage Experience with data governance, lineage, or audit processes Background supporting operational, infrastructure, location-based, or customer data environments
Not the right fit? Search for Data Integration Specialist jobs in Toronto, Ontario, Canada
About ThoughtStorm
ThoughtStorm is a global firm providing consulting solutions and services to organizations of all sizes across various industries.
For us, every client is unique, and although many of our clients face similar business and technology challenges, no two businesses are alike. We strive to address our clients’ needs with a holistic, all-encompassing, customized approach. This involves gaining a deep understanding of our client’s business, processes, supporting technologies and their corporate culture. Having this understanding allows us to embark on an approach to design and implement solutions that are tailored for our client’s environment and are sustainable long into the future.
Our consultants engage with all levels within the organization, from frontline staff to the executive team, ensuring that our solutions align across the entire organizational spectrum. With this direct team based approach, our results are quick, exceeding our clients’ expectations.
Similar Jobs
About the role
We are looking for a Data Integration Specialist to join an enterprise team and help build, optimize, and maintain reliable data solutions that support operational decision-making.
This role is ideal for someone with a strong background in data engineering, database development, ETL/ELT processes, and data quality management who enjoys working with complex datasets and building scalable solutions.
Location: Downtown Toronto (Hybrid) Employment Type: Full-Time
What You’ll Be Doing: Design, develop, and maintain relational database structures using PostgreSQL Build and enhance ETL/ELT workflows to integrate data from multiple sources Develop data transformation, validation, and automation processes using SQL and Python Create data models and optimize database performance for operational datasets Perform data reconciliation, cleansing, standardization, and quality improvements Develop processes for entity matching, record validation, and maintaining trusted datasets Collaborate with business and technical teams to improve data reliability and accessibility Identify opportunities to automate manual processes and improve efficiency What We’re Looking For: 3+ years of experience in Data Integration, Data Engineering, Database Development, or related roles Strong hands-on experience with SQL and Python Experience working with PostgreSQL including database design, schemas, indexing, and optimization Experience building and maintaining data pipelines and ETL/ELT solutions Strong understanding of relational data modelling and database structures Experience with data quality, validation, reconciliation, and standardization Ability to work with large, complex datasets from multiple sources Nice to Have: Experience with Master Data Management (MDM) Knowledge of entity resolution, matching algorithms, or record linkage Experience with data governance, lineage, or audit processes Background supporting operational, infrastructure, location-based, or customer data environments
Not the right fit? Search for Data Integration Specialist jobs in Toronto, Ontario, Canada
About ThoughtStorm
ThoughtStorm is a global firm providing consulting solutions and services to organizations of all sizes across various industries.
For us, every client is unique, and although many of our clients face similar business and technology challenges, no two businesses are alike. We strive to address our clients’ needs with a holistic, all-encompassing, customized approach. This involves gaining a deep understanding of our client’s business, processes, supporting technologies and their corporate culture. Having this understanding allows us to embark on an approach to design and implement solutions that are tailored for our client’s environment and are sustainable long into the future.
Our consultants engage with all levels within the organization, from frontline staff to the executive team, ensuring that our solutions align across the entire organizational spectrum. With this direct team based approach, our results are quick, exceeding our clients’ expectations.