Data & Business Intelligence Analyst

Colonnade BridgePort Inc.; Ottawa; Hybrid; CAD 70,000 - 80,000; Full time

Benefits offered by this job

Three weeks’ vacation

Hybrid work environment

Benefits plan (health, dental, vision)

RRSP matching

Professional development

Job summary

Colonnade BridgePort Inc. in Ottawa is seeking a Data & Business Intelligence Analyst to own the data, reporting, and analytics lifecycle from source systems to Power BI and end-user solutions.

The role is hybrid (3 days per week in the office) and full-time on a 1-year contract, reporting to the IT Manager. You will collaborate with business stakeholders, ensure data quality and security, and support SharePoint, Azure, and Salesforce integrations.

Qualifications

• Five or more years in data analytics, BI, data warehousing or related roles.
• College diploma or university degree in IT, CS, or analytics.
• Expert Power BI with dashboard development, semantic modelling and DAX.
• Advanced SQL and data warehousing knowledge, ETL/ELT and Azure Data Factory.
• Strong knowledge of Azure, SharePoint Online, Power Automate and Power Apps.

Responsibilities

• Maintain, enhance, and troubleshoot Power BI reports and dashboards.
• Develop and optimize complex SQL queries and data warehouse objects.
• Maintain ETL/ELT processes and Azure Data Factory pipelines.
• Support SharePoint Online lists, forms, and Power Apps/Power Automate solutions.
• Investigate data issues and implement effective resolutions.
• Ensure data quality, security, and access across systems.
• Translate reporting needs into scalable analytical solutions.
• Provide documentation and collaborate with stakeholders on upgrades.

Skills

Data analytics

Power BI

SQL

Azure

SharePoint Online

Power Automate

Power Apps

Excel

Education

Information Technology/Computer Science/Data Analytics degree

Tools

Power BI

SQL

Azure Data Factory

SharePoint Online

Power Query

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

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, alternate 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, alternate may be offered).

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.