Senior Data Integration Specialist

1 week ago


Ottawa, Ontario, Canada Canadian Institute for Health Information Full time
About the Role

We are seeking a highly skilled Senior Data Integration Specialist to join our team at the Canadian Institute for Health Information. As a key member of our data team, you will play a critical role in designing and implementing data systems that support our mission to provide high-quality health data and analytics to our stakeholders.

Key Responsibilities
  1. Data System Design and Development

Design and develop data systems that meet the needs of our stakeholders, including data warehouses, data marts, and data integration solutions.

ETL Development

Develop and maintain ETL processes using tools such as Informatica DEI/BDM, PySpark, and Oracle DB.

Cloud Environment Management

Manage and maintain our cloud environment, including AWS services and tools.

Documentation and Knowledge Sharing

Develop and maintain documentation of data system designs, technical artifacts, and ETL environments.

Collaboration and Communication

Work closely with cross-functional teams to ensure data system designs meet business requirements and communicate effectively with stakeholders to ensure data system success.

Requirements
  • Education

University degree or equivalent education/experience in Computer Science, Mathematics, or related discipline.

Experience

Three (3) + years experience as an ETL developer, developing technical solutions for a web/Cloud based environment utilizing the below technologies.

Technical Skills

Proven experience with ETL tools, PySpark, Oracle DB, PL/SQL, Git, Airflow, and Python.

Cloud Environment

Knowledge and experience with Cloud AWS environment, tools, and services is an asset.

Shell Scripting

Proficient knowledge and experience in shell scripting in Linux/Unix environment.

Documentation

Experience in creating and maintaining documentation of project ETL design, technical artifacts, and ETL environment.

What We Offer

We offer a competitive salary and benefits package, as well as opportunities for professional growth and development. If you are a motivated and detail-oriented individual with a passion for data integration and system design, we encourage you to apply for this exciting opportunity.



  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Data Integration Developer to join our team at Nexus Systems Group Inc. as a key member of our Data Integration team.Key Responsibilities:Design, develop, and implement complex data transformations using various data programming languages such as Python and Pyspark.Collaborate with cross-functional teams...


  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Data Integration Developer to join our team at Nexus Systems Group Inc. as a key member of our Data Integration team.Key Responsibilities:Design, develop, and implement complex data transformations using various data programming languages such as Python and Pyspark.Collaborate with cross-functional teams...


  • Ottawa, Ontario, Canada Emtec Full time

    Job SummaryEmtec is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for implementing BMC-ITSM projects and ensuring seamless data integration across various systems.Key ResponsibilitiesDevelop data integration objects and data processing flows using current tools and software.Act as the...


  • Ottawa, Ontario, Canada Emtec Full time

    Job SummaryEmtec is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for implementing BMC-ITSM projects and ensuring seamless data integration across various systems.Key ResponsibilitiesDevelop data integration objects and data processing flows using current tools and software.Act as the...


  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Senior Data Integration (DI) ETL DeveloperNexus Systems Group Inc. is seeking a Senior Data Integration (DI) ETL Developer to enhance our data processing capabilities. In this pivotal role, you will be responsible for efficiently loading target databases through intricate transformations sourced from diverse systems. Your expertise will be essential in...


  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Senior Data Integration (DI) ETL DeveloperNexus Systems Group Inc. is seeking a highly skilled Senior Data Integration (DI) ETL Developer. In this pivotal role, you will be responsible for the intricate task of populating target databases through sophisticated transformations sourced from diverse systems. Your expertise will be essential in ensuring the...


  • Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesInstall, configure, and deploy Data Sentinel for each of our...


  • Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesInstall, configure, and deploy Data Sentinel for each of our...


  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Senior Data Integration (DI) ETL DeveloperNexus Systems Group Inc. is seeking a highly skilled Senior Data Integration (DI) ETL Developer. In this pivotal role, you will be responsible for the efficient loading of target databases, implementing intricate transformations from diverse data sources. Your expertise will be essential in ensuring smooth data...


  • Ottawa, Ontario, Canada Emtec Full time

    Job SummaryThe Integration Specialist will play a key role in Emtec's IT Service Management (ITSM) projects, working closely with clients to design, implement, and maintain data integration solutions. This position requires a strong understanding of ITSM technology, including ITSM applications, administration, and development.Key ResponsibilitiesDevelop data...


  • Ottawa, Ontario, Canada Emtec Full time

    Job SummaryThe Integration Specialist will play a key role in Emtec's IT Service Management (ITSM) projects, working closely with clients to design, implement, and maintain data integration solutions. This position requires a strong understanding of ITSM technology, including ITSM applications, administration, and development.Key ResponsibilitiesDevelop data...


  • Ottawa, Ontario, Canada ECF Data, LLC Full time

    About the RoleWe are seeking a highly skilled and experienced Data Collection/Analytical Specialist to join our team at ECF Data, LLC. As a key member of our organization, you will be responsible for gathering, cleaning, and analyzing data to provide actionable insights that drive business growth.Key ResponsibilitiesInterpret complex data sets, analyze...


  • Ottawa, Ontario, Canada ECF Data, LLC Full time

    About the RoleWe are seeking a highly skilled and experienced Data Collection/Analytical Specialist to join our team at ECF Data, LLC. As a key member of our organization, you will be responsible for gathering, cleaning, and analyzing data to provide actionable insights that drive business growth.Key ResponsibilitiesInterpret complex data sets, analyze...


  • Ottawa, Ontario, Canada Tree Trust Full time

    **About Us**Tree Trust is a leading organization in the field of financial systems integration and configuration. We empower our clients with the insights they need to make informed decisions with speed and confidence.Our fast, intuitive feedback management platform connects millions of users worldwide with real-time AI-powered insights that drive meaningful...


  • Ottawa, Ontario, Canada Tree Trust Full time

    **About Us**Tree Trust is a leading organization in the field of financial systems integration and configuration. We empower our clients with the insights they need to make informed decisions with speed and confidence.Our fast, intuitive feedback management platform connects millions of users worldwide with real-time AI-powered insights that drive meaningful...


  • Ottawa, Ontario, Canada CMHC Full time

    About the RoleWe are seeking a highly skilled Senior Specialist, Data Governance to join our Enterprise Data Office at CMHC. In this role, you will play a critical part in supporting the design, development, implementation, maintenance, evolution, and enhancement of our Information Management (IM) functions.Key ResponsibilitiesDevelop and maintain...


  • Ottawa, Ontario, Canada CMHC Full time

    About the RoleWe are seeking a highly skilled Senior Specialist, Data Governance to join our Enterprise Data Office at CMHC. In this role, you will play a critical part in supporting the design, development, implementation, maintenance, evolution, and enhancement of our Information Management (IM) functions.Key ResponsibilitiesDevelop and maintain...


  • Ottawa, Ontario, Canada Senior Care Authority of Inland Empire, CA Full time

    About the JobWe are seeking a highly skilled Senior Integration Developer to join our team at the Senior Care Authority of Inland Empire, CA. As a key member of our development team, you will be responsible for designing and implementing complex software systems, integrating various components, and ensuring seamless functionality.Key ResponsibilitiesDevelop...


  • Ottawa, Ontario, Canada Senior Care Authority of Inland Empire, CA Full time

    About the JobWe are seeking a highly skilled Senior Integration Developer to join our team at the Senior Care Authority of Inland Empire, CA. As a key member of our development team, you will be responsible for designing and implementing complex software systems, integrating various components, and ensuring seamless functionality.Key ResponsibilitiesDevelop...


  • Ottawa, Ontario, Canada Telesat Full time

    About the RoleWe are seeking a highly skilled Senior Integration and Test Specialist to join our team at Telesat. As a key member of our System Engineering department, you will play a critical role in the development and maintenance of our Telesat LEO constellation communication system.Main ResponsibilitiesDevelop and maintain system verification and...