Sql analyst Jobs in New Westminster, BC

Business Analyst

Surrey, BC Full-time $60000.00/year

Who We Are

Emterra Group is a dynamic, growth-oriented, and safety-focused group of companies. Our organization have been deemed to be an “essential service” by providing collection and processing for recycling, organics, and waste that keep our communities clean and safe. With customer service and safety as our focus, we are looking for an energetic and driven employee to support our growing company and play a crucial role in waste diversion and the circular economy. Emterra is proud to be recognized as one of Canada’s Greenest Employers, a certified diverse supplier of the Canadian Aboriginal and Minority Supplier Council (CAMSC) and the Canadian Women Business Enterprise National Council (WBE).

Job Summary

We’re seeking an innovative Business Analyst with experience in AI solutions and advanced reporting to help transform our waste management operations. In this role, you’ll lead initiatives to deliver actionable insights through Power BI dashboards, develop and optimize AI chatbot solutions for internal and customer interactions, and identify broader AI automation opportunities across our services. Your work will be central to building a smarter, more efficient, and sustainable waste management system through data-driven decision-making and intelligent automation.

Position Description

·Design, develop, and maintain interactive Power BI dashboards that deliver clear operational, sustainability, and business performance insights

·Gather business requirements and translate them into effective data models, DAX calculations, and visual reports

·Analyze collection, routing, recycling, and disposal data to identify inefficiencies and recommend improvements

·Lead the development and implementation of AI-powered chatbots to improve customer service, reduce call volumes, and streamline internal workflows

·Collaborate with operations, engineering, and IT teams to scope AI and automation use cases (e.g., smart routing optimization, load forecasting, customer self-service)

·Support the evaluation and integration of AI/ML models for predictive analytics, including reducing equipment downtime and improving sustainability KPIs

·Communicate complex technical findings in clear, business-friendly language to executives and cross-functional teams

·Stay current on emerging AI, chatbot, and data visualization technologies to inform our digital strategy

·We ask that all applicants use the link below to complete an assessment to advance to the next steps of the interview process: https://emterra.quickbase.com/db/bsp27zsfw

Skills & Qualifications

·Bachelor’s degree in business, Data Science, Information Systems, Environmental Science, or a related field

·Minimum 1 year of experience as a Business Analyst, with significant exposure to data visualization and AI projects

·Familiarity with chatbot development platforms (e.g., Microsoft Power Automate, Dialog flow, Azure Bot Service) and basic prompt engineering

·Proficiency in SQL for data extraction and manipulation

·Proficiency in Python for data analysis, automation scripting, or AI/ML model integration

·Strong communication skills with a demonstrated ability to align technical solutions with business needs

·Act as a liaison between the Western Operations teams and the National IT Team to facilitate communication and project coordination.

·Communicate and disseminate relevant information, updates, and project developments to internal teams.

·Support stakeholder engagement activities, including information gathering, requirements collection, and business needs analysis.

Nice to Have:

·Experience in logistics, supply chain, or environmental services

·Knowledge of sustainability metrics and ESG reporting frameworks

·Experience with QuickBase for workflow automation or custom applications

·Exposure to geospatial data analysis or IoT-enabled waste management systems

·Understanding of responsible AI practices, including bias mitigation and ethical chatbot design

·Proven experience creating advanced Power BI dashboards, including data modeling, DAX, and UX best practices (nice to have)

·

Reasons to Apply, Stay and Grow with Emterra Group

·Opportunity to be part of one of Canada’s Greenest Employers!

·Competitive wages!

·Comprehensive health benefits (health, dental, and more depending on what you choose)!

·Employee Assistance Program, paid for by the company!

·Tuition reimbursement program and professional development support!

·Be part of an entrepreneurial organization that wants to continue to learn and grow!

·Ability to have an impact and make change!

P Please complete the assessment using the link below and submit it with your application.

https://emterra.quickbase.com/nav/app/bsp27zsfw/table/bsp273a4t/action/nwr?originalQid=5

Are you ready to jumpstart your career by joining one of Canada’s Greenest Employers and become part of the environmental solution? If so, apply now! We appreciate all applicants who apply however only those who are qualified, will be contacted.

Emterra Group is committed to maintaining an equitable, fair, and diverse environment. Any applicants who have a disability or require reasonable accommodation may speak directly with our Human Resources Department. Reasonable accommodations will be assessed on a case-by-case basis. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, age, national origin, disability, or veteran status.

Please visit our careers page to see more job opportunities.