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 worlds most critical applied earth science challenges. BGC hasoffices 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 AnalyticsDeveloper to join our Business Operations 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

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 contactHuman Resources. BGC requiresthat you have a current passport for this position.

Company Benefits

BGC offersour 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 $95000-$120000 CAD per annum however base pay will be commensurate with job-related knowledge skills and experience. BGCs 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.

Disclosures

(1) At BGC we use Artificial Intelligence to streamline parts of the recruitment process however all decisions about candidate selection and advancement continue to be made by our hiring team.

(2) This is a newly created position reflecting our continued growth and investment in expanding our capabilities.

(3) This posting will remain open until the position has been filled.

(4) Privacy Notice: By submitting an application you are consenting to BGC Engineering Inc. using and storing provided information about you for monitoring purposes relating to your application or future employment.

#LI-HYBRID

Required Experience:

Senior IC