CareerPlan

Business Intelligence Assistant

Ottawa, OntarioRemoteFull-time2026-11-04 → 2026-11-16
Hybrid

Core

Sourcing, tracking, benchmarking, and presenting statistical data to support business operations and organizational goals for Ottawa Tourism.

Role type

Business Intelligence Assistant

Builds

Power BI dashboards, reports, data models, and semantic models for decision-making

Domain

Tourism / Data Analytics

Deliverable

dashboards & analysis

Required skills

Data cleaning and transformation, Data validation, Data analysis, Data visualization, SQL, DAX, Data modeling, Power Query, Microsoft Fabric

Preferred skills

Python, Survey analysis, Statistical analysis, API integration, CRM data handling, AI/LLM tools

Technologies

Power BI, Excel, Power Query, Microsoft Fabric, SQL

Responsibilities

Develop, test, and maintain Power BI dashboards and data models; Prepare, clean, and integrate data from various sources; Support data quality and validation activities; Conduct research and analysis of market, consumer, and tourism data; Create clear data visualizations for non-technical audiences; Collaborate with staff to translate business requirements into data solutions.

Seniority

Junior, hands-on IC