SQL Server ETL Developer (3-month contract)


About Us

BGC Engineering Inc. (BGC) is an international consulting firm that provides professional services in applied earth sciences. We work together as one team, with coordination and integration of all offices and disciplines. Currently there are over 450 employees, consisting of professional engineers, geoscientists, technicians, software developers, administrators, accountants, health & safety and human resources professionals. BGC has offices in British Columbia, Alberta, Ontario, New Brunswick and Nova Scotia, as well as Colorado, US and Santiago, Chile.

Our flat management structure and unique culture create a work environment where employees can grow professionally, receive mentorship opportunities, work with fantastic teams and enjoy perks such as lunchtime yoga and companywide clubs.

The Role

BGC is looking for an Extract, Transform and Load (ETL) Developer to join our Reporting & Data Analysis team to develop and enhance the BGC Data Warehouse. The successful candidate will be responsible for the development, management, performance, and optimization of the ETL process using Microsoft platforms. This is a 3-month, temporary position to start, with the possibility of an extension as the project requires.


  • Collaborate with business subject matter experts to design and develop ETL processes using SQL Server database, SQL Scripts and SQL Server Integration Services (SSIS)
  • Develop ETL packages and data pipelines to integrate disparate data sources into a data warehouse platform to support business reporting and analysis
  • Write and perform unit testing of software components and integration programs, including the design, implementation, evaluation, and execution of unit tests
  • Perform data profiling of source data to identify data quality issues •
  • Ensure data processes are performing efficiently and are using best practices, standards, and guidelines
  • Troubleshoot ETL processes and provide optimal solutions
  • Create configuration files to deploy the SSIS packages across all environments.

Required Education, Experience & Competencies

  • 5+ years of ETL development experience
  • Bachelor’s Degree or Diploma in Computer Science, Electrical Engineering or related discipline
  • Strong SQL skills
  • Experience in analyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products, SQL Server Analysis Services, and SQL Server Integration Services
  • Experience working with the full software development lifecycle
  • Proficient in data warehouse concepts and terminology
  • Strong written and verbal communication skills in English
  • Experience working with Power BI is an asset

BGC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees


If you are qualified and interested in a career with BGC, please send your resume and a cover letter in confidence to: careers@bgcengineering.ca


If you need assistance or an accommodation due to a disability, you may contact us at careers@bgcengineering.ca, or call the HR Team at 604-684-5900.

Vancouver  |  Kamloops  |  Calgary  |  Edmonton  |  Toronto  |  Halifax  |  Fredericton  |  Saint John  |  Denver  |  Santiago

Copyright © 2019  BGC Engineering Inc. All rights reserved.
Privacy Policy