Power BI and SQL expertise define this in office 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.

📌 Power BI Data Analyst Ottawa (Quebec City)
🏢 Myticas Consulting
📍 Quebec City