Junior Data Analyst (Vancouver)


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, work with fantastic teams and enjoy perks such as lunch time yoga, companywide clubs and mentoring opportunities.

The Role

BGC is looking for a Junior Data Analyst to work in our Vancouver, BC or Golden, Colorado office. In this role you will be working with the Business Operations team to provide dynamic data analysis and reporting solutions. The successful candidate will help enable the organization to adapt to rapid changes to support and use future technology.


  • Design and implement queries and data extractions to support custom reporting of accounting, project management, operations, and human resources – data reconciliation
  • Develop work flows and custom applications that integrate with current software
  • Add content and extract data from software and/or data warehouses
  • Maintain, support, distribute, and improve existing reporting/analytics solution
  • Collaborate with internal stakeholders to determine best approaches to improve the overall operational performance


  • Bachelor’s Degree in Computer Science, Management Information Systems, Engineering or related technical discipline, or equivalent professional experience
  • Advanced experience working in Excel with data tables, functions, macros, etc.
  • Experience developing data analysis, BI, tabular models, DAX
  • Experience with SQL-based databases
  • Exceptional communications skills in English, both written and oral, and the ability to communicate effectively with both technical and non-technical stakeholders
  • Exceptional analytical, critical thinking, and problem-solving skills to troubleshoot, resolve complex issues, and recommend innovative solutions
  • Experience with scripting languages (VBA, C#, Python) and web programming (ASP.net, jquery) is an asset
  • Report development experience (SSRS) is an asset
  • Experience working with accounting and financial data is an asset

BGC pays competitive salaries, provides a comprehensive benefits package, and maintains a casual but professional work environment. 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


We are an equal opportunity employer and are committed to diversity & inclusion. We encourage all qualified candidates to apply.

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

Copyright © 2017  BGC Engineering Inc. All rights reserved.