Data Architecture ETL Consultant

1 day ago

Montreal, QC, Canada Envision Technology Solutions Full-time $90,000 - $140,000 Contract

Design data architecture and optimize ETL processes as a Consultant using Microsoft SQL Server and SSIS across integrated systems.

This ETL Consultant develops data models, data warehousing solutions, and reliable integration processes. The work combines data engineering, process engineering, and workflow optimization. You will also review enterprise architectures and translate business needs into technical solutions.

Key Responsibilities:

  • Design data architecture solutions supporting business and technical requirements
  • Develop robust data models and data warehousing solutions
  • Maintain and optimize ETL processes using Microsoft SQL Server and SSIS
  • Ensure data integrity and accessibility across integrated systems
  • Identify architecture improvements through enterprise reviews

Requirements:

  • Strong experience in data architecture and data engineering
  • Hands-on Microsoft SQL Server, SSIS, and ETL development expertise
  • Solid understanding of data modeling and data warehousing
  • Experience conducting enterprise architecture reviews
  • Knowledge of process engineering and workflow optimization methodologies

Apply data engineering, SQL Server, SSIS, and architecture review expertise to strengthen integrated data solutions.