Data Integration Specialist

2 days ago

Vancouver, British Columbia, Canada Trez Capital Full time
Job Summary

Trez Capital is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.

Key Responsibilities
  • Develop and Implement Data Integration Solutions
    • Design, develop, and maintain ETL processes to support data integration and reporting solutions using SQL, Power BI, or other data management software.
    • Work with various departments and personnel to create business cases and facilitate implementing new business processes, process redesign, and technology deployment with well-thought-out requirements, functional, and technical blueprints, and project plans to achieve desired business goals.
  • Maintain Enterprise Segment Architecture
    • Assist with maintaining the Enterprise Segment Architecture, including the Data Dictionary.
  • Design and Develop Reports
    • Design, develop, and deploy reports to provide new insights into the business.
  • Database Management
    • Develop, maintain, troubleshoot, and upgrade M/S SQL databases and code (ETL processes).
    • Build, manage, and monitor automated routines.
  • Integration and Reconciliation
    • Reconcile data and work with users to sanitize data where necessary (includes identifying and remediating data inconsistencies).
  • Additional Accountabilities
    • Comply with all policies and procedures, work rules, and standard operating procedures.
    • Safeguard the interests of the business, our people, and our clients.
    Requirements
    • Education and Experience
      • Undergraduate or other advanced degree in a quantitative discipline with applicable work experience in data management.
      • Experience working with relational databases and normalized data.
      • A minimum of 2 years using Microsoft SQL and one or more scripting languages in a data science/warehouse/management, financial analysis, or business intelligence role.
      • A minimum of 2 years experience implementing solutions with PowerBI, PowerApps, and PowerAutomate.
      • Experience integrating financial and operational data from multiple systems.
      • Practical experience with self-auditing solutions before delivery and development of solutions without technical requirements or project plans.
      • Prior experience with SalesForce, nCino, Great Plains, or Loan Servicing software is preferred but not mandatory.
    • Core Competencies
      • Able to clearly communicate with technical resources and business users, to develop business cases and solutions.
      • Ability to understand and explain each discipline of analytics, data management, data architecture, and programming.
      • Proficient in self-planning skills with the ability to schedule, organize, and manage multiple activities of varying complexity according to established plans and adjust work schedules according to changing priorities and time constraints.
      Working Conditions

Standard office environment.

  • Data Integration Specialist

    6 days ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About the RoleTrez Capital is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our Data Analytics department, you will play a critical role in developing, implementing, and maintaining data integration and reporting solutions to drive business growth and improvement.Key ResponsibilitiesDevelop and implement ETL...

  • Data Integration Specialist

    1 week ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About the RoleTrez Capital is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our Data Analytics department, you will play a critical role in developing, implementing, and maintaining data integration and reporting solutions to drive business growth and improvement.Key ResponsibilitiesDevelop and implement ETL...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    1 week ago

    Vancouver, British Columbia, Canada Alloy Full time

    About AlloyAlloy is a fast-growing, well-funded startup that specializes in providing data integration solutions to consumer goods companies. Our team is comprised of experienced professionals from successful startups, leading tech companies, and Fortune 100 enterprises.About the RoleOur network-based data platform is a core strategic asset for Alloy. As an...

  • Data Integration Specialist

    6 days ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About the RoleTrez Capital is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    1 week ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About the RoleTrez Capital is seeking a highly skilled Data Integration Specialist to join our team. As a key member of our Data Analytics department, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Accoravillage Full time $73,485 - $105,570

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Accoravillage. As a key member of our data analytics team, you will be responsible for developing, implementing, and maintaining data integration and reporting solutions to improve analytical reporting, digitization, and process efficiencies.Key...

  • Data Integration Specialist

    2 days ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About Trez CapitalTrez Capital is a leading provider of private commercial real estate debt and equity financing solutions in Canada and the United States. With over 25 years of experience, we have consistently provided developers and owners with flexible short-to-mid-term financing. Our company is built on a reputation of transparency, integrity, and a...

  • Data Integration Specialist

    2 days ago

    Vancouver, British Columbia, Canada Trez Capital Full time $73,485 - $105,570

    About Trez CapitalTrez Capital is a leading provider of private commercial real estate debt and equity financing solutions in Canada and the United States. With over 25 years of experience, we have consistently provided developers and owners with flexible short-to-mid-term financing. Our company is built on a reputation of transparency, integrity, and a...

  • Senior Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada CB Canada Full time

    Job SummaryCB Canada is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing SSIS solutions to execute systems integrations and data migrations.Key ResponsibilitiesDesign and Develop SSIS Solutions: Create and implement...

  • Senior Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada CB Canada Full time

    Job SummaryCB Canada is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and implementing SSIS solutions to execute systems integrations and data migrations.Key ResponsibilitiesDesign and Develop SSIS Solutions: Create and implement...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Tektronit Full time

    About TektronitWe are a leading technology company that specializes in data-driven solutions. Our team is passionate about leveraging data to drive business growth and improvement.Job SummaryWe are seeking an experienced ETL Developer to join our team. The successful candidate will be responsible for designing, developing, and maintaining our data...

  • Data Integration Specialist

    5 days ago

    Vancouver, British Columbia, Canada Tektronit Full time

    About TektronitWe are a leading technology company that specializes in data-driven solutions. Our team is passionate about leveraging data to drive business growth and improvement.Job SummaryWe are seeking an experienced ETL Developer to join our team. The successful candidate will be responsible for designing, developing, and maintaining our data...

  • Data Integration Specialist

    3 hours ago

    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,...

  • Data Integration Specialist

    29 minutes ago

    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,...

  • Data Integration Specialist

    7 days ago

    Vancouver, British Columbia, Canada Alloy Full time

    About AlloyAlloy is a fast-growing, well-funded startup that specializes in providing data integration solutions to consumer goods companies. Our team is comprised of experienced professionals from successful startups, leading tech companies, and Fortune 100 enterprises.We believe in fostering individual ownership, iterating to excellence, focusing on what...

  • Data Integration Specialist

    6 days ago

    Vancouver, British Columbia, Canada Alloy Full time

    About AlloyAlloy is a fast-growing, well-funded startup that specializes in providing data integration solutions to consumer goods companies. Our team is comprised of experienced professionals from successful startups, leading tech companies, and Fortune 100 enterprises.We believe in fostering individual ownership, iterating to excellence, focusing on what...

  • Technical Support Specialist

    1 week ago

    Vancouver, British Columbia, Canada Remarcable Inc. Full time

    Job SummaryRemarcable Inc. is seeking a highly skilled Technical Support Specialist to join our team. As a Technical Support Specialist, you will play a critical role in ensuring the smooth operation of our cloud-based platform, which helps electrical contractors and distributors streamline purchasing processes.Key ResponsibilitiesAssist in integrating...