Business Intelligence Assistant
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