Senior Analytics Developer

About Us

BGC Engineering Inc. (BGC) is an international applied earth sciences professional services firm. We are proud of our talented team of over 800 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 offices located across Canada, the United States, Chile, the Dominican Republic, and 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

BGC is seeking a Senior Analytics Developer to join our Business Operations team. In this role, you'll develop core datasets in our SQL Data Warehouse and build Power BI models and reports that drive decision-making across the organization. As a bridge between SQL developers, and BI developers and business analysts, you'll design scalable, reusable data models and curated datasets that empower analytics at every level.

This position can be located at one of the following offices: Vancouver, Kamloops, or Calgary. 

Responsibilities

• Translate business requirements into technical requirements for scalable data models that support self-service analytics. 
• Design, develop, and maintain robust, scalable semantic data models to support enterprise-wide reporting and analytics (e.g., finance, operations, HR, project delivery). 
• Lead the development of curated datasets and transformation pipelines using tools such as SQL, DAX, and python. 
• Build and enhance BI dashboards, reports, and visualizations using Power BI. 
• Establish and enforce best practices for data modeling and performance monitoring to ensure scalable and efficient analytics solutions. 
• Support the evolution of BGC's data platform by recommending improvements in architecture, tooling, and workflows. 
• Develop and manage documentation and governance standards to promote data quality, consistency, and transparency. 
• Partner with data analysts to optimize data accessibility and performance in tools like Power BI and PowerApps. 
• Mentor junior team members and contribute to the development of internal data capabilities. 
• Evaluate and recommend modern data tools and platforms to enhance BGC's analytics ecosystem. 

Required Education, Experience & Competencies

• Bachelor's Degree in Computer Science, Information Systems, Software Engineering, or a related discipline. 
• 7-12 years of experience in data modeling, analytics, or BI development. 
• Demonstrated ability to lead cross-functional data initiatives and communicate effectively with both technical and non-technical stakeholders. 
• Strong understanding of dimensional modeling, data warehousing principles, data governance frameworks, and best practices for semantic layer design. 
• Proven expertise designing and implementing semantic models using Power BI datasets. 
• Advanced SQL skills and experience with modern data platforms (e.g., Azure Synapse, Snowflake, SQL Server). 
• Experience with version control (e.g., Git), CI/CD pipelines, and agile delivery methodologies. 
• Fluent in scripting languages (Python, VBA, or C#) for data transformation and automation. 
• Strong analytical thinking, attention to detail, and a collaborative mindset. 
• Previous experience working with human resources, accounting, project management, or operational data in a professional services environment is an asset. 

Position Requirements

Travel and Vaccination 

BGC is committed to maintaining a safe work environment to ensure the health and safety of employees while on business travel and during field assignments. To meet travel and client requirements, employees may be required to receive vaccinations such as yellow fever, COVID-19, malaria, etc. If you require an accommodation or wish to discuss your situation, please contact Human Resources. BGC requires that you have a current passport for this position. 

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
• Parental 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 $95,000-$120,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.

Equity, Diversity and Inclusion 

BGC strives to create a workplace where equity, diversity and inclusion are embedded throughout our workplace culture and practices. Join us in our commitment to honour individuality, ensure fairness, and create a welcoming environment for everyone. As an equal opportunity employer, we encourage applications from all candidates, including those experiencing inequity such as racialized individuals, Indigenous People, women, people of diverse sexual orientations, identities and expressions, veterans, individuals with disabilities, people of all faiths, nationalities, marital status, ages, and family status. For assistance or accommodation with your application, please contact us at 

#LI-HYBRID