Job Title

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. 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, youll 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, youll 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 BGCs 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 BGCs analytics ecosystem. Required Education, Experience & Competencies Bachelors 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 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. Company Benefits 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. 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. #J-18808-Ljbffr