Find work in Canada.

323,070 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 2 mins ago
IT Analyst
iA Financial Group (Industrial Alliance)
Montreal, QC
Full-time
As an IT Analyst, you will play a key role in supporting business partners, analyzing their needs, and delivering and evolving technology solutions for corporate sectors. You will also…
Added 32 mins ago
Financial Analyst
University of British Columbia
Kelowna, BC
$7,158.42 to $10,292.25 CAD / month
Full-time
Utilizes data warehousing, business intelligence tools and software applications to support the Senior Manager, Budget and Financial Planning with analysis, reporting and decision-making.
Added 47 mins ago
Senior Programmer Analyst (24 Month Contract)
Doctors of BC
Vancouver, BC · BC
Full-time
Reporting to the Manager, Business Applications, the Senior Programmer Analyst is responsible for designing, developing, maintaining, and modernizing enterprise business applications,…
Added 47 mins ago
New Analyst Program
Clarity
Vancouver, BC
$65,000 to $85,000 CAD / year
Full-time
We're looking for exceptional new graduates and early career professionals to join Clarity as a New Analyst in June 2027. This is an opportunity to accelerate your career by working…
Added 1 hour ago
Senior Technical Analyst
Government of Manitoba
Winnipeg, MB
Full-time
Reporting to the DTS Service Manager, the Technical Analyst supports the implementation, maintenance, and optimization of infrastructure services, including servers, networks, cloud…
Added 1 hour ago
Intermediate Project Manager/Analyst
Affinity
Vancouver, BC
Contract
Our energy client is seeking a highly organized and delivery-focused Junior to Intermediate Project Manager / Analyst to support a growing portfolio of Infrastructure, Cybersecurity, and…
Added 1 hour ago
Strategic Finance Analyst
Actionstep
Remote, Canada
Full-time · Remote
Partner with the Senior Financial & Systems Analyst on the data and systems behind the company’s business intelligence, recurring reporting, and general analysis efforts.
Added 1 hour ago
Applications Support Senior Analyst - Asst Vice President
Citi
Mississauga, ON
Full-time
As a Senior Application Support Analyst, Assistant Vice President at Citi, you will take ownership of mission-critical production applications, ensuring the stability, performance, and…
Added 2 hours ago
1800 Financial Analyst IV
Amyantek
Toronto, ON · Greater Toronto Area, Canada
Contract
…days in-office each week with flexibility depending on their business, client and team…
Added 2 hours ago
Bilingual Lease Analyst (FR/ENG)
BGIS
Toronto, ON
Full-time
The Lease Analyst, in conjunction with our RealLease technology platform, supports our clients nationwide in effectively and efficiently managing their leased portfolios. From abstracting…
Added 2 hours ago
Senior Accounting Assistant
City of Medicine Hat
Medicine Hat, AB
Full-time
Support the financial analyst during budget season by preparing budget reports and performing administrative tasks.
Added 2 hours ago
Analyst, Pender Ventures (BC or Alberta)
Pender Ventures
Vancouver, BC
$90,000 to $110,000 CAD / year
Temporary
Pender Ventures is seeking a highly capable and detail-oriented Analyst to join our investment team. This role is responsible for using AI tools and research methods to identify and reach…
Added 2 hours ago
Senior Tax Analyst
Acro Service Corp
Grimsby, ON
$50 to $60 CAD / hour
Contract
Participate in project work to support system changes, business needs and process improvements with a focus on automation while providing guidance on the tax impacts of business decisions
Added 2 hours ago
Financial Reporting Analyst
Pollard Banknote Limited
Winnipeg, MB
Full-time
We’re looking for a detail-oriented and analytical Financial Reporting Analyst to join our Finance team within our Winnipeg Office.
Added 2 hours ago
Analyst, Pender Ventures (BC or Alberta)
Penderfund Capital Management
Vancouver, BC
Full-time · Temporary
Pender Ventures is seeking a highly capable and detail-oriented Analyst to join our investment team. This role is responsible for using AI tools and research methods to identify and reach…
Added 2 hours ago
Analyst, Global Investment Banking (Diversified - Consumer & Industrial Products)
RBC
Toronto, ON
Full-time
…investment bank. We have built our successful investment banking business by focusing on our clients and the industry sectors in which they operate. With teams located in North America,…
Added 2 hours ago
Executive Quality
Aptino, Inc.
Toronto, ON
$35 to $40 CAD / hour
Contract
We are looking for a Tosca QE Sr Analyst with strong experience in QA automation, backend testing, and quality engineering.
Added 2 hours ago
AltaGas - Risk Analyst
AltaGas Ltd.
Calgary, AB · AB - Calgary
Full-time
We are growing and seeking an Analyst, Market Risk, to join our Enterprise Risk Management department. The successful candidate will bring analytical aptitude and a learning mindset to…
Added 2 hours ago
Policy Analyst
Manitoba Métis Federation
Dauphin, MB
$57,525 to $70,812 CAD / year
Full-time
The MMF seeks to fill one full-time Policy Analyst position within our Health & Wellness Department located in Dauphin, MB. The Policy Analyst is responsible for researching opportunities…
Added 2 hours ago
Senior Governance & Control Analyst-1
TD
London, ON · Toronto, ON · Markham, ON
Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 2 hours ago
Modelling / Forecasting Senior Analyst (Quants)
TD
Toronto, ON
Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 2 hours ago
Senior Quality Control Analyst (5511)
TD
Toronto, ON · Markham, ON
Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 2 hours ago
Project Analyst II
TD
Toronto, ON
Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 2 hours ago
TDS Operations Analyst III
TD
Toronto, ON
Full-time
Reporting to the Group Manager, Corporate Lending Operations Administration, the Operations Analyst III is a senior individual contributor responsible for executing and overseeing loan…
Added 2 hours ago
Business Systems Analyst III
TD
Toronto, ON
Full-time
The ARCS pod within the Finance and Risk Platform is looking for a Business Systems Analyst. This role has a focus on delivering technology solutions for the ARCS application & delivery…

Colonnade Management Inc.

Data & Business Intelligence Analyst

Ottawa, ON, Canada

Pay: $70,000 to $80,000 CAD / year
Job type: Full-time
Posting language: English
Posted: Sep 30, 2026

Apply About employer

Applications open in a new tab.

Original job description

Colonnade BridgePort (www.colonnadebridgeport.ca) is a leading real estate investment, management and development company in Ottawa, with a growing presence across Ontario, New Brunswick, Nova Scotia, and PEI. We provide investment management, asset management, property management, leasing and development services. Our continued expansion into Québec has created an opportunity for a full-time, Data & Business Intelligence Analyst at our Ottawa office.

DATA & BUSINESS INTELLIGENCE ANALYST

Location – Ottawa, Ontario

Work Arrangement – Hybrid, 3 days per week from our head office

Employment Type – 1-year full-time contract

Reporting to the IT Manager, the Interim Data & Business Intelligence Analyst will take ownership of an established Microsoft-based data, reporting, and analytics environment. This hands-on role supports internal users and external client-facing reporting by maintaining, enhancing, and troubleshooting the full data lifecycle - from source systems and integrations through the SQL data warehouse to Power BI, SharePoint, Excel, and end-user solutions. The successful candidate will work closely with business stakeholders, technical resources, and leadership to deliver accurate, secure, reliable, and accessible information. This is a full-time interim contract based in Ottawa, with a hybrid schedule of three days per week in the office. The expected salary range is C$70,000–C$80,000 annually, commensurate with experience and qualifications.

Responsibilities:

Maintain, enhance, and troubleshoot Power BI reports, dashboards, semantic models, DAX calculations, row-level security, refresh processes, and Power BI Embedded solutions.
Develop and support complex SQL queries, views, stored procedures, functions, database objects, and the organization’s SQL data warehouse and reporting infrastructure.
Maintain and troubleshoot ETL/ELT processes, Azure Data Factory pipelines, scheduled integrations, and connections among SQL databases, Salesforce, SharePoint, Azure services, and other enterprise applications.
Support SharePoint Online lists, forms, permissions, reporting solutions, client-facing portals, Power Automate workflows, and Power Apps solutions.
Investigate data discrepancies, refresh failures, authentication and connectivity issues, and integration errors; identify root causes and independently implement or coordinate effective resolutions.
Protect data quality, accuracy, integrity, consistency, security, and authorized access across systems and reporting solutions.
Translate business and client reporting needs into scalable analytical solutions, process improvements, and workflow enhancements.
Provide operational support, maintain technical documentation, collaborate with business and technical stakeholders, and participate in system enhancements, upgrades, and reporting modernization initiatives.

Qualifications:

Five or more years of experience in data analytics, business intelligence, data warehousing, reporting, or a related role.
College diploma or university degree in Information Technology, Computer Science, Business Analytics, Data Analytics, or a related field.
Expert-level Power BI experience, including dashboard development, semantic modelling, DAX, row-level security, embedded reporting, and performance optimization.
Advanced SQL skills and a strong understanding of data warehousing, data modelling, relational database design, ETL/ELT processes, and Azure Data Factory.
Strong working knowledge of Microsoft Azure, SharePoint Online, Power Automate, Power Apps, Excel, and Power Query, including connectivity, authentication, gateways, permissions, and security concepts.
Demonstrated ability to troubleshoot complex data, reporting, refresh, connectivity, and integration issues across an end-to-end reporting environment.
Strong analytical, organizational, problem-solving, and communication skills, with the ability to manage competing priorities, work independently, and collaborate with technical and non-technical stakeholders.
Experience with Salesforce integrations or similar integration tools, Azure SQL Database, REST APIs, data migration or system implementation projects, and real estate, property management, or financial reporting environments is considered an asset.

The above statements reflect the general details considered necessary to describe functions of the job and shall not be construed as a detailed description of all work requirements that may be inherent in the job.

Commitment to our People

We are committed to creating a positive experience for our employees. We work hard at Colonnade BridgePort and have fun while doing it! Our employees enjoy participating in sports tournaments, BBQ’s, potlucks, prize draws, holiday parties and more! The successful candidate can expect the following perks and benefits:

Three weeks’ annual starting paid vacation; three days personal and five sick paid days annually.
Hybrid working environment (position dependent, alternative may be offered).
Comprehensive benefits plan that includes health, dental, vision, and disability coverage (cost shared by company and employee).
RRSP matching program.
Professional development (up to two paid courses per year).
Holiday office closure between Christmas and New Year’s, summer hours (position dependent, alternative may be offered).

To learn more about our commitment to our community and sustainability, click here.

Colonnade BridgePort acknowledges that teams with diverse backgrounds and perspectives can bring about innovative solutions and ideas. Therefore, we welcome and encourage qualified applications from people of all gender identities, visible minorities, Indiginous persons, and people with disabilities. Accommodation is available on request for candidates taking part in all aspects of the selection process. To request an accommodation, please email people @colonnadebridgeport.ca.

We thank all interested applicants; however, only those under consideration will be contacted.

Apply About employer

More about this job

Responsibilities

The analyst will manage and enhance the company's data, reporting, and analytics environment, including SQL data warehouses and Power BI solutions. They will also troubleshoot data integration issues and collaborate with stakeholders to deliver secure and accurate business information.

Requirements

Candidates must have at least five years of experience in data analytics or business intelligence and hold a relevant college diploma or university degree. Expert-level proficiency in Power BI and advanced SQL skills are required for this role.

Skills

Power BI
SQL
Data warehousing
Azure Data Factory
DAX
ETL/ELT
SharePoint Online
Power Automate
Power Apps
Data modeling
Relational database design
Salesforce
Azure services
Data analysis
Business intelligence
Technical documentation

Benefits

Health insurance
Dental insurance
Vision insurance
Disability coverage
RRSP matching
Professional development
Paid vacation
Paid sick days
Summer hours

Visa sponsorship

Not detected in the job text

Keywords

Data Analytics
Business Intelligence
Power BI
SQL
Azure Data Factory
Data Warehousing
ETL
ELT
DAX
SharePoint Online
Power Automate
Power Apps
Salesforce
Azure SQL Database
REST APIs
Data Modeling
Relational Database
Real Estate
Financial Reporting
Property Management
Data Integrity
System Integration
Dashboard Development
Semantic Modeling
Row-level Security
Power Query
Technical Documentation
Azure Services
Data Lifecycle
Business Stakeholders

Report this job