Find work in Canada.

322,693 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 19 mins ago
Analyst, Store Accounting (Maternity leave replacement)
Couche-Tard
Laval, QC
Full-time
…within the Operational Accounting team, the Store Accounting Analyst will provide an accounting service to the stores under his responsibility while analyzing what concerns the merchandise…
Added 35 mins ago
Senior Analyst, AI Enablement & Analytics (12 Month Contract)
The Canada Life Assurance Company
Winnipeg, MB · London, ON · Toronto, ON
The Senior Data Analyst leads analytical framing, experimentation, business analysis, value realization, stakeholder engagement, and solution delivery support for AI-enabled business…
Added 1 hour ago
IT Business Operations Analyst
DIRTT
AB · Calgary, AB
Full-time
Operating across workplace, healthcare, education, and public sector markets, DIRTT provides total design freedom and greater certainty in cost, schedule, and outcomes.
Added 1 hour ago
Data Management Analyst
White Cap Canada
Vaughan, ON
Full-time
…responsibility for, but not limited to: product file maintenance; cost matrix maintenance; price matrix maintenance; employee and organizational hierarchy; vendor file maintenance; and /or…
Added 1 hour ago
eDiscovery Case Manager
Urban Legal Recruitment Inc.
Calgary, AB · Greater Calgary Metropolitan Area
Full-time
…processed, reviewed and produced in an efficient, defensible and cost-effective…
Added 1 hour ago
Materials Analyst-Technical
WestJet Group
Calgary, AB
Reporting to Sr. Manager, Demand Management, the Materials Analyst-Technical is responsible for planning, positioning, and optimizing rotable and repairable component inventory to ensure…
Added 1 hour ago
Senior Business Analyst - Infrastructure Cost Management
Electronic Arts
Vancouver, BC
…millions of players globally. You will report to the Director Cost and Capacity Management. You will guide our cloud and SaaS cost management, using automation and analytics to improve how…
Added 2 hours ago
V.I.E. Programmer Analyst Pre-trade applications
Societe Generale
Montreal, QC
Full-time
…conditions in terms of technological standards, service quality and cost. GBTO is composed of diverse and talented professionals who translate ideas into action every day by combining the…
Added 2 hours ago
Pricing Analyst
ICS Courier
Brampton, ON
Full-time
At ICS Courier, we are a leader in the courier and logistics industry, providing reliable, fast, and cost-effective delivery solutions for businesses across Canada. We are a subsidiary of…
Added 2 hours ago
Sourcing Manager- Human Resources Category Lead
Societe Generale
Montreal, QC
Full-time
An Analyst/Associate– Sourcing Manager for HR category within Société Générale (“SG”) Americas Sourcing Department supports the overall goals of the Global Sourcing Department in Paris…
Added 2 hours ago
Senior Business Project Manager
Dacaro Services
Toronto, ON · Greater Toronto Area, Canada
Contract
Manage project scope, schedule, cost, quality, risks, issues, assumptions, and dependencies.
Added 2 hours ago
Senior Financial Analyst, Financial Planning & Analysis
Superior Gas Liquids
Calgary, AB
Full-time
Reporting to the Controller, the Senior Financial Analyst is responsible for gathering and manipulating large amounts of data from multiple sources to analyze and develop Operational,…
Added 2 hours ago
IT-Information Technology_260-IT Airline Ops - Analyst
WestJet Group
Calgary, AB
Reporting to the Manager, IT Airport Platforms, the Airport Systems Analyst is a technical resource supporting multiple end user groups and project teams from the Airports business unit.…
Added 2 hours ago
Senior Analyst, Financial Planning & Analysis - Superior Gas Liquids
Superior Plus Propane Talent Acquisition
Calgary, AB
Reporting to the Controller, the Senior Financial Analyst is responsible for gathering and manipulating large amounts of data from multiple sources to analyze and develop Operational,…
Added 2 hours ago
Digital Workplace Analyst
Legislative Assembly of British Columbia
Victoria, BC
Full-time
The Information Technology department is seeking a strategic, analytical and service-oriented individual for the regular full-time position of Digital Workplace Analyst.
Added 2 hours ago
Business Analyst
City of Winnipeg
Winnipeg, MB
Full-time
Reporting to the Coordinator of Business Analysis and Quality Assurance, the Business Analyst is responsible for leading the elicitation, communication, analysis, and documentation of the…
Added 2 hours ago
Policy Analyst
Government of Alberta
AB
The Policy Analyst supports Alberta’s commitment to remaining a highly competitive destination for domestic and international investment. The position provides strategic analysis, develops…
Added 4 hours ago
Project Controls Coordinator III
Raise
Calgary, AB
Full-time
We are seeking a detail-oriented Field Control Analyst to support project controls, cost tracking, reporting, and contractor management activities for capital construction and operations…
Added 4 hours ago
Senior FP&A Analyst
Coveo
Montreal, QC
Full-time
…decisions shaping Coveo’s revenue growth? As a Senior FP&A Analyst supporting our Sales and Customer Experience teams, you’ll play an active role in the strategic decisions that fuel our…
Added 4 hours ago
Business Analyst / Analyste d’affaires
Glencore Canada
Laval, QC
Full-time
Reporting to the Finance Manager, the Business Analyst plays a key role in supporting the financial and operational performance through accurate reporting, insightful analysis, and…
Added 5 hours ago
Financial Analyst
Hays
Belleville, ON
Full-time
As the organization continues to grow, they are seeking a Financial Analyst to join their team and play a key role in supporting both financial performance and operational decision-making.
Added 13 hours ago
Procure-to-Pay (P2P) Agent - ASL4
Jobbe
Moncton, NB
Full-time
Identify cost-saving opportunities, process improvements, risk mitigation measures, and efficiency improvements across procurement and P2P operations.
Added 13 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 16 hours ago
Senior Financial Analyst
La Rocca Creative Cakes
Richmond Hill, ON
Full-time
Prepare monthly variance analysis on P&L and balance sheet results, translating drivers (volume, mix, input cost, labour) into plain-language explanations for management and corporate…
Added 17 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…

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