Expert Data Integration Specialist, SSIS

2 weeks ago


Vancouver, British Columbia, Canada CB Canada Full time

**Data Integration Expert Wanted**

At CB Canada, we are seeking a highly skilled Data Integration Expert to join our team.

The ideal candidate will have extensive experience with SSIS solutions, system integrations, and data migrations. They will also be proficient in leveraging SSIS experience to reverse engineer, modify, and manage existing integrations supporting critical business processes.

**Responsibilities**

  • Support and develop SSIS solutions for system integrations and data migrations
  • Leverage SSIS experience to troubleshoot system integrations and ensure optimal performance and availability
  • Respond to system-related alerts and escalations, and work with the Director of Data Systems on implementing permanent solutions to recurring problems
  • Own, track, communicate, and resolve integration-related incidents and requests
  • Write SQL, stored procedures, triggers, views, tables, and indexes
  • Participate in peer reviews of code and processes to ensure high-quality deliverables
  • Gather and analyze business needs in collaboration with Management, Data/Business Analysts, End Users, and others

**Requirements**

  • Experience with using, building, and maintaining SOAP and Rest Based APIs and ETLs
  • Experience with building and maintaining Microsoft Azure DevOps and SSIS integrations
  • Experience with SQL Database development, management, and administration
  • Experience with developing and managing SQL queries and reports
  • Experience with developing and building dashboards using reporting tools like Power BI, Tableau, etc.
  • Experience with coding, development, and scripting to integrate and automate workflows
  • Experience with Microsoft Azure cloud integration and database services

**Work Arrangements**

100% Remote and 2 days onsite after Covid restriction is lifted, British Columbia based



  • Vancouver, British Columbia, Canada Global Pharma Tek Full time

    Job Description:As a Software Development Specialist - Data Integration at Global Pharma Tek, you will be responsible for mapping out and documenting data flows within SSIS packages related to the MHSU MRR dataset. This includes source and destination data stores, transformations, and conditional logic.Data Governance ComplianceYou will ensure that all...


  • Vancouver, British Columbia, Canada CB Canada Full time

    Job Title: Intermediate Data Integration Developer, SSISCB Canada is seeking an experienced Intermediate Data Integration Developer, SSIS to join our team.Job SummaryWe are looking for a skilled Intermediate Data Integration Developer, SSIS to support and develop SSIS solutions executing systems integrations and data migrations. The ideal candidate will have...


  • Vancouver, British Columbia, Canada CB Canada Full time

    Intermediate Data Integration Developer, SSISCB Canada is seeking an experienced Intermediate Data Integration Developer, SSIS to join our team.Key Responsibilities:Design, develop, and maintain SSIS solutions for system integrations and data migrations.Reverse engineer, modify, and manage existing integrations to support critical business processes.Monitor,...


  • Vancouver, British Columbia, Canada Global Pharma Tek Full time

    Data Flow Documentation SpecialistAt Global Pharma Tek, we are seeking a highly skilled Data Flow Documentation Specialist to join our team. The successful candidate will be responsible for mapping out and documenting all data flows within our SSIS packages related to the MHSU MRR dataset. This includes source and destination data stores, transformations,...


  • Vancouver, British Columbia, Canada DSI Recruiting Full time

    We are seeking a seasoned Data Modeling and Integration Expert to drive data-centric projects at DSI Recruiting.This role plays a pivotal part in understanding complex business requirements, analyzing data, and translating those needs into technical solutions. You will be responsible for designing and optimizing data models, ensuring seamless database...


  • Vancouver, British Columbia, Canada British Columbia Lottery Corporation Full time

    About the RoleWe are looking for a skilled Data Integration Specialist 3 to join our Data Services team at the British Columbia Lottery Corporation.As a key member of our team, you will design, develop, and maintain BCLC's data integration solutions.Your responsibilities will include developing ETL workflows, supporting the Enterprise Data Warehouse (EDW)...


  • Vancouver, British Columbia, Canada AbCellera Full time

    About the RoleWe are seeking a skilled Data Integrity and Governance Manager to join our Digital Quality team at AbCellera. As a key member of our team, you will be responsible for driving the implementation of an effective GxP data integrity governance program across the entire product lifecycle.Key Responsibilities:Develop and execute DI plans, process...


  • Vancouver, British Columbia, Canada NTT DATA Full time

    Job OverviewWe are seeking an experienced Digital Portfolio Optimization Specialist to join our team in Vancouver, British Columbia, Canada. This role is critical in optimizing our integrated portfolio by combining analysis of business, financial, technology, and risk perspectives.About the RolePortfolio Rationalization/Optimization: Lead the rationalization...


  • Vancouver, British Columbia, Canada AbCellera Full time

    About the RoleWe are seeking a highly skilled Data Integrity and Governance Specialist to join our Digital Quality team at AbCellera. As a key member of our team, you will work closely with GxP operational subject matter experts, the Information Technology team, and cross-functional system analysts and developers to define, design, and execute data...


  • Vancouver, British Columbia, Canada D2L Full time

    Role SummaryAs a Senior Integration Specialist at D2L, you will be responsible for designing, developing, and maintaining seamless integrations between various applications and systems using the Workato platform. This role involves collaborating with customers to understand business requirements, creating efficient workflows, and ensuring data accuracy and...


  • Vancouver, British Columbia, Canada Amazon Full time

    Unlock your potential as a Senior Data Engineering Specialist at Amazon.About the RoleWe are seeking an experienced data engineer to join our team in designing, managing, and continuously enhancing our data and analytics infrastructure. This includes process automation/improvements, developing automated reporting solutions/tools, and improving the ability of...


  • Vancouver, British Columbia, Canada AbCellera Full time

    About the RoleAbCellera is seeking a Data Integrity and Governance Manager to drive the implementation of an effective GxP data integrity governance program across the entire product lifecycle. This role will ensure that Health Authority Regulatory expectations are met thoroughly, effectively, and efficiently.Key ResponsibilitiesDevelop and execute data...


  • Vancouver, British Columbia, Canada Arc'teryx Full time

    Key Role in ERP and Business Systems TeamThe SAP Integration Specialist will be a key part of the ERP and Business Systems team and will be responsible for participating in integration solutions from design to handover. This role will work closely with stakeholders, the internal technology teams, and vendors to co-create solutions that will evolve our...


  • Vancouver, British Columbia, Canada AbCellera Full time

    At AbCellera, we are breaking the barriers of conventional drug development to propel antibody-based medicines from target to clinic. Our team of scientists, engineers, creatives, and business professionals believe that advancing science enhances lives. We have developed technologies to unlock high-value drug targets, including antibody-drug conjugates and...


  • Vancouver, British Columbia, Canada AbCellera Full time

    About the RoleWe are seeking a highly skilled Data Integrity and Governance Manager to join our Digital Quality team at AbCellera. As a key member of our team, you will play a critical role in defining, designing, and executing data governance processes that address health authority regulated compliance expectations for all related systems and data across...


  • Vancouver, British Columbia, Canada Canfor Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Integration Specialist to join our team at Canfor. As a key member of our organization, you will be responsible for designing, implementing, and maintaining complex cloud-based data integration systems.


  • Vancouver, British Columbia, Canada AbCellera Full time

    At AbCellera, we are breaking the barriers of conventional drug development to propel antibody-based medicines from target to clinic. Our team of scientists, engineers, creatives, and business professionals believe that advancing science enhances lives. We have developed technologies to unlock high-value drug targets, including antibody-drug conjugates and...


  • Vancouver, British Columbia, Canada Canfor Full time

    Integration Specialist Role OverviewCanfor is seeking a highly skilled Integration Specialist to join our team. As an Integration Specialist, you will be responsible for designing, developing, testing, supporting, and maintaining A2A and B2B (EDI) integrations using Software AG webMethods-related technologies and Azure stack.Key ResponsibilitiesAnalysis,...


  • Vancouver, British Columbia, Canada CB Canada Full time

    CB Canada is seeking a skilled Data Integration Project Lead to join their team.About the JobThis 18-month contract role will play a pivotal part in merging four key databases due to a recent acquisition. The successful candidate will ensure that each individual business unit's requests (tickets logged in Jira) achieve their milestones.Key...


  • Vancouver, British Columbia, Canada Arc'teryx Full time

    Your Opportunity at Arc'teryx:The SAP Integration Specialist will be a key part of the ERP and Business Systems team and will be responsible for participating in integration solutions from design to handover. This role will work closely with stakeholders, the internal technology teams, and vendors to co-create solutions that will evolve our current system...