Find work in Canada.

325,757 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 27 mins ago
Test Automation Engineer
Accenture
Mississauga, ON
Full-time
…by leveraging innovation, intelligence, industry insights, new IT, and new technology skills. With the global environment changing at a faster pace, our clients are facing unprecedented…
Added 41 mins ago
Loan Administrator / Loan Operations Analyst
Astek
Montreal, QC
Full-time
Au sein des équipes Loan Operations OPC-FTO, en coordination avec les groupes de soutien aux affaires situés à New York et à Mumbai, notre client cherche un(e) Administrateur(trice) de…
Added 42 mins ago
HRIS Analyst (Payroll, Absence & Time Tracking)
Extendicare
Markham, ON · Extendicare (Canada) Inc (Steeles Ave.)
Full-time
Reporting to the Senior Manager, HRIS, the HRIS Analyst (Payroll, Absence & Time Tracking) will support the ongoing configuration, enhancement and optimization of Workday Payroll, Absence…
Added 42 mins ago
HRIS Analyst (HCM, Recruitment & Learning)
Extendicare
Markham, ON · Extendicare (Canada) Inc (Steeles Ave.)
Full-time
Reporting to the Senior Manager, HRIS, the HR Systems Analyst, Workday (HCM, Recruitment & Learning) will be responsible for configuring, enhancing and optimizing Workday Core HCM,…
Added 42 mins ago
Broker Bill Analyst (12 Month Contract)
Northbridge Financial
Toronto, ON
Full-time
What it’s like to be a Northbridge Broker Bill Analyst
Added 56 mins ago
Inventory Control Clerk
Honeywell Aerospace
Cambridge, ON
Full-time
The position works closely with the Inventory Analyst to identify, investigate, and resolve inventory discrepancies, improve inventory accuracy, support KPI reporting, and maintain…
Added 1 hour ago
Business Analyst Student - (12 months) - Winter Term 2027
Canadian Tire Corporation
Mississauga, ON
Full-time
…our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and…
Added 1 hour ago
Data & Business Intelligence Analyst
Colonnade Management Inc.
Ottawa, ON
$70,000 to $80,000 CAD / year
Full-time
…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…
Added 1 hour ago
Credit Analyst
Franklin Empire Inc
Toronto, ON · Kitchener, ON
$50,000 to $55,000 CAD / year
Franklin Empire Inc. is a family-owned distributor providing electrical supplies for new construction, renovation and the maintenance of industrial plants, residential and commercial…
Added 1 hour ago
Technical Support Analyst
Bayshore
Markham, ON
…achievement as a Platinum member of Canada’s Best Managed Companies Program every year since 2006. In 2015, Bayshore achieved the designation for Best Practice Spotlight Organization from…
Added 1 hour ago
Customer Success Coordinator / Coordonnateur ou coordonnatrice, succès client
Fundica
Montreal, QC
Full-time
You will work alongside the President, business development, marketing, product, software development, and funding analyst team. You will support our growth in both the US and Canada by…
Added 1 hour ago
Financial Analyst, AR and Revenue (Contract)
Resource Productivity and Recovery Authority
Toronto, ON
Contract
We are looking for a talented and committed individual to join us as Financial Analyst (AR and Revenue) to support the government’s efforts to protect the environment and advance a new…
Added 1 hour ago
Junior Funding Analyst, Investment Management
KV Capital
AB · Edmonton, AB
Full-time
Reporting to the Director, Investment Management, the Junior Funding Analyst, Investment Management is responsible for conducting thorough review of funding conditions, preparing draws for…
Added 2 hours ago
Senior Financial Analyst
CONA Services
Toronto, ON
Assist in building new and optimizing current reports to provide insights into manufacturing variances vs BP
Added 2 hours ago
Sr Analyst, Reporting and Analytics
The Home Depot Canada
Toronto, ON
Full-time
…bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and…
Added 3 hours ago
Solution Product Marketing Manager - Canada
ActiveProspect, Inc.
Remote, Canada
Full-time · Remote
Develop and maintain a structured market research program focused on customer needs, market dynamics, category trends, emerging use cases, and growth opportunities.
Added 3 hours ago
Broker Bill Analyst (12 Month Contract)
Northbridge Financial Corporation
Toronto, ON
Full-time
What it’s like to be a Northbridge Broker Bill Analyst
Added 3 hours ago
Co-Op, Development Operations AI & Automation Enablement Intern
Alexion Pharmaceuticals, Inc.
Mississauga, ON
Full-time
The AI Solutions & Development Operations Analyst Co-op supports the Development Operations Enterprise Optimization team in advancing digital transformation, AI-enabled ways of working,…
Added 4 hours ago
Business Operations Analyst
Export Packers
Brampton, ON
Full-time
Reporting to the Director of Sales and Operational Excellence, the Business Operations Analyst will serve as a key financial and analytical partner to the Canadian Foodservice Division,…
Added 4 hours ago
Senior Financial Analyst, Financial Information and Controls
Alimentation Couche-Tard
Laval, QC
Full-time
Mentorship Program: Take your career to new heights with our mentorship program, where seasoned professionals provide guidance, support, and valuable insights to help you reach your full…
Added 4 hours ago
Senior Financial Analyst, Supply Chain Accounting (16 Month Contract)
Canadian Tire Corporation
Toronto, ON
$85,000 to $95,000 CAD / year
Full-time
Reporting to the Manager of Business Accounting, this position provides a unique insight into new projects, contracts, and financial results. The Senior Financial Analyst, Supply Chain…
Added 4 hours ago
Railcar Data Analyst
Cando Rail & Terminals
Sturgeon, AB
Full-time
Railcar Data Analyst is a self-starter with strong organization, communication, interpersonal, accounting, and computer skills. If you enjoy working within a team, problem solving, and a…
Added 4 hours ago
Senior Manager, Investment Analysis
Clearlight Energy
Oakville, ON
Full-time
Build the capability of the function over time - hiring, onboarding, training, performance management and succession for the analyst group
Added 5 hours ago
Programmer Analyst (IT Application)
Saskatchewan Liquor & Gaming Authority (SLGA)
Regina, SK
$31.57 to $40.16 CAD / hour
Full-time
Permanent Full-Time Programmer Analyst (IT Application)
Added 5 hours ago
Actuarial Analyst II
TD
Toronto, ON · Montreal, QC
Full-time
Experienced working professional role providing specialized business services, advisory or processes / program support within their own area of specialty

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