Snapshot · September 22, 2026

What Vancouver business analytics teams are hiring for

A 29-role snapshot centered on business intelligence, reporting, insights, and data analysis—the roles a fourth-year business student could pursue now or work toward.

LinkedIn Jobs
25

three same-day collection passes, read in full

Indeed.ca
3

retained analytics-first roles from the earlier sample

Workopolis
1

retained data business analyst role

The business analytics stack

Counts use only the 29 named core BI and analytics postings. One role can contribute to several categories; nice-to-have tools are retained where the posting named them.

Technical tools

mentions · N=29

    Power BI and SQL are tied as the clearest cross-role foundation. Advanced Excel and Power Query sit alongside them—not beneath them—as practical business-analysis tools.

    Analytical methods

    mentions · N=29

      The profile is descriptive and decision-oriented: reporting, KPI design, trend analysis, data quality, segmentation, forecasting, and business interpretation dominate.

      Core sample profile

      roles · N=29

        Role families are mutually exclusive: 14 data/business-data analyst roles, nine BI/reporting/platform roles, and six insights, marketing, pricing, or decision-support roles.

        Pillar one

        Power BI

        Named in 23 roles, usually for dashboards, semantic models, KPI reporting, or self-service analytics. DAX appears in five.

        Pillar two

        SQL

        Named in 23 roles—from intermediate querying and validation through complex relational work, warehousing, and semantic layers.

        Pillar three

        Excel + Power Query

        Named in 13 roles. Pivots, formulas, modelling, scenario work, and Power Query remain central in finance, pricing, operations, and reporting.

        The hiring profile

        This is a work-into market, not an entry-level-only market. The strongest course design prepares students for a first analytics-adjacent role while giving them the stack to reach the broader 2–5+ year segment.

        Junior / work-into signal

        6

        postings offer the clearest early-career on-ramps: no stated minimum, 1–3 years, 2–3 years, or an explicit intermediate track.

        Most roles still ask for experience

        Seventeen postings explicitly ask for at least three years. Across the sample, 2–5+ years is the typical band; senior BI leads and reporting specialists extend higher.

        Typical requirements

        6 roles

        Visible on-ramps

        Canadian Cancer Society (no minimum), Gescan (1–3 yrs), QuadReal (2–3), UBC (2+), Specsavers (2+), and Best Buy’s intermediate track (2+).

        Bachelor’s

        The standard signal

        A business, commerce, analytics, information-systems, finance, economics, engineering, or other quantitative degree is the common baseline.

        3 roles

        Certifications are rare

        MSP requires two Microsoft Fabric credentials; Colliers lists certifications as desired; CC&L mentions a designation in progress. Most ads do not name one.

        2–5+ yrs

        The dominant experience band

        Projects, co-op, internships, and analytics-heavy first roles matter because most postings are attainable after an initial step—not directly from the classroom.

        Start here

        Build proof, not just tool familiarity

        A portfolio should show a clean model, SQL logic, Power Query steps, DAX measures, a decision-ready dashboard, and a short executive explanation.

        Immediate targetsPricing analyst, data analyst, reporting analyst, marketing analyst, portfolio reporting analyst, and analyst—insights roles.
        First-step rolesFinance, operations, CRM, marketing operations, or sales-operations work with heavy reporting can become the bridge into BI.
        What moves a résuméEvidence of stakeholder communication, data quality checks, clear KPI definitions, and business-domain judgment—not only a list of software.

        Twenty-nine named core BI and analytics roles

        The sample concentrates on roles that a business graduate could target, or realistically grow into, across marketing, finance, operations, healthcare, professional services, real estate, retail, education, and public service.

        23/29

        showed salary

        Six did not state pay: Ziff Davis, Cascade Aerospace, Autodesk, Gescan, Vancouver Coastal Health, and Robert Half.

        Data / business-data analyst14 roles across digital, operations, finance, health, retail, portfolio reporting, and higher education.
        BI / reporting / platformNine roles centered on Power BI, reporting, data models, semantic layers, governance, and decision infrastructure.
        Insights / marketing / pricingSix roles turned customer, campaign, commercial, or pricing data into recommendations.
        View all 29 named core postings
        Fresh BI / business-analytics pass · 14 roles
        Norton Rose Fulbright · Senior Client Insights Analyst$79,600–$98,300Excel, SAP/Business Objects, Tableau, Power BI; client and revenue insights
        Ziff Davis · Senior BI Analyst, Commercial StrategySalary not statedAdvanced Excel, SQL, Looker, Tableau, Power BI; commercial storytelling
        Capgemini · Senior Business Data Analyst$90,400–$125,090 basePower BI, Azure data services, Microsoft Fabric, governance, requirements
        FortisBC · Operations Reporting Analyst$3,478 bi-weeklyAbout $90,428 annualized · SAP, SAP BW, statistical and cost-benefit analysis
        Cascade Aerospace · Financial Data AnalystSalary not statedAdvanced Excel, Power Query, Power BI, SQL, ERP and warehousing concepts
        BCAA · Marketing Data Analyst$91,185.84–$113,982.36SQL, Power BI/Tableau, CRM and web analytics, segmentation, testing
        Canadian Cancer Society · Analyst, Insights & Pipeline Management$52,000–$59,000Salesforce reporting, visualization, data integrity · no minimum experience stated
        PHSA · Business Analyst, Data & Analytics$76,111–$109,409Program evaluation metrics, dashboards and reporting · temporary to Sept. 2027
        Export Development Canada · Sr Reporting Analyst$96,557–$128,743Microsoft Fabric, Power BI, SQL, Cognos migration, semantic models
        Autodesk · Marketing Insights SpecialistSalary not statedPower BI, DAX, Tableau, SQL, advanced Excel and web analytics
        QuadReal · Data Analyst, Portfolio Reporting$74,000–$84,000 baseSQL, Power Query, Excel, Power BI; forecasting · 2–3 years
        MSP Corp · Data Analytics Consultant$125,000–$135,000Microsoft Fabric, Power BI, SQL, DAX, Power Query; two certifications required
        Gescan · Pricing AnalystSalary not statedExcel, SQL/VBA, Python, Power BI, Cognos · associate level, 1–3 years
        CC&L · Analyst, Analytics Platform & Methodology$85,000–$120,000 baseInvestment analytics, pipelines, dashboards, semantic layer, communication
        Carried LinkedIn BI / analytics roles · 11 roles
        Vancouver Coastal Health · Business Advisor, Data & AnalyticsSalary not statedSQL, Python, R, Tableau, Power BI, statistics and predictive modelling
        Colliers · Portfolio Intelligence Analyst$95,887–$110,000Power BI, SQL, Python, Excel, dashboards, KPIs and anomaly detection
        PHSA · BI Performance Measurement Specialist$76,111–$109,409T-SQL, MDX, relational/OLAP databases and performance reporting
        Robert Half · Business Intelligence SpecialistSalary not statedPower BI, Excel, Power Apps, Crystal Reports and NetSuite
        ITC Infotech · Power BI Lead$120,000–$130,000Power BI, DAX, SQL, Power Query, star schemas and semantic models
        EA · Senior Analyst, The Sims$92,900–$129,200SQL, Python/R, Looker, Power BI, experimentation and product analytics
        Kardium · Senior Operations Data Analyst$90,000–$125,000 total cashPower BI, SQL, advanced Excel, operational KPIs and data quality
        Legal Aid BC · Data Analyst$81,542–$93,249Power BI, SSRS, Crystal Reports, Excel and warehousing/ETL
        Specsavers · Data Analyst$80,000–$95,000 baseSQL, DAX and Power Query · early-career on-ramp
        CC&L · Data Analyst$110,000–$130,000SQL, relational modelling, Power BI, Python and validation
        UBC Sauder / Creative Destruction Lab · Data Analyst$6,143.67–$8,830.25/monthCRM data, scripting, visualization and descriptive statistics · 2+ years
        Carried Indeed / Workopolis analytics roles · 4 roles
        Klohn Crippen Berger · Senior Data Analyst$95,000–$120,000SQL, Python/R, Power BI, statistics and predictive modelling
        Best Buy · Intermediate / Senior Data Analyst$80,000–$85,000 / $95,000–$105,000SQL, Python, Power BI, statistics and experimentation
        Specsavers · Data Business Analyst$95,000–$115,000 baseSQL, Power BI, cloud platforms, data governance and stakeholder work
        Aritzia · Senior Data Analyst, Digital$100,000–$150,000SQL, Python/R, Tableau, Looker, Power BI and A/B testing

        All 29 named rows are in the downloadable CSV. The 25 LinkedIn roles were collected in three passes on September 22, 2026; four earlier analytics-first postings were retained from Indeed and Workopolis. Exact public URLs are shown only where they were retained—none are reconstructed.

        Salary inside the core market

        Twenty-three of 29 roles disclose employer-provided pay. The broad span reflects junior-to-lead seniority, different employment structures, and domain differences—not a single market rate.

        Employer-stated coverage 23/29

        No third-party estimates were added. FortisBC and UBC are shown as posted, with transparent annualized approximations.

        4 of 6Insights, marketing, pricing, and decision-support roles; stated ranges begin at $52k and reach $129.2k.
        19 of 23Data analyst, BI, reporting, and platform roles; many experienced postings cluster around $80k–$135k.
        View salary examples and bands
        Early-career and work-into examples
        Canadian Cancer Society · Insights Analyst$52,000–$59,000No minimum experience stated
        QuadReal · Portfolio Reporting Analyst$74,000–$84,000Two to three years
        Specsavers · Data Analyst$80,000–$95,000 baseQuarterly bonus and profit sharing also stated
        UBC · Data Analyst$6,143.67–$8,830.25/monthApproximately $73.7k–$106k annualized
        Experienced analyst and specialist examples
        BCAA · Marketing Data Analyst$91,185.84–$113,982.36Marketing and CRM analytics
        EDC · Sr Reporting Analyst$96,557–$128,74315-month contract
        MSP Corp · Data Analytics Consultant$125,000–$135,000Microsoft Fabric credentials required
        Aritzia · Senior Data Analyst, Digital$100,000–$150,000Highest stated upper end in the core sample

        All values are CAD and preserve employer qualifiers. FortisBC’s $3,478 bi-weekly is about $90,428 over 26 pay periods. UBC’s annualized figure is an arithmetic conversion of the posted monthly range. The two Specsavers postings are distinct.

        Curriculum priorities

        Six practical emphases for fourth-year business students preparing for business analytics and business intelligence work.

        Build the three pillars together

        Power BI, SQL, and advanced Excel/Power Query are the strongest shared foundation. Teach them as one workflow: source, clean, model, calculate, visualize, and explain.

        Go beyond drag-and-drop BI

        DAX, semantic models, star schemas, row-level security, and data quality separate dashboard users from analysts who can build trusted decision systems.

        Teach descriptive analytics deeply

        Trend analysis, segmentation, KPI definition, benchmarking, variance analysis, and scenario work recur more often than advanced modelling in the core sample.

        Rotate through business domains

        Use marketing, finance, operations, pricing, healthcare, real estate, and customer-insights cases so students learn to translate tools into domain judgment.

        Make communication assessable

        Require a short executive readout with every dashboard: what changed, why it matters, what action follows, and what uncertainty remains.

        Keep Tableau and Python as useful breadth

        Tableau is a meaningful secondary visualization tool; Python/R appears in 14 roles, often as a complement. Neither should displace the Power BI–SQL–Excel core.

        Stretch: where the field goes

        These 13 roles sit beyond the 29-role named core. They are useful as a technical-track horizon—often calling for graduate study, deep modelling, engineering, or extensive experience—not as immediate business-undergraduate targets.

        View 13 graduate-school / technical-track roles
        Prenuvo · Senior AI Applied Scientist II$150,000–$177,000Medical imaging, deep learning, multimodal and generative AI
        Amazon · Applied Scientist, Alexa Connections$149,300–$249,300PhD or master’s-plus-experience; RAG, embeddings, LLMs
        CC&L · Quantitative Equity Portfolio Research$125,000–$200,000 base + bonusOptimization, factor investing and financial econometrics
        Workday · Machine Learning Engineer, Financials$128,000–$192,000ML systems, experimentation and financial data models
        lululemon · Principal AI/ML Engineer$208,580–$273,770 + bonus/equityEnterprise ML platforms, MLOps and 11–15+ years
        Powerex · Quantitative Analyst$109,680–$148,400Operations research, optimization, forecasting and trading risk
        Sixone Labs · Data Scientist$90,000–$125,000 baseComputer vision, sensor data and edge-model deployment
        Remarcable · Data Scientist$150,000–$180,000Model building, validation, deployment and AWS data stack
        RBC · Data Scientist, AI Model RiskSalary not statedGraduate study, AI/ML model-risk evaluation and benchmarking
        Mastercard · Data Scientist II$91,000–$140,000Statistical modelling, feature engineering, Spark and Databricks
        ICBC · Data Scientist II$118,626–$168,300Master’s/PhD, pricing and actuarial-adjacent risk modelling
        Teck · Data Scientist III$107,000–$132,000Graduate study, production ML, Azure and Databricks
        Reddit · Staff Data Scientist, AdsSalary not statedAdvanced degree, causal inference, experimentation and attribution

        Stretch roles are context only. None contributes to the skills, methods, education, experience, salary, or role-family tallies above, and none appears in the downloadable core CSV.

        Method, scope, and caveats

        The supplied roster names 29 distinct core postings: 25 from LinkedIn, three retained Indeed analytics roles, and one Workopolis data-business-analyst role. Although the brief labels this a 30-role sample, no unlisted 30th posting is added or inferred.

        • This is a LinkedIn-dominated, one-day directional snapshot—not a labour-market census.
        • Geography covers Vancouver and Metro Vancouver, including Burnaby, Surrey, Coquitlam, and Abbotsford.
        • Hard-core data science, applied science, machine-learning engineering, and quantitative-research roles are excluded from all core tallies.
        • Counts use explicit posting language. One role may contribute to several skills or methods, and nice-to-have mentions remain included.
        • Traditional systems-delivery BA roles without a meaningful analytics or BI centre of gravity remain out of scope.
        • Salary figures are employer-provided CAD values and are not normalized for contract type, bonus, equity, or seniority.
        • Certifications are uncommon: only MSP requires named credentials; two other roles mention desired or in-progress designations.

        Source reference

        Fourteen fresh LinkedIn BI/business-analytics postings were read in full on September 22, 2026; exact public URLs were not retained and are not reconstructed. EA — Senior Analyst, The Sims Kardium — Senior Operations Data Analyst Legal Aid BC — Data Analyst Specsavers — Data Analyst CC&L — Data Analyst UBC — Data Analyst Indeed — Klohn Crippen Berger Senior Data Analyst Indeed — Best Buy Data Analyst Indeed — Aritzia Senior Data Analyst, Digital Workopolis — Specsavers Data Business Analyst search panel

        Download the 29-row named core dataset, including salary, source, role family, and coded skill signals.