Power BI Data Analyst Ottawa

Power BI and SQL expertise define this on-site Data Analyst opportunity in Ottawa, supporting dashboards, reporting, and business insights.

This junior-to-mid-level Data Analyst designs and maintains analytical solutions for a complex operational environment. You will work with Microsoft Fabric, Azure Data Services, dimensional models, and Python/Pandas. Clear communication, listening, and stakeholder understanding are essential when translating requirements into useful reporting solutions.

Key Responsibilities:

• Design and maintain Power BI dashboards, reports, and performance metrics
• Develop SQL queries for extracting, transforming, and analyzing data
• Build dimensional and semantic models for reporting and analytics
• Translate stakeholder requirements into effective analytical solutions
• Communicate findings as clear, actionable business insights

Requirements:

• Three or more years in data analysis or business intelligence
• Three or more years developing Power BI reports and dashboards
• Strong SQL skills with large datasets
• Experience with Microsoft Fabric or comparable cloud analytics platforms
• Experience using Python/Pandas and dimensional data modelling

Bring Power BI, SQL, Microsoft Fabric, and stakeholder communication skills to Data Analyst work in Ottawa.