Find work in Canada.

324,175 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 16 mins ago
Financial Systems Analyst
Metro Vancouver
BC · British Columbia, Canada
Full-time
Added 1 hour ago
CAC052: Release / Class Spclst
FedEx Trade Networks Transport and Brokerage
Toronto, ON
Full-time
Minimum 5 years of experience as a Release Analyst with a Certified Customs Specialist Designation
Added 1 hour ago
Clinical Trial Financial Control Analyst, Oncology Portfolio
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
Full-time
We are seeking a Clinical Trial Financial Control Analyst to provide independent financial control and reconciliation for Oncology-sponsored clinical research studies. Reporting within the…
Added 2 hours ago
Investment Analyst
LifeSavvy Media
Montreal, QC
Full-time
Valnet is seeking a highly analytical and driven Investment Analyst to help run the acquisition lifecycle and to manage our internal investments.
Added 2 hours ago
Procure-to-Pay (P2P) Agent - ASL4
Jobbe
Moncton, NB
Full-time
Reconcile accounts, investigate discrepancies, and coordinate timely resolution of payment and accounting issues.
Added 2 hours ago
ENERGY MANAGEMENT ANALYST
City of Toronto
Toronto, ON
Reporting to the Senior Project Manager, Reporting & Compliance, the Energy Management Analyst will analyze, monitor, and track energy data in order to support implementation of energy and…
Added 3 hours ago
Claims Fraud Analyst (Insurance Claims)- EN
Global Excel Management Inc.
Windsor, ON
Full-time
Added 4 hours ago
Business Systems Analyst
CGI
Halifax, NS
Full-time
We are seeking a Business Systems Analyst to support the delivery of large-scale IT initiatives within a banking and payments environment. The role works closely with Agile Scrum teams,…
Added 4 hours ago
Winter 2027: Operations Analyst Co-op (12 months)
CGI
Toronto, ON
Full-time
…growing. We are looking for a highly motivated Sales Operations Analyst Co-op student to join our growing Business Operations team supporting the Toronto Financial Services (TFS) business…
Added 4 hours ago
Quality Assurance Analyst
Co-operators
Toronto, ON
Full-time
Under general supervision, the Quality Assurance Analyst carries out established procedures to ensure programs/projects meet minimum company standards and end user requirements. The…
Added 4 hours ago
Workday Analyst
Aston Carter
Markham, ON
$45 to $55 CAD / hour
Contract
We are seeking a skilled Workday Analyst to support end-to-end payroll processing for a large, multi-provincial workforce. The role involves participating in Workday Payroll implementation…
Added 4 hours ago
Payroll Analyst
Aston Carter
Markham, ON
$45 to $55 CAD / hour
Contract
The Payroll Analyst manages day-to-day payroll operations in a complex, high-volume environment, processing biweekly payroll for approximately 9,000 employees across Canada. This role…
Added 4 hours ago
Financial Analyst - Mental Health & Addictions
Manufacturing Job Site
Thunder Bay, ON
Full-time
Reporting to the Manager – Financial Services, the Financial Analyst – Mental Health & Addictions (MH&A) is responsible for supporting the MH&A portfolio through statistical data analysis,…
Added 5 hours ago
Senior Financial Analyst
La Rocca Creative Cakes
Richmond Hill, ON
Full-time
Perform the month-end close process, working with accounting and operations teams to ensure financial results are accurate, complete, and delivered on schedule.
Added 5 hours ago
Business Analyst
McAsphalt Industries Limited
Toronto, ON · Scarborough, ON
Full-time
The Business Analyst, Corporate Development is a skills-based analytical role suited to someone who can combine financial acumen, business curiosity, strong data skills, and clear…
Added 5 hours ago
Bilingual Insurance Claims Analyst
DXC Technology
Canada
Full-time
Added 5 hours ago
Senior Analyst
U3 Advisors
Cambridge, ON
Full-time
U3 Advisors is seeking a Senior Analyst to join our team full-time in our Boston (Cambridge) office. Senior Analysts work on projects across our consulting firm, providing critical research…
Added 5 hours ago
Data Analyst Lead
Affinity
Vancouver, BC
Contract
On behalf of our client, Affinity is seeking a Data Analyst Lead to advance enterprise data platform reporting. This role is responsible for leading a squad dedicated to Equity Financial…
Added 5 hours ago
Project Manager/Business Analyst
TEEMA
Calgary, AB
Contract
Our client is looking for a senior Project Manager / Business Analyst to support the Procure to Pay (P2P) workstream within Project Fusion, a major enterprise transformation program. The…
Added 5 hours ago
Senior Financial Analyst
Coca-Cola Canada Bottling Limited
Toronto, ON
Full-time
2 or more years of experience in accounting including account analysis and reconciliation
Added 5 hours ago
Analytics Lead, Central Market Management
CapitalG
Toronto, ON
Full-time
We are looking for an analyst to join the Central Market Management team and help us grow our market share. You will work with cross-functional stakeholders to analyze and improve existing…
Added 5 hours ago
Claims Fraud Analyst (Insurance Claims)- EN
Global Excel Management Inc.
Sherbrooke, QC
Full-time
Added 6 hours ago
Accounting Analyst
AtkinsRéalis
Toronto, ON
Full-time
…opportunity to make a meaningful impact through financial reporting, accounting accuracy, and operational…
Added 6 hours ago
Senior Relationship Manager (Banking & Custody)
The Citco Group Limited
Toronto, ON
Full-time
Responsible for co-coordinating with system developers and business analyst in providing client support, routine preventative maintenance, and continuing improvements of the business`…
Added 7 hours ago
Credit Analyst
SRS Distribution Inc.
Nanaimo, BC
Full-time
Reporting to the Credit Manager, the Credit Analyst focuses on key customer accounts as well as working with the AR team providing support where needed.

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