Business Intelligence Assistant

Overview

Ottawa Tourism’s vision is to be one of Canada’s most visited, sustainable, vibrant, and valued urban 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 collaborative 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 relevant quantitative or technical discipline (Business Analysis, Data Science, Statistics, etc.)

Experience using Microsoft Power BI, Microsoft Excel including working with and analyzing large or complex datasets, creating reports and visualizations and working with data in Power Query. Experience with DAX and data modelling is considered an asset.

Experience with or knowledge of SQL, relational databases and data modelling concepts is considered an asset.

Familiarity with Microsoft Fabric, cloud-based analytics platforms or data pipelines is considered a strong asset.

Experience with data visualization and dashboard development, with an understanding of how to communicate information clearly to non-technical audiences.

Strong written and verbal communication skills and the ability to document analytical methods, assumptions and findings clearly.

Demonstrated curiosity and willingness to learn new data technologies, AI-enabled analytical tools and business systems.

Experience with Python, survey analysis, statistical analysis, APIs, CRM data or AI/LLM tools is considered an asset.

Assets

Fully bilingual in both of Canada’s official languages, both written and verbal.

Previous experience working in tourism, hospitality, or destination management/marketing.

The Hiring Process

Initial Phone Screen

In-Depth Interview

Reference checks

Offer

How we Hire

The decisions throughout the hiring process are made by Ottawa Tourism’s hiring team; Ottawa Tourism does not include any use of AI through the hiring process. This process complies with privacy and employment laws across Canada.

Vacancy Reasoning

This role is a newly created role.

Compensation Range

The expected salary for this position is $22 per hour.

Land Acknowledgement

Ottawa Tourism is located and operates on the traditional and unceded territory of the Anishinaabe Algonquin people, who have travelled and inhabited these lands for millennia.

Diversity, Equity & Inclusion Statement

We place great value on the importance of diversity in our workforce, and we value inclusivity, trust, innovation and encourage applications from individuals who are members of under-represented or marginalized communities. We foster a diverse, equitable and inclusive organization. We connect with Indigenous communities; we care about the planet our people and our industry, and we want our city to be accessible to all. To that end, we are committed to an objective hiring process which is free from discrimination based on any of the protected grounds as stated in Ontario's Human Rights Code. In an effort to ensure that the selection process is as objective as possible, applicants are invited to consider removing any indications on their application that might suggest age, place of origin, ethnic origin, disability, race, or any other protected ground. For example, applicants might choose to include the names and classification of degrees granted (i.e. Diploma in Project Management, with Honors), while excluding the name or location of the school.

Accessibility Statement

All applications will be considered as long as the applicant can demonstrate that they meet the essential qualifications as described in the job posting. Further to this, if you would like to request any additional accommodations b