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
🏢 Myticas Consulting
📍 Ottawa