About Us 

BGC Engineering Inc. (BGC) is an international applied earth sciences professional services firm. We are proud of our talented team of over 700 employees, spanning the fields of Engineering, Geoscience, Software, Geomatics, Data Science, Accounting, Administration, Health & Safety and Human Resources. Alongside our clients and industry partners, BGC works collaboratively as ‘One Team’, dedicated to solving the world’s most critical applied earth science challenges. BGC has Canadian offices located in Vancouver, Victoria, Kamloops, Kelowna, Calgary, Edmonton, Toronto, Ottawa, Fredericton, Halifax, and offices in Golden (Colorado), Nashville (Tennessee), Santiago (Chile), Santo Domingo (Dominican Republic), and Brisbane (Australia).

Our flat management structure creates a culture of innovation, excellence and transparency and a casual, dynamic and inclusive work environment. BGC prides itself on offering training and mentoring opportunities to further our employees’ professional growth as well as social and wellness activities that contribute to the connection and wellbeing of our team.

We believe in One Team, Excellence, Curiosity, Common Sense and Clarity. 

The Role

Working as part of the Business Operations team, BGC is seeking an Intermediate MS BI Full Stack Developer to conceptualize, design, and develop solutions that synthesize data into clear communications for BGC’s stakeholders. This position can be located at one of the following offices: Vancouver, Kamloops, or Calgary.

Responsibilities

• Design and implement models and data extractions to support custom reporting of accounting, project management, operations, and human resources data
• Develop internal customer relationships to gather requirements towards their reporting objectives and collaborate on best approaches to improve data useability
• Convert business requirements into technical specifications with defined timelines
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights

• Extract data structures, run queries and perform analysis within a data warehouse environment
• Maintain, support, distribute, and improve existing reporting/analytics solutions
• Assist in developing best practices for data presentation and sharing across the organization
• Provide exceptional analytical, critical thinking, and problem-solving skills to troubleshoot, resolve complex issues, and recommend innovative solutions

Required Education, Experience & Competencies

• Bachelor’s Degree in Computer Science or related discipline
• 5 years of relevant work experience
• Advanced experience working in Excel with data tables, functions, macros, etc.
• Familiarity with database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Knowledge of SQL Server Competencies, BI Modeling, Azure Synapse
• Working experience with data analysis, Power BI, tabular models, DAX
• Ability to design and create data visualizations that are intuitive, informative and deliver insight to the business
• Analytical, detail-oriented, and problem-solving aptitude
• Clear and effective communication and writing skills with the ability to communicate with both technical and non-technical stakeholders
• Strong work ethic, a sense of urgency, self-motivated and a desire to contribute to a small dynamic team

Preferred Education, Experience & Competencies

• Experience with scripting languages (VBA, C#, Python)
• Tabular model development experience (SSAS, SSDT, Power BI, Tableau, Azure Synapse)
• Experience working with accounting and financial data

Company Benefits

BGC offers our employees the following:   

• Our ‘One Team’ culture supporting health, wellness, safety and diversity
• Comprehensive benefits package

• Health, Dental and Vision coverage
• LTD, Life, AD&D and Business Travel Insurance
• Employee Assistance Program

• Maternity/Paternity leave top ups
• Professional development and mentoring opportunities

• Flat management structure
• Flexible workplace with office and home arrangements
• Social and wellness activities
• Casual and professional work environment 

The estimated base salary range for this position is $80,000 - $110,000 CAD per annum, however base pay will be commensurate with job-related knowledge, skills, and experience. BGC's compensation package also includes a training allowance and a comprehensive medical and dental plan.

BGC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. If you need assistance or an accommodation with your application, please contact us.