BI Analyst

22 hours ago

British Columbia, Canada C5i Full time

C5i is a pure-play AI & Analytics provider that combines the power of human perspective with AI technology to deliver trustworthy intelligence. The company drives value through a comprehensive solution set, integrating multifunctional teams that have technical and business domain expertise with a robust suite of products, solutions, and accelerators tailored for various horizontal and industry-specific use cases. C5i has been recognized by leading industry analysts like Gartner and Forrester for its Analytics and AI capabilities and proprietary AI-based platforms.

We are seeking a SQL Analyst with strong hands-on experience in writing, optimizing, and managing SQL queries across large and complex datasets. This role will support our analytics, research, and insights teams by building high-quality data outputs, ensuring data accuracy, and enabling efficient analysis.
Experience in market research or survey programming is a plus but not mandatory - training will be provided for the right candidate.

Develop, optimize, and maintain SQL queries, stored procedures, and views for data extraction, processing, and reporting.
Work closely with internal analytics and research teams to understand data requirements and deliver analysis-ready datasets.
Perform data validation, quality checks, and reconciliation across multiple data sources.
Support automation and standardization of recurring reporting and data workflows.
Document SQL logic, data definitions, and process flows for internal stakeholders.
Collaborate with survey programming and insights teams when needed to support dataset preparation, survey data transformations, and logic checks.
Troubleshoot performance bottlenecks and implement query optimization techniques.

Bachelor’s degree in computer science, Information Systems, Statistics, Engineering, or related field.
~5 years of hands-on experience working extensively with SQL.
~ Strong command of advanced SQL concepts including joins, window functions, CTEs, aggregations, subqueries, and performance tuning.
~ Ability to interpret database schemas, data dictionaries, and business requirements with minimal supervision.
~ Excellent written and verbal communication skills, especially in remote environments.


Experience in market research, survey programming (Decipher) or survey data processing.
Exposure to Python or R for basic data manipulation.
Understanding of ETL concepts and data quality frameworks.

We are committed to equal employment opportunity regardless of race, color, religion, sex, sexual orientation, age, marital status, disability, gender identity, etc. If you have a disability or special need that requires accommodation, please keep us informed about the same at the hiring stages for us to factor necessary accommodations

  • Payroll Analyst

    1 week ago

    British Columbia, Canada Accounting Advantage Full time

    Payroll Analyst Burnaby, BC $28.84–$33.65ph (temporary for 2 months) About the Opportunity A large, multi-location, multi-province organization is seeking a Temp Payroll Analyst to support its payroll team during a short-term leave. Reporting to the Manager of Payroll and supported by two Team Leads, you'll play a key role in processing payroll for a...

  • Business Analyst

    24 hours ago

    British Columbia, Canada Amur Financial Group Full time

    The Business Analyst – Mortgage Origination supports both the wholesale channel (Sequence Capital) and the direct-to-borrower channel (Alpine Credits) across a national mortgage platform. Reporting directly to the Chief Operating Officer (COO), this role also maintains dotted line relationships to the Director of Business Optimization and the Director of...

  • Senior Technical Business Analyst

    2 weeks ago

    British Columbia (BC), Canada Randstad Digital Full time

    Job Title: Technical Business Analyst (Senior or Mid-level)Desired Start Date: AsapContract Length: 6 months to start, long term extension to followPossibility of Extension: LikelyLocation: Hybrid Vancouver (5 days/week)Hours: 40/wkStatus: Inc or T4We are seeking an experienced Business Analyst to join the Retail Engineering team, supporting digital...

  • Engineering Analyst – Supply Chain

    2 days ago

    Langley, British Columbia, Canada Best Buy Canada Full time $70,000 - $73,000 per year

    Process Engineer – Supply ChainYou'll love it here We are hiring immediately for a process engineer, which we call anengineering analyst, supply chainto join our team. In this role you will make a positive impact on our warehouse operations everyday through the continuous improvement projects you work on.In this role, the successful candidate will be...

  • Business Analyst

    2 days ago

    Trail, British Columbia, Canada Teck Resources Limited Full time $77,000 - $147,000 per year

    Location:Trail, BC, CanadaEmployment Type:Regular Full TimeWorkplace Type:On-siteAbout Trail OperationsTeck's Trail Operations, located in the community of Trail in British Columbia, is one of the world's largest fully integrated zinc and lead smelting and refining complexes. Located in the beautiful West Kootenay region of southeastern, British Columbia,...

  • System Analyst

    1 week ago

    British Columbia (BC), Canada Robert Half Full time

    We are looking for a technically strong Systems Analyst to support a suite of municipal applications used across Engineering, Development, Fire Services, and Utilities. This role blends system support, data work, integrations, and reporting. You'll work with platforms such as our advanced metering infrastructure (AMI), scheduling and staffing tools, and...

  • Engineering Analyst

    2 weeks ago

    British Columbia (BC), Canada Best Buy Canada Full time

    Process Engineer - Supply ChainYou'll love it here! We are hiring immediately for a process engineer, which we call an engineering analyst, supply chain to join our team. In this role you will make a positive impact on our warehouse operations everyday through the continuous improvement projects you work on.In this role, the successful candidate will be...

  • Data Analytics Internship

    20 hours ago

    british columbia, Canada Hireshire Full time

    About HireshireHireshire is an innovative talent solutions platform committed to connecting businesses with exceptional candidates. As part of our expansion into Data Analytics, we’re offering a structured internship program for motivated individuals eager to build a career in data-driven decision-making.Internship Summary:Join our analytics team and gain...

  • ERP Business Analyst

    3 weeks ago

    British Columbia (BC), Canada Kalesnikoff Full time

    Our company:At Kalesnikoff, we honor our heritage by investing in our future. As a family-owned, fourth-generation company, we've evolved from our roots in the forests to become a leader in the timber industry, but we're not just resting on tradition. Today, Kalesnikoff is at the forefront of innovation, combining decades of expertise with cutting-edge...

  • Data Analytics Internship

    1 day ago

    British Columbia, Canada Hireshire Full time

    About Hireshire Hireshire is an innovative talent solutions platform committed to connecting businesses with exceptional candidates. As part of our expansion into Data Analytics, we're offering a structured internship program for motivated individuals eager to build a career in data-driven decision-making. Internship Summary: Join our analytics team and gain...