Senior Analytics Developer

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 RoleBGC 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.ResponsibilitiesTranslate 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 & CompetenciesBachelor’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 RequirementsBGC 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 BenefitsOur ‘One Team’ culture supporting health, wellness, safety and diversityComprehensive benefits packageHealth, Dental and Vision coverageLTD, Life, AD&D and Business Travel InsuranceEmployee Assistance ProgramParental leave top upsProfessional development and mentoring opportunitiesFlat management structureFlexible workplace with office and home arrangementsSocial and wellness activitiesCasual and professional work environmentThe 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 InclusionBGC 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