Senior Data Integration Specialist

5 days ago


Toronto, Ontario, Canada Intact Financial Corporation Full time

At Intact Financial Corporation, we're shaping the future of insurance with cutting-edge technology. As a Senior Data Integration Specialist, you'll play a pivotal role in transforming our customer experience for millions of Canadians.

About the Role

We're seeking a seasoned expert to lead our data integration efforts, leveraging expertise in Informatica PowerCenter, IICS, Snowflake, and Oracle databases. If you have at least 7 years of experience in this domain and a passion for ETL-ELT techniques, we want to hear from you

Your Mission:
  • Collaborate with our IT departments to analyze, develop, test, and deploy solutions that maintain or integrate new business areas into our Enterprise Data Platform and Snowflake migration.
  • Translate business requirements into technical specifications and design innovative data ingestion & consumption pipelines.
  • Take leadership in defining Software Engineering best practices regarding code standardization, branching strategy, pipeline code optimization, cost optimization, design patterns, etc.
  • Work closely with Solution and Enterprise Architects to address unique business problems, provide project estimates, and design complex data transformations solutions using suitable tools and technologies.
  • Document implementation steps, produce quality evidence, create, and maintain system documentation.
  • Provide technical support to Business Intelligence analysts, testers, and deployment coordinators throughout our development cycle and for production support.
What You Bring to the Table:
  • A bachelor's degree in information technology / software engineering or any equivalent combination of training and experience.
  • Strong experience with Informatica PowerCenter, IICS, Snowflake, and Oracle databases (at least 7 years).
  • Hands-on experience with PL/SQL, Java, and Python programming is a plus.
  • Minimum 5 years of hands-on experience with data integration (data warehouse).
  • Strong knowledge of ETL (Extract, Transform, Load) techniques and different data ingestion patterns.
  • Working experience with Data Vault and Relational Data Models.
  • Knowledge of insurance or financial sector will be advantageous.
  • Assets: Databricks, SAS Enterprise Guide, GIT, Jenkins, Business Objects, and Power BI.
  • Strong presentation, facilitation, verbal, and written communication skills, including interpersonal skills.
You Are:
  • A developer with a passion for data integration and transformation (ETL-ELT).
  • A visionary with an innovative spirit.
  • A committed and open team player.
  • Versatile, autonomous, curious, and resourceful.
  • Somone who learns quickly and is curious about new technologies.
  • Comfortable in complex environments and multidisciplinary teams.
  • Available for second-level production support.
  • Open to new and emerging technologies for code automation, testing, and deployment.
  • No Canadian work experience required; however, must be eligible to work in Canada.
Estimated Salary: $120,000 - $150,000 per annum.

  • Toronto, Ontario, Canada CB Canada Full time

    Senior Data Integration SpecialistAt CB Canada, we are seeking a highly skilled Senior Data Integration Specialist to join our team. The ideal candidate will have expertise in designing and implementing complex data integration solutions using Azure Cloud, HiveQL, PySpark, SAS, and Unix Shell Scripts.Key Responsibilities:Design and develop ETL software...


  • Toronto, Ontario, Canada Foilcon Full time

    Foilon Career OverviewAt Foilcon, we're dedicated to innovation and excellence in the field of data integration. Our team is passionate about creating seamless solutions that meet the evolving needs of our clients.About This RoleWe're seeking a highly skilled Senior Data Integration Specialist to join our team! As a key member of our data engineering group,...


  • Toronto, Ontario, Canada Foilcon Full time

    Foilcon is seeking a highly skilled Senior ETL Data Integration Specialist to join our team.About the RoleWe are looking for an experienced professional with expertise in ETL processes, data integration, and data quality. The ideal candidate will have a strong background in Java development, IBM InfoSphere Master Data Management, and Health Information...


  • Old Toronto, Ontario, Canada Blanc Labs Inc. Full time

    Blanc Labs is a leading partner for global enterprises, driving digital transformation and innovation. We are seeking an experienced Senior Data Integration Specialist to lead our ETL development efforts and work closely with a prestigious banking client. The ideal candidate will have a proven track record in leading ETL projects, driving data integration...


  • Old Toronto, Ontario, Canada Enable International Full time

    Unlock the Power of Data IntegrationAt Enable International, we're revolutionizing the way companies manage their supply chains. As a Senior Data Integrations Developer, you'll play a crucial role in shaping the future of rebate management.As a key member of our team, you'll work closely with Customer Success Managers and onboarding teams to configure data...


  • Toronto, Ontario, Canada Nova Tribes Inc Full time

    We are seeking an experienced Senior Data Integration Specialist to support our data integration efforts in Qlik Compose, Qlik Replicate, and Qlik Cloud. This role involves designing and implementing data models, integrating multiple data sources, and building data marts on top of a data warehouse.Key Responsibilities:Data Modeling: Design and implement data...


  • Toronto, Ontario, Canada NTT DATA Full time

    About the RoleWe are seeking a skilled Mulesoft Integration Specialist to join our team in Toronto, Ontario (CA-ON), Canada (CA).Job ResponsibilitiesCreate reusable components, standards, templates, guidelines, patterns to be used by other team members using MuleSoft Integration platform.Conduct workshops with stakeholders to understand and analyze business...


  • Toronto, Ontario, Canada Canadian Tire Corporation Full time

    Key ResponsibilitiesAs a Senior Integration Specialist at Canadian Tire Corporation, you will play a vital role in ensuring seamless data integration, enhancing operational efficiency, and enabling data-driven decision-making. Your primary responsibilities will include:Developing integration strategies and plans based on business requirements and existing...


  • Toronto, Ontario, Canada Nova Tribes Inc Full time

    Job Title: Qlik Data Integration SpecialistAbout the Role:We are seeking an experienced Qlik Data Integration Specialist to join our team at Nova Tribes Inc. As a key member of our data integration team, you will be responsible for designing, implementing, and maintaining data models in Qlik Compose, integrating multiple data sources into a data warehouse,...


  • Old Toronto, Ontario, Canada Movable Ink Full time

    Job SummaryMovable Ink is seeking a highly skilled Senior Backend Integration Specialist to join our team. As a key member of our engineering team, you will be responsible for designing, developing, and maintaining seamless and secure connections between our product and third-party marketing technology platforms.About the RoleAs a Senior Backend Integration...


  • Toronto, Ontario, Canada Hard Rock Digital Full time

    Job OverviewWe are seeking an experienced Data Integration Specialist to join our team at Hard Rock Digital. As a key member of our corporate analytics platform, you will play a crucial role in supporting and enhancing our data infrastructure.


  • Toronto, Ontario, Canada Nova Tribes Inc Full time

    Job DescriptionWe are seeking an experienced Qlik Data Integration Specialist to join our team at Nova Tribes Inc. This role involves data modeling, integrating multiple data sources, and building data marts on top of a data warehouse.Key ResponsibilitiesData Integration: Use Qlik Compose, Qlik Replicate, and Qlik Cloud to support data integration, with a...


  • Toronto, Ontario, Canada Nova Tribes Inc Full time

    Job Title: Qlik Data Integration SpecialistAbout the Role:We are seeking an experienced Qlik Data Integration Specialist to join our team at Nova Tribes Inc. As a key member of our data integration team, you will be responsible for designing, implementing, and maintaining data integration solutions using Qlik Compose, Qlik Replicate, and Qlik Cloud.Key...


  • Toronto, Ontario, Canada Nova Tribes Inc Full time

    Data Integration Specialist Job DescriptionWe are seeking an experienced Data Integration Specialist to join our team at Nova Tribes Inc. The ideal candidate will have extensive knowledge of Qlik Compose, Qlik Replicate, and Qlik Cloud, with a minimum of 5 years of experience in data integration and modeling.Key Responsibilities:Qlik Tools: Utilize Qlik...


  • Toronto, Ontario, Canada Mc Carthy Tetrault Full time

    Job Title: Senior Manager, Knowledge Integration SpecialistMc Carthy Tetrault is seeking a Senior Manager, Knowledge Integration Specialist to lead the firm's Knowledge Integration function – maintaining and developing precedents, and managing adoption of knowledge asset development and governance.Key Responsibilities:Leading the firm's Knowledge...


  • Toronto, Ontario, Canada ShoreWise Consulting Full time

    OverviewShoreWise Consulting is a cutting-edge IT solution provider that offers innovative technology solutions and managed services in various verticals, including Customer Contact, Healthcare, and Finance.We are looking for an experienced Senior Data Integration Specialist to join our team and contribute to the success of our clients.Job DescriptionThe...


  • Toronto, Ontario, Canada Arkfield Development Corp. Full time

    Arkfield Development Corp. is currently seeking a skilled Senior Data Management Specialist to join our team.About the JobThe successful candidate will be responsible for coordinating the development, installation, integration, and operation of computer-based systems.Create data collection and processing methods that meet the company's needs.Develop policies...


  • Toronto, Ontario, Canada NTT DATA Full time

    About the Role We are seeking a highly skilled Senior Mulesoft Developer to join our team in Toronto, Ontario. As a key member of our team, you will be responsible for designing and implementing technical solutions using the MuleSoft platform. Key Responsibilities: Provide technical leadership and guidance to development teams on the use of MuleSoft. Create...


  • Toronto, Ontario, Canada Gallagher Full time

    Job OverviewGallagher Bassett is seeking a meticulous and experienced Senior Data Integration (ETL) Developer to develop, optimize and oversee conceptual and logical data systems. As the Data Architect, you will be responsible for conceiving and portraying the data picture. This role involves initiating, evaluating, and influencing projects from an...


  • Toronto, Ontario, Canada Gallagher Full time

    Job OverviewGallagher Bassett is seeking a meticulous and experienced Senior Data Integration (ETL) Developer to develop, optimize, and oversee conceptual and logical data systems. As the Data Architect, you will be responsible for conceiving and portraying the data picture. This role involves initiating, evaluating, and influencing projects from an...