Hybrid Data & BI Analyst — Power BI, SQL & Azure

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

Benefits offered by this job

Three weeks' annual vacation

Hybrid work schedule

Comprehensive benefits

RRSP matching

Professional development

Holiday office closure

Job summary

Colonnade BridgePort in Ottawa is seeking an Interim Data & Business Intelligence Analyst to own a Microsoft-based data, reporting, and analytics environment. Hybrid work: three days in the head office. Salary range C$70,000-C$80,000 annually, commensurate with experience.

Responsibilities include maintaining Power BI reports, developing SQL queries, ETL/ELT processes, and supporting SharePoint Online and Power Platform solutions. Collaboration with stakeholders and leadership is essential.

Qualifications

• Five+ years in data analytics/BI/data warehousing or related role.
• Expert Power BI experience including dashboard development and modelling.
• Advanced SQL skills and understanding of ETL/ELT and data warehousing.
• Experience with Azure data services and SharePoint Online.

Responsibilities

• Maintain, enhance, and troubleshoot Power BI reports, dashboards, and semantic models.
• Develop and support complex SQL queries and the data warehouse objects.
• Maintain ETL/ELT processes and Azure Data Factory pipelines.
• Support SharePoint Online lists, forms, and Power Platform solutions.
• Investigate data issues and implement resolutions; ensure data quality and security.
• Translate business needs into scalable analytics solutions and workflows.
• Provide operational support and document technical processes.

Skills

Power BI

SQL

Analytical thinking

Problem solving

Communication

Education

College/university degree in IT/CS/Business Analytics

Tools

Power BI

Azure Data Factory

SharePoint Online

Excel

Power Automate

Power Apps

SQL Server

Job description

Colonnade BridgePort in Ottawa is seeking an Interim Data & Business Intelligence Analyst to own a Microsoft-based data, reporting, and analytics environment. Hybrid work: three days in the head office. Salary range C$70,000-C$80,000 annually, commensurate with experience.

Responsibilities include maintaining Power BI reports, developing SQL queries, ETL/ELT processes, and supporting SharePoint Online and Power Platform solutions. Collaboration with stakeholders and leadership is essential.