Overview

Ottawa Tourism’s vision is to be one of Canada’s most visited, sustainable, vibrant, and valuedurban destinations and the tourism authority for key economic development and city-building decisions in Ottawa. Ottawa Tourism's mission is to market and sell Ottawa as a compelling leisure and business destination and lead or participate in initiatives that improve Ottawa’s visitor experience. We contribute to the broader economic development objectives of the city and the success of our stakeholders and, by doing so, enrich the quality of life for all Ottawa residents.

Reporting to the Senior Manager, Business Intelligence, the successful candidate will be responsible for sourcing, tracking, and benchmarking all statistical data related to our business operations and organizational goals, and for presenting this information in a timely and effective manner both internally and to our external stakeholders. As an analytical problem-solver and capable project manager, the Business Intelligence Assistant is expected to think and act independently when required, while also serving as an effective team member and collaborator.

This position is based out of the Ottawa Tourism offices in beautiful downtown Ottawa. Ottawa Tourism employs a hybrid work model, with the ability for all employees to work remotely. In some cases, certain positions will have an ongoing requirement to maintain a physical presence in the office. Such details will be discussed during the application process.

Key Competencies

- Demonstrated ability to clean, transform, validate and analyze data,



with strong attention to data accuracy and quality along with demonstrated ability to test and validate analytical results before presenting or reporting them.
- The ability to effectively communicate with colleagues, and external stakeholders both verbally and in writing is essential. Strong organizational skills and detail-oriented ensuring accuracy, consistency, and quality across all tasks and deliverables.
- The ability to manage time and prioritize tasks is essential in a fast-paced environment.
- Works well as part of a team, takes initiative, asks questions when needed, and is eager to learn and improve processes.

- Proven abilities in building partnerships and team-oriented working relationships
- Enjoys working as part of a team and understands how to harness team dynamics in order to attain complex project goals
- Strong analytical and problem-solving skills, including the ability to investigate discrepancies, identify patterns and translate data into meaningful insights.
- Comfortable acting as a key contributor in a fast-paced organization

Primary Areas of Responsibility

- Assist with the development, testing and maintenance of Power BI dashboards, reports and data models that support decision-making across Ottawa Tourism.
- Prepare, clean, transform and integrate data from a variety of sources using tools such as Excel, Power Query, Power BI and Microsoft Fabric.




- Support data quality and validation activities, including identifying missing, duplicate or inconsistent data, reconciling reported results to source data, and documenting data-quality issues.
- Assist with the development and maintenance of semantic models, data flows and other reusable BI data assets that improve access to consistent, reliable organizational data.
- Support the evaluation and integration of new data sources, including tourism, visitor, hotel, event, CRM, market and other business data.
- Conduct research and analysis of market, consumer and tourism data, including survey analysis, benchmarking, trend analysis and economic-impact research, and help translate findings into useful insights.
- Assist with the testing and quality assurance of BI, CRM and emerging AI-enabled analytics solutions, including developing and executing test cases, validating outputs against source data, identifying issues and documenting results.
- Create clear and engaging data visualizations, dashboards, summaries and analytical products that make complex information easier for non-technical audiences to understand.
- Develop and maintain BI documentation, including data dictionaries, source documentation, report definitions, testing records and user guidance.
- Collaborate with Ottawa Tourism staff to understand business and reporting requirements and help translate those requirements into practical data, reporting and analytical solutions.
- Undertake other BI and research projects that support Ottawa Tourism's strategic priorities and evidence-based decision-making.

Desired Qualifications

- Post-Secondary education in a r

📌 Business Intelligence Assistant (Canada)
🏢 Ottawa Tourism
📍 Canada