ETL Consultant

ETL Consultant

Offer parameters
TEEMA
Vancouver, British Columbia, Canada

Woke Type

full-time

About

Our client is seeking a ETL Developer to join their Agile Data Solutions team. You’ll work closely with the Product Owner, Data Architect, Scrum team, and business stakeholders to design, develop, and maintain data pipelines using a range of Azure services.

Key Responsibilities :

  • Design, develop, test, and deploy end-to-end data pipelines using SSIS, Azure Data Factory, Databricks, and other Azure technologies
  • Ingest and transform data from diverse sources (e.g., API, Data Lakes) into the Azure Data Lake
  • Ensure quality by unit testing ETL code, supporting QA / UAT, and preparing deployment plans
  • Document and transfer knowledge to the Data Solutions team
  • Contribute to sprint planning, break down features into stories, and demonstrate progress in sprint reviews
  • Create automated tests and maintain data pipelines in the code repository

Required Qualifications :

  • 5+ years of ETL experience, including SSIS & SQL Server (2012 2019)
  • Strong knowledge of Azure services (Data Factory, Databricks, Synapse, Data Lake, etc.)
  • Experience with Spark (PySpark / Python) and cloud data migration
  • Expertise in designing Data Lakes, Data Warehouses, and ETL / ELT pipelines
  • Diploma in Computer Science or related field
  • Hands-on experience in Agile / Scrum methodology and strong communication skills

Nice to have :

  • Experience working in a unionized environment.